{"id":58020,"date":"2022-05-26T23:42:49","date_gmt":"2022-05-26T23:42:49","guid":{"rendered":"https:\/\/merikebi.warrenmyers.com\/?p=58020"},"modified":"2022-05-26T23:42:49","modified_gmt":"2022-05-26T23:42:49","slug":"answer-by-warren-for-3d-graph-network-topology-visualization-lengthy-time-to-build-graph-visualizer","status":"publish","type":"post","link":"https:\/\/merikebi.warrenmyers.com\/?p=58020","title":{"rendered":"Answer by warren for 3D Graph Network Topology Visualization: Lengthy Time to Build Graph Visualizer"},"content":{"rendered":"<p>See if this simplified version helps you at all (<code>dedup<\/code> is rarely the proper tool to use, and is almost always pointless to run before <code>stats<\/code> in the manner you&#8217;re doing it):<\/p>\n<pre><code>index=test source=mysource vendor=* myaddress=* myneighboraddress=*\n| fields - _raw\n| fields myaddress myneighboraddress vendor\n| stats count by myaddress myneighboraddress \n<\/code><\/pre>\n<p>Depending on the size of events, dropping <code>_raw<\/code> can be a huge performance improver. Likewise to only keeping the fields you care about<\/p>\n<p>I removed the <code>values(vendor)<\/code> since your <code>| table<\/code> was immediately removing it<\/p>\n<p>If you want it left in, do this <code>stats<\/code> line instead:<\/p>\n<pre><code>| stats values(vendor) as vendors count by myaddress myneighboraddress \n<\/code><\/pre>\n<p>from User warren &#8211; Stack Overflow https:\/\/stackoverflow.com\/questions\/72395393\/3d-graph-network-topology-visualization-lengthy-time-to-build-graph-visualizer\/72399088#72399088<br \/>\nvia <a href=\"https:\/\/ifttt.com\/?ref=da&#038;site=wordpress\">IFTTT<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>See if this simplified version helps you at all (dedup is rarely the proper tool to use, and is almost always pointless to run before stats in the manner you&#8217;re doing it): index=test source=mysource vendor=* myaddress=* myneighboraddress=* | fields &#8211; _raw | fields myaddress myneighboraddress vendor | stats count by myaddress myneighboraddress Depending on the &hellip;<br \/><a href=\"https:\/\/merikebi.warrenmyers.com\/?p=58020\" class=\"more-link pen_button pen_element_default pen_icon_arrow_double\">Continue reading <span class=\"screen-reader-text\">Answer by warren for 3D Graph Network Topology Visualization: Lengthy Time to Build Graph Visualizer<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[991],"keyring_services":[],"class_list":["post-58020","post","type-post","status-publish","format-standard","hentry","category-blih","tag-stackexchange"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts\/58020","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=58020"}],"version-history":[{"count":1,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts\/58020\/revisions"}],"predecessor-version":[{"id":58021,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts\/58020\/revisions\/58021"}],"wp:attachment":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=58020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=58020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=58020"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fkeyring_services&post=58020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}