Google Git
Sign in
apache / druid-website-src / fe9bf43cbd4ee63e6f11002e4c741eef24c6d2e3 / . / published_versions / docs / latest / operations / request-logging / index.html
blob: 58389539f6daa4a61cf7a7040d1159e36331da14 [file] [log] [blame]
<!doctype html>
<html lang="en" dir="ltr" class="docs-wrapper docs-doc-page docs-version-current plugin-docs plugin-id-default docs-doc-id-operations/request-logging">
<head>
<meta charset="UTF-8">
<meta name="generator" content="Docusaurus v2.4.1">
<title data-rh="true">Request logging | Apache® Druid</title><meta data-rh="true" name="viewport" content="width=device-width,initial-scale=1"><meta data-rh="true" name="twitter:card" content="summary_large_image"><meta data-rh="true" property="og:image" content="https://druid.apache.org/img/druid_nav.png"><meta data-rh="true" name="twitter:image" content="https://druid.apache.org/img/druid_nav.png"><meta data-rh="true" property="og:url" content="https://druid.apache.org/docs/latest/operations/request-logging"><meta data-rh="true" name="docusaurus_locale" content="en"><meta data-rh="true" name="docsearch:language" content="en"><meta data-rh="true" name="docusaurus_version" content="current"><meta data-rh="true" name="docusaurus_tag" content="docs-default-current"><meta data-rh="true" name="docsearch:version" content="current"><meta data-rh="true" name="docsearch:docusaurus_tag" content="docs-default-current"><meta data-rh="true" property="og:title" content="Request logging | Apache® Druid"><meta data-rh="true" name="description" content="&lt;!--"><meta data-rh="true" property="og:description" content="&lt;!--"><link data-rh="true" rel="icon" href="/img/favicon.png"><link data-rh="true" rel="canonical" href="https://druid.apache.org/docs/latest/operations/request-logging"><link data-rh="true" rel="alternate" href="https://druid.apache.org/docs/latest/operations/request-logging" hreflang="en"><link data-rh="true" rel="alternate" href="https://druid.apache.org/docs/latest/operations/request-logging" hreflang="x-default"><link rel="preconnect" href="https://www.google-analytics.com">
<link rel="preconnect" href="https://www.googletagmanager.com">
<script async src="https://www.googletagmanager.com/gtag/js?id=UA-131010415-1"></script>
<script>function gtag(){dataLayer.push(arguments)}window.dataLayer=window.dataLayer||[],gtag("js",new Date),gtag("config","UA-131010415-1",{})</script>
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.7.2/css/all.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/clipboard.js/2.0.4/clipboard.min.js"></script><link rel="stylesheet" href="/assets/css/styles.f80751b3.css">
<link rel="preload" href="/assets/js/runtime~main.dc5f839a.js" as="script">
<link rel="preload" href="/assets/js/main.a03dfc13.js" as="script">
</head>
<body class="navigation-with-keyboard">
<script>!function(){function t(t){document.documentElement.setAttribute("data-theme",t)}var e=function(){var t=null;try{t=new URLSearchParams(window.location.search).get("docusaurus-theme")}catch(t){}return t}()||function(){var t=null;try{t=localStorage.getItem("theme")}catch(t){}return t}();t(null!==e?e:"light")}()</script><div id="__docusaurus">
<div role="region" aria-label="Skip to main content"><a class="skipToContent_fXgn" href="#__docusaurus_skipToContent_fallback">Skip to main content</a></div><nav aria-label="Main" class="navbar navbar--fixed-top navbar--dark"><div class="navbar__inner"><div class="navbar__items"><button aria-label="Toggle navigation bar" aria-expanded="false" class="navbar__toggle clean-btn" type="button"><svg width="30" height="30" viewBox="0 0 30 30" aria-hidden="true"><path stroke="currentColor" stroke-linecap="round" stroke-miterlimit="10" stroke-width="2" d="M4 7h22M4 15h22M4 23h22"></path></svg></button><a class="navbar__brand" href="/"><div class="navbar__logo"><img src="/img/druid_nav.png" alt="Apache® Druid" class="themedImage_ToTc themedImage--light_HNdA"><img src="/img/druid_nav.png" alt="Apache® Druid" class="themedImage_ToTc themedImage--dark_i4oU"></div></a></div><div class="navbar__items navbar__items--right"><a class="navbar__item navbar__link" href="/technology">Technology</a><a class="navbar__item navbar__link" href="/use-cases">Use Cases</a><a class="navbar__item navbar__link" href="/druid-powered">Powered By</a><a class="navbar__item navbar__link" href="/docs/latest/design/">Docs</a><a class="navbar__item navbar__link" href="/community/">Community</a><div class="navbar__item dropdown dropdown--hoverable dropdown--right"><a href="#" aria-haspopup="true" aria-expanded="false" role="button" class="navbar__link">Apache®</a><ul class="dropdown__menu"><li><a href="https://www.apache.org/" target="_blank" rel="noopener noreferrer" class="dropdown__link">Foundation<svg width="12" height="12" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li><a href="https://apachecon.com/?ref=druid.apache.org" target="_blank" rel="noopener noreferrer" class="dropdown__link">Events<svg width="12" height="12" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li><a href="https://www.apache.org/licenses/" target="_blank" rel="noopener noreferrer" class="dropdown__link">License<svg width="12" height="12" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li><a href="https://www.apache.org/foundation/thanks.html" target="_blank" rel="noopener noreferrer" class="dropdown__link">Thanks<svg width="12" height="12" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li><a href="https://www.apache.org/security/" target="_blank" rel="noopener noreferrer" class="dropdown__link">Security<svg width="12" height="12" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li><a href="https://www.apache.org/foundation/sponsorship.html" target="_blank" rel="noopener noreferrer" class="dropdown__link">Sponsorship<svg width="12" height="12" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li></ul></div><a class="navbar__item navbar__link" href="/downloads/">Download</a><div class="searchBox_ZlJk"><div class="navbar__search"><span aria-label="expand searchbar" role="button" class="search-icon" tabindex="0"></span><input type="search" id="search_input_react" placeholder="Loading..." aria-label="Search" class="navbar__search-input search-bar" disabled=""></div></div></div></div><div role="presentation" class="navbar-sidebar__backdrop"></div></nav><div id="__docusaurus_skipToContent_fallback" class="main-wrapper mainWrapper_z2l0 docsWrapper_BCFX"><button aria-label="Scroll back to top" class="clean-btn theme-back-to-top-button backToTopButton_sjWU" type="button"></button><div class="docPage__5DB"><aside class="theme-doc-sidebar-container docSidebarContainer_b6E3"><div class="sidebarViewport_Xe31"><div class="sidebar_njMd"><nav aria-label="Docs sidebar" class="menu thin-scrollbar menu_SIkG"><ul class="theme-doc-sidebar-menu menu__list"><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/latest/design/">Getting started</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/latest/tutorials/tutorial-msq-extern">Tutorials</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/latest/design/architecture">Design</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/latest/ingestion/">Ingestion</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/latest/data-management/">Data management</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/latest/querying/sql">Querying</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/latest/api-reference/">API reference</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/latest/configuration/">Configuration</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret menu__link--active" aria-expanded="true" href="/docs/latest/operations/web-console">Operations</a></div><ul style="display:block;overflow:visible;height:auto" class="menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/latest/operations/web-console">Web console</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/latest/operations/java">Java runtime</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/latest/operations/durable-storage">Durable storage</a></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" tabindex="0" href="/docs/latest/operations/security-overview">Security</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" tabindex="0" href="/docs/latest/operations/basic-cluster-tuning">Performance tuning</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret menu__link--active" aria-expanded="true" tabindex="0" href="/docs/latest/operations/request-logging">Monitoring</a></div><ul style="display:block;overflow:visible;height:auto" class="menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link menu__link--active" aria-current="page" tabindex="0" href="/docs/latest/operations/request-logging">Request logging</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/latest/operations/metrics">Metrics</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/latest/operations/alerts">Alerts</a></li></ul></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/latest/operations/high-availability">High availability</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/latest/operations/rolling-updates">Rolling updates</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/latest/operations/rule-configuration">Using rules to drop and retain data</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/latest/operations/migrate-from-firehose">Migrate from firehose</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/latest/operations/other-hadoop">Working with different versions of Apache Hadoop</a></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" tabindex="0" href="/docs/latest/operations/dump-segment">Misc</a></div></li></ul></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/latest/development/overview">Development</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/latest/misc/papers-and-talks">Misc</a></div></li></ul></nav></div></div></aside><main class="docMainContainer_gTbr"><div class="container padding-top--md padding-bottom--lg"><div class="row"><div class="col docItemCol_VOVn"><div class="docItemContainer_Djhp"><article><nav class="theme-doc-breadcrumbs breadcrumbsContainer_Z_bl" aria-label="Breadcrumbs"><ul class="breadcrumbs" itemscope="" itemtype="https://schema.org/BreadcrumbList"><li class="breadcrumbs__item"><a aria-label="Home page" class="breadcrumbs__link" href="/"><svg viewBox="0 0 24 24" class="breadcrumbHomeIcon_YNFT"><path d="M10 19v-5h4v5c0 .55.45 1 1 1h3c.55 0 1-.45 1-1v-7h1.7c.46 0 .68-.57.33-.87L12.67 3.6c-.38-.34-.96-.34-1.34 0l-8.36 7.53c-.34.3-.13.87.33.87H5v7c0 .55.45 1 1 1h3c.55 0 1-.45 1-1z" fill="currentColor"></path></svg></a></li><li class="breadcrumbs__item"><span class="breadcrumbs__link">Operations</span><meta itemprop="position" content="1"></li><li class="breadcrumbs__item"><span class="breadcrumbs__link">Monitoring</span><meta itemprop="position" content="2"></li><li itemscope="" itemprop="itemListElement" itemtype="https://schema.org/ListItem" class="breadcrumbs__item breadcrumbs__item--active"><span class="breadcrumbs__link" itemprop="name">Request logging</span><meta itemprop="position" content="3"></li></ul></nav><div class="tocCollapsible_ETCw theme-doc-toc-mobile tocMobile_ITEo"><button type="button" class="clean-btn tocCollapsibleButton_TO0P">On this page</button></div><div class="theme-doc-markdown markdown"><header><h1>Request logging</h1></header><p>All Apache Druid services that can serve queries can also log the query requests they process.
Request logs contain information on query metrics, including execution time and memory usage.
You can use information in the request logs to monitor query performance, determine bottlenecks, and analyze and improve slow queries.</p><p>Request logging is disabled by default.
This topic describes how to configure Druid to generate request logs to track query metrics.</p><h2 class="anchor anchorWithStickyNavbar_LWe7" id="configure-request-logging">Configure request logging<a href="#configure-request-logging" class="hash-link" aria-label="Direct link to Configure request logging" title="Direct link to Configure request logging">​</a></h2><p>To enable request logging, determine the type of request logger to use, then set the configurations specific to the request logger type.</p><p>The following request logger types are available:</p><ul><li><code>noop</code>: Disables request logging, the default behavior.</li><li><a href="/docs/latest/configuration/#file-request-logging"><code>file</code></a>: Stores logs to disk.</li><li><a href="/docs/latest/configuration/#emitter-request-logging"><code>emitter</code></a>: Logs request to an external location, which is configured through an emitter.</li><li><a href="/docs/latest/configuration/#slf4j-request-logging"><code>slf4j</code></a>: Logs queries via the SLF4J Java logging API.</li><li><a href="/docs/latest/configuration/#filtered-request-logging"><code>filtered</code></a>: Filters requests by query type or execution time before logging the filtered queries by the delegated request logger.</li><li><a href="/docs/latest/configuration/#composing-request-logging"><code>composing</code></a>: Logs all requests to multiple request loggers.</li><li><a href="/docs/latest/configuration/#switching-request-logging"><code>switching</code></a>: Logs native queries and SQL queries to separate request loggers.</li></ul><p>Define the type of request logger in <code>druid.request.logging.type</code>.
See the <a href="/docs/latest/configuration/#request-logging">Request logging configuration</a> for properties to set for each type of request logger.
Specify these properties in the <code>common.runtime.properties</code> file.
You must restart Druid for the changes to take effect.</p><p>Druid stores the results in the Broker logs, unless the request logging type is <code>emitter</code>.
If you use emitter request logging, you must also configure metrics emission.</p><h2 class="anchor anchorWithStickyNavbar_LWe7" id="configure-metrics-emission">Configure metrics emission<a href="#configure-metrics-emission" class="hash-link" aria-label="Direct link to Configure metrics emission" title="Direct link to Configure metrics emission">​</a></h2><p>Druid includes various emitters to send metrics and alerts.
To emit query metrics, set <code>druid.request.logging.feed=emitter</code>, and define the emitter type in the <code>druid.emitter</code> property.</p><p>You can use any of the following emitters in Druid:</p><ul><li><code>noop</code>: Disables metric emission, the default behavior.</li><li><a href="/docs/latest/configuration/#logging-emitter-module"><code>logging</code></a>: Emits metrics to Log4j 2. See <a href="/docs/latest/configuration/logging">Logging</a> to configure Log4j 2 for use with Druid.</li><li><a href="/docs/latest/configuration/#http-emitter-module"><code>http</code></a>: Sends HTTP <code>POST</code> requests containing the metrics in JSON format to a user-defined endpoint.</li><li><a href="/docs/latest/configuration/#parametrized-http-emitter-module"><code>parametrized</code></a>: Operates like the <code>http</code> emitter but fine-tunes the recipient URL based on the event feed.</li><li><a href="/docs/latest/configuration/#composing-emitter-module"><code>composing</code></a>: Emits metrics to multiple emitter types.</li><li><a href="/docs/latest/configuration/#graphite-emitter"><code>graphite</code></a>: Emits metrics to a <a href="https://graphiteapp.org/" target="_blank" rel="noopener noreferrer">Graphite</a> Carbon service.</li></ul><p>Specify these properties in the <code>common.runtime.properties</code> file.
See the <a href="/docs/latest/configuration/#metrics-emitters">Metrics emitters configuration</a> for properties to set for each type of metrics emitter.
You must restart Druid for the changes to take effect.</p><h2 class="anchor anchorWithStickyNavbar_LWe7" id="example">Example<a href="#example" class="hash-link" aria-label="Direct link to Example" title="Direct link to Example">​</a></h2><p>The following configuration shows how to enable request logging and post query metrics to the endpoint <code>http://example.com:8080/path</code>.</p><div class="codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#bfc7d5;--prism-background-color:#292d3e"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-text codeBlock_bY9V thin-scrollbar"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#bfc7d5"><span class="token plain"># Enable request logging and configure the emitter request logger</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">druid.request.logging.type=emitter</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">druid.request.logging.feed=myRequestLogFeed</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain" style="display:inline-block"></span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"># Enable metrics emission and tell Druid where to emit messages</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">druid.emitter=http</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">druid.emitter.http.recipientBaseUrl=http://example.com:8080/path</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain" style="display:inline-block"></span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"># Authenticate to the base URL, if needed</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">druid.emitter.http.basicAuthentication=username:password</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div><p>The following shows an example log emitter output:</p><div class="codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#bfc7d5;--prism-background-color:#292d3e"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-text codeBlock_bY9V thin-scrollbar"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#bfc7d5"><span class="token plain">[</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;feed&quot;: &quot;metrics&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;timestamp&quot;: &quot;2022-01-06T20:32:06.628Z&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;service&quot;: &quot;druid/broker&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;host&quot;: &quot;localhost:8082&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;version&quot;: &quot;2022.01.0-iap-SNAPSHOT&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;metric&quot;: &quot;sqlQuery/bytes&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;value&quot;: 9351,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;dataSource&quot;: &quot;[wikipedia]&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;id&quot;: &quot;56e8317b-31cc-443d-b109-47f51b21d4c3&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;nativeQueryIds&quot;: &quot;[2b9cbced-11fc-4d78-a58c-c42863dff3c8]&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;remoteAddress&quot;: &quot;127.0.0.1&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;success&quot;: &quot;true&quot;</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> },</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;feed&quot;: &quot;myRequestLogFeed&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;timestamp&quot;: &quot;2022-01-06T20:32:06.585Z&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;remoteAddr&quot;: &quot;127.0.0.1&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;service&quot;: &quot;druid/broker&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;sqlQueryContext&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;useApproximateCountDistinct&quot;: false,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;sqlQueryId&quot;: &quot;56e8317b-31cc-443d-b109-47f51b21d4c3&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;useApproximateTopN&quot;: false,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;useCache&quot;: false,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;sqlOuterLimit&quot;: 101,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;populateCache&quot;: false,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;nativeQueryIds&quot;: &quot;[2b9cbced-11fc-4d78-a58c-c42863dff3c8]&quot;</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> },</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;queryStats&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;sqlQuery/time&quot;: 43,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;sqlQuery/planningTimeMs&quot;: 5,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;sqlQuery/bytes&quot;: 9351,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;success&quot;: true,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;context&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;useApproximateCountDistinct&quot;: false,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;sqlQueryId&quot;: &quot;56e8317b-31cc-443d-b109-47f51b21d4c3&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;useApproximateTopN&quot;: false,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;useCache&quot;: false,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;sqlOuterLimit&quot;: 101,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;populateCache&quot;: false,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;nativeQueryIds&quot;: &quot;[2b9cbced-11fc-4d78-a58c-c42863dff3c8]&quot;</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> },</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;identity&quot;: &quot;allowAll&quot;</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> },</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;query&quot;: null,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;host&quot;: &quot;localhost:8082&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;sql&quot;: &quot;SELECT * FROM wikipedia WHERE cityName = &#x27;Buenos Aires&#x27;&quot;</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> },</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;feed&quot;: &quot;myRequestLogFeed&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;timestamp&quot;: &quot;2022-01-06T20:32:07.652Z&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;remoteAddr&quot;: &quot;&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;service&quot;: &quot;druid/broker&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;sqlQueryContext&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {},</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;queryStats&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;query/time&quot;: 16,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;query/bytes&quot;: -1,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;success&quot;: true,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;identity&quot;: &quot;allowAll&quot;</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> },</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;query&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;queryType&quot;: &quot;scan&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;dataSource&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;type&quot;: &quot;table&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;name&quot;: &quot;wikipedia&quot;</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> },</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;intervals&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;type&quot;: &quot;intervals&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;intervals&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> [</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;-146136543-09-08T08:23:32.096Z/146140482-04-24T15:36:27.903Z&quot;</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> ]</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> },</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;virtualColumns&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> [</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;type&quot;: &quot;expression&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;name&quot;: &quot;v0&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;expression&quot;: &quot;&#x27;Buenos Aires&#x27;&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;outputType&quot;: &quot;STRING&quot;</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> }</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> ],</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;resultFormat&quot;: &quot;compactedList&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;batchSize&quot;: 20480,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;limit&quot;: 101,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;filter&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;type&quot;: &quot;selector&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;dimension&quot;: &quot;cityName&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;value&quot;: &quot;Buenos Aires&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;extractionFn&quot;: null</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> },</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;columns&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> [</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;__time&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;added&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;channel&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;comment&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;commentLength&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;countryIsoCode&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;countryName&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;deleted&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;delta&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;deltaBucket&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;diffUrl&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;flags&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;isAnonymous&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;isMinor&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;isNew&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;isRobot&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;isUnpatrolled&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;metroCode&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;namespace&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;page&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;regionIsoCode&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;regionName&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;user&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;v0&quot;</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> ],</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;legacy&quot;: false,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;context&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;populateCache&quot;: false,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;queryId&quot;: &quot;62e3d373-6e50-41b4-873b-1e56347c2950&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;sqlOuterLimit&quot;: 101,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;sqlQueryId&quot;: &quot;cbb3d519-aee9-4566-8920-dbbeab6269f5&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;useApproximateCountDistinct&quot;: false,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;useApproximateTopN&quot;: false,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;useCache&quot;: false</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> },</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;descending&quot;: false,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;granularity&quot;:</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> {</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;type&quot;: &quot;all&quot;</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> }</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> },</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;host&quot;: &quot;localhost:8082&quot;,</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> &quot;sql&quot;: null</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> },</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain"> ...</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">]</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div><h2 class="anchor anchorWithStickyNavbar_LWe7" id="learn-more">Learn more<a href="#learn-more" class="hash-link" aria-label="Direct link to Learn more" title="Direct link to Learn more">​</a></h2><p>See the following topics for more information.</p><ul><li><a href="/docs/latest/operations/metrics#query-metrics">Query metrics</a></li><li><a href="/docs/latest/configuration/#request-logging">Request logging configuration</a></li><li><a href="/docs/latest/configuration/#metrics-emitters">Metrics emitters configuration</a></li></ul></div></article><nav class="pagination-nav docusaurus-mt-lg" aria-label="Docs pages"><a class="pagination-nav__link pagination-nav__link--prev" href="/docs/latest/operations/clean-metadata-store"><div class="pagination-nav__sublabel">Previous</div><div class="pagination-nav__label">Automated metadata cleanup</div></a><a class="pagination-nav__link pagination-nav__link--next" href="/docs/latest/operations/metrics"><div class="pagination-nav__sublabel">Next</div><div class="pagination-nav__label">Metrics</div></a></nav></div></div><div class="col col--3"><div class="tableOfContents_bqdL thin-scrollbar theme-doc-toc-desktop"><ul class="table-of-contents table-of-contents__left-border"><li><a href="#configure-request-logging" class="table-of-contents__link toc-highlight">Configure request logging</a></li><li><a href="#configure-metrics-emission" class="table-of-contents__link toc-highlight">Configure metrics emission</a></li><li><a href="#example" class="table-of-contents__link toc-highlight">Example</a></li><li><a href="#learn-more" class="table-of-contents__link toc-highlight">Learn more</a></li></ul></div></div></div></div></main></div></div><footer class="footer"><div class="container container-fluid"><div class="footer__bottom text--center"><div class="margin-bottom--sm"><img src="/img/favicon.png" class="themedImage_ToTc themedImage--light_HNdA footer__logo"><img src="/img/favicon.png" class="themedImage_ToTc themedImage--dark_i4oU footer__logo"></div><div class="footer__copyright">Copyright © 2023 Apache Software Foundation. Except where otherwise noted, licensed under CC BY-SA 4.0. Apache Druid, Druid, and the Druid logo are either registered trademarks or trademarks of The Apache Software Foundation in the United States and other countries.</div></div></div></footer></div>
<script src="/assets/js/runtime~main.dc5f839a.js"></script>
<script src="/assets/js/main.a03dfc13.js"></script>
</body>
</html>