{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,20]],"date-time":"2026-07-20T10:18:33Z","timestamp":1784542713914,"version":"3.55.0"},"reference-count":9,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2012,8]]},"abstract":"<jats:p>Searching for the performance bottleneck in an execution trace is an error prone and time consuming activity. Existing tools offer some comfort by providing a visual representation of trace for analysis. In this paper we present the Stethoscope, an interactive visual tool to inspect and analyze columnar database query performance, both online and offline. It's unique interactive animated interface capitalizes the large data-flow graph representation of a query execution plan, augmented with query execution trace information. We demonstrate features of Stethoscope for both online and offline analysis of long running queries. It helps in understanding where time goes, how optimizers perform, and how parallel processing on multi-core systems is exploited.<\/jats:p>","DOI":"10.14778\/2367502.2367539","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1926-1929","source":"Crossref","is-referenced-by-count":7,"title":["Stethoscope"],"prefix":"10.14778","volume":"5","author":[{"given":"Mrunal","family":"Gawade","sequence":"first","affiliation":[{"name":"CWI, Amsterdam"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Martin","family":"Kersten","sequence":"additional","affiliation":[{"name":"CWI, Amsterdam"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2012,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1109\/VLHCC.2005.11"},{"key":"e_1_2_1_2_1","unstructured":"com.atypon.pdfplus.internal.model.plusxml.impl.AuthorGroup@7088cc6f\n   http:\/\/www.graphviz.org\/Documentation\/dotguide.pdf  Drawing graphs with dot. http:\/\/www.graphviz.org\/Documentation\/dotguide.pdf"},{"key":"e_1_2_1_3_1","unstructured":"com.atypon.pdfplus.internal.model.plusxml.impl.AuthorGroup@74b756a6 www.monetdb.org.  MonetDB www.monetdb.org."},{"key":"e_1_2_1_4_1","unstructured":"com.atypon.pdfplus.internal.model.plusxml.impl.AuthorGroup@31b5c654 www.graphviz.org.  GraphViz www.graphviz.org."},{"key":"e_1_2_1_5_1","unstructured":"com.atypon.pdfplus.internal.model.plusxml.impl.AuthorGroup@3613fc39 www.graphviz.org\/doc\/info\/lang.html.  DOT www.graphviz.org\/doc\/info\/lang.html."},{"key":"e_1_2_1_6_1","unstructured":"com.atypon.pdfplus.internal.model.plusxml.impl.AuthorGroup@4eb520 www.tpc.org\/tpch.  TPC-H Benchmark www.tpc.org\/tpch."},{"key":"e_1_2_1_7_1","unstructured":"com.atypon.pdfplus.internal.model.plusxml.impl.AuthorGroup@4e02d1e9 www.zvtm.sourceforge.net\/zgrviewer.html.  ZGrviewer www.zvtm.sourceforge.net\/zgrviewer.html."},{"key":"e_1_2_1_8_1","unstructured":"com.atypon.pdfplus.internal.model.plusxml.impl.AuthorGroup@519a391b www.zvtm.sourceforge.net.  ZVTM www.zvtm.sourceforge.net."},{"key":"e_1_2_1_9_1","unstructured":"com.atypon.pdfplus.internal.model.plusxml.impl.AuthorGroup@7841f525 www.monetdb.org\/Documentation\/Manuals\/MonetDB\/MALreference.  MAL www.monetdb.org\/Documentation\/Manuals\/MonetDB\/MALreference."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2367502.2367539","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:49:33Z","timestamp":1672224573000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2367502.2367539"}},"subtitle":["a platform for interactive visual analysis of query execution plans"],"short-title":[],"issued":{"date-parts":[[2012,8]]},"references-count":9,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2012,8]]}},"alternative-id":["10.14778\/2367502.2367539"],"URL":"https:\/\/doi.org\/10.14778\/2367502.2367539","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2012,8]]}}}