:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
import { useActions, useValues } from 'kea'
import posthog from 'posthog-js'
import { useState } from 'react'
import { IconChip } from '@posthog/icons'
import { Popover } from 'lib/lemon-ui/Popover'
import { Tooltip } from 'lib/lemon-ui/Tooltip'
import { humanFriendlyMilliseconds } from 'lib/utils/durations'
import { humanizeBytes } from 'lib/utils/numbers'
import { dataNodeLogic } from './dataNodeLogic'
export function QueryExecutionDetails(): JSX.Element | null {
const { queryLog, queryId, queryLogLoading, queryLogQueryId, elapsedTime, isShowingCachedResults } =
useValues(dataNodeLogic)
const { loadQueryLog } = useActions(dataNodeLogic)
const [popoverVisible, setPopoverVisible] = useState(false)
if (!queryId) {
return null
}
const executionDetails = queryLog?.results?.[0]
const columns = queryLog?.columns || []
let memoryUsage = null
let cpuMicroseconds = null
let readBytes = null
let queryDurationMs = null
if (executionDetails && columns.length > 0) {
const memoryUsageIndex = columns.indexOf('memory_usage')
const cpuMicrosecondsIndex = columns.indexOf('cpu_microseconds')
const readBytesIndex = columns.indexOf('read_bytes')
const queryDurationMsIndex = columns.indexOf('query_duration_ms')
memoryUsage = memoryUsageIndex >= 0 ? executionDetails[memoryUsageIndex] : null
cpuMicroseconds = cpuMicrosecondsIndex >= 0 ? executionDetails[cpuMicrosecondsIndex] : null
readBytes = readBytesIndex >= 0 ? executionDetails[readBytesIndex] : null
queryDurationMs = queryDurationMsIndex >= 0 ? executionDetails[queryDurationMsIndex] : null
}
const formatCpuTime = (microseconds: number): string => {
if (microseconds < 1000) {
return `${microseconds}μs`
} else if (microseconds < 1000000) {
return `${(microseconds / 1000).toFixed(2)}ms`
}
return `${(microseconds / 1000000).toFixed(2)}s`
}
const hasData = memoryUsage !== null || cpuMicroseconds !== null || readBytes !== null || queryDurationMs !== null
return (
<Popover
onClickOutside={() => setPopoverVisible(false)}
onMouseEnterInside={() => setPopoverVisible(true)}
onMouseLeaveInside={() => setPopoverVisible(false)}
visible={popoverVisible}
placement="bottom"
showArrow={true}
overlay={
<div className="deprecated-space-y-1 p-2">
{queryLogLoading ? (
<div className="py-1">Loading execution details...</div>
) : hasData ? (
<>
{memoryUsage !== null && (
<div className="flex justify-between items-start deprecated-space-x-2 py-1">
<span>Memory usage:</span>
<Tooltip title={`${memoryUsage} bytes`}>
<span className="font-mono">{humanizeBytes(memoryUsage)}</span>
</Tooltip>
</div>
)}
{readBytes !== null && (
<div className="flex justify-between items-start deprecated-space-x-2 py-1">
<span>Data read:</span>
<Tooltip title={`${readBytes} bytes`}>
<span className="font-mono">{humanizeBytes(readBytes)}</span>
</Tooltip>
</div>
)}
{cpuMicroseconds !== null && (
<div className="flex justify-between items-start deprecated-space-x-2 py-1">
<span>CPU time:</span>
<Tooltip title={`${cpuMicroseconds} microseconds`}>
<span className="font-mono">{formatCpuTime(cpuMicroseconds)}</span>
</Tooltip>
</div>
)}
{queryDurationMs !== null && (
<div className="flex justify-between items-start deprecated-space-x-2 py-1">
<span>Database time:</span>
{queryDurationMs > 999 ? (
<Tooltip title={`${queryDurationMs}ms`}>
<span className="font-mono">
{humanFriendlyMilliseconds(queryDurationMs)}
</span>
</Tooltip>
) : (
<span className="font-mono">{humanFriendlyMilliseconds(queryDurationMs)}</span>
)}
</div>
)}
{elapsedTime && !isShowingCachedResults ? (
<div className="flex justify-between items-start deprecated-space-x-2 py-1">
<Tooltip title="Time until results showed in your browser, including the transfer over your network">
<span>Total time:</span>
</Tooltip>
<span className="font-mono">{humanFriendlyMilliseconds(elapsedTime)}</span>
</div>
) : null}
</>
) : (
<div className="py-1">No execution details available.</div>
)}
</div>
}
>
<div
onClick={() => {
const newVisible = !popoverVisible
setPopoverVisible(newVisible)
if (newVisible) {
posthog.capture('query execution details viewed')
}
}}
onMouseEnter={() => {
if (!queryLogLoading && queryId && queryId !== queryLogQueryId) {
loadQueryLog(queryId)
}
if (!popoverVisible) {
setPopoverVisible(true)
posthog.capture('query execution details viewed')
}
}}
onMouseLeave={() => setPopoverVisible(false)}
className="cursor-help text-xs flex items-center gap-1"
>
<IconChip />
Execution details
</div>
</Popover>
)
}