: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 { useMemo, useState } from 'react'
import { IconRefresh } from '@posthog/icons'
import { LemonButton, LemonCheckbox, LemonTable, LemonTableColumns } from '@posthog/lemon-ui'
import { LemonCollapse } from 'lib/lemon-ui/LemonCollapse'
import { systemStatusLogic } from 'scenes/instance/SystemStatus/systemStatusLogic'
import { QuerySummary } from '~/types'
export function InternalMetricsTab(): JSX.Element {
const { openSections, queries, queriesLoading } = useValues(systemStatusLogic)
const { setOpenSections, loadQueries } = useActions(systemStatusLogic)
const [showIdle, setShowIdle] = useState(false)
const postgresQueries = useMemo(
() => queries?.postgres_running?.filter(({ state }) => showIdle || state !== 'idle'),
[showIdle, queries]
)
const reloadQueries = (e: React.MouseEvent): void => {
e.stopPropagation()
loadQueries()
}
return (
<>
<LemonCollapse
activeKeys={openSections}
className="bg-surface-primary"
onChange={(keys) => setOpenSections(keys)}
multiple
panels={[
{
key: '1',
header: 'PostgreSQL - currently running queries',
content: (
<>
<div className="flex mb-4 float-right deprecated-space-x-2">
<LemonCheckbox
checked={showIdle}
onChange={setShowIdle}
label="Show idle queries"
/>
<LemonButton
type="secondary"
size="small"
icon={<IconRefresh />}
onClick={reloadQueries}
>
Reload Queries
</LemonButton>
</div>
<QueryTable queries={postgresQueries} loading={queriesLoading} />
</>
),
},
queries?.clickhouse_running != undefined && {
key: '2',
header: 'Clickhouse - currently running queries',
content: (
<>
<div className="flex mb-4 float-right">
<LemonButton
type="secondary"
size="small"
icon={<IconRefresh />}
onClick={reloadQueries}
>
Reload Queries
</LemonButton>
</div>
<QueryTable queries={queries?.clickhouse_running} loading={queriesLoading} />
</>
),
},
queries?.clickhouse_slow_log != undefined && {
key: '3',
header: 'Clickhouse - slow query log (past 6 hours)',
content: (
<>
<div className="flex mb-4 float-right">
<LemonButton
type="secondary"
size="small"
icon={<IconRefresh />}
onClick={reloadQueries}
>
Reload Queries
</LemonButton>
</div>
<QueryTable queries={queries?.clickhouse_slow_log} loading={queriesLoading} />
</>
),
},
]}
/>
</>
)
}
function QueryTable(props: {
queries?: QuerySummary[]
loading: boolean
columnExtra?: Record<string, any>
}): JSX.Element {
const columns: LemonTableColumns<QuerySummary> = [
{
title: 'duration',
dataIndex: 'duration',
key: 'duration',
sorter: (a, b) => +a.duration - +b.duration,
},
{
title: 'query',
dataIndex: 'query',
render: function RenderAnalyze(_, item: QuerySummary) {
return item.query
},
key: 'query',
},
]
if (props.queries && props.queries.length > 0) {
Object.keys(props.queries[0]).forEach((column) => {
if (column !== 'duration' && column !== 'query') {
columns.push({ title: column, dataIndex: column, key: column })
}
})
}
return (
<LemonTable
dataSource={props.queries || []}
columns={columns}
loading={props.loading}
pagination={{ pageSize: 30, hideOnSinglePage: true }}
size="small"
nouns={['query', 'queries']}
/>
)
}