: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 { MakeLogicType, actions, afterMount, connect, kea, path, reducers, selectors } from 'kea'
import { loaders } from 'kea-loaders'
import api from 'lib/api'
import { userLogic } from 'scenes/userLogic'
import { HogQLQueryResponse } from '~/queries/schema/schema-general'
import type { UserType } from '../../types'
export interface QueryLogEntry {
query_id: string
query: string
query_start_time: string
query_duration_ms: number
name: string
status: string
exception_code: number
read_rows: number
read_bytes: number
result_rows: number
}
export interface QueryLogTableLogicProps {
key: string
}
// Generated by kea-typegen. Update if you're an agent, ignore if you're human.
export interface queryLogTableLogicValues {
user: UserType | null // userLogic
hasMore: boolean
limit: number
moreQueryLogs: QueryLogEntry[]
moreQueryLogsLoading: boolean
queryLogs: QueryLogEntry[]
queryLogsLoading: boolean
queryLogsWithIndex: (QueryLogEntry & {
index: number
})[]
}
// Generated by kea-typegen. Update if you're an agent, ignore if you're human.
export interface queryLogTableLogicActions {
loadMoreQueryLogs: () => {
value: true
}
loadMoreQueryLogsFailure: (
error: string,
errorObject?: any
) => {
error: string
errorObject?: any
}
loadMoreQueryLogsSuccess: (
moreQueryLogs: QueryLogEntry[],
payload?: {
value: true
}
) => {
moreQueryLogs: QueryLogEntry[]
payload?: {
value: true
}
}
loadQueryLogs: () => {
value: true
}
loadQueryLogsFailure: (
error: string,
errorObject?: any
) => {
error: string
errorObject?: any
}
loadQueryLogsSuccess: (
queryLogs: QueryLogEntry[],
payload?: {
value: true
}
) => {
queryLogs: QueryLogEntry[]
payload?: {
value: true
}
}
}
// Generated by kea-typegen. Update if you're an agent, ignore if you're human.
export interface queryLogTableLogicMeta {
__keaTypeGenInternalSelectorTypes: {
queryLogsWithIndex: (queryLogs: QueryLogEntry[]) => (QueryLogEntry & {
index: number
})[]
hasMore: (moreQueryLogs: QueryLogEntry[], limit: number) => boolean
}
}
export type queryLogTableLogicType = MakeLogicType<
queryLogTableLogicValues,
queryLogTableLogicActions,
Record<string, any>,
queryLogTableLogicMeta
>
export const queryLogTableLogic = kea<queryLogTableLogicType>([
path(['scenes', 'debug', 'queryLogTableLogic']),
connect(() => ({
values: [userLogic, ['user']],
})),
actions({
loadQueryLogs: true,
loadMoreQueryLogs: true,
}),
loaders(({ values }) => ({
queryLogs: [
[] as QueryLogEntry[],
{
loadQueryLogs: async () => {
try {
if (!values.user?.id) {
return []
}
// Query the query_log_archive for the current user's queries
const response = (await api.query({
kind: 'HogQLQuery',
query: `
SELECT
query_id,
query,
query_start_time,
query_duration_ms,
name,
status,
exception_code,
read_rows,
read_bytes,
result_rows
FROM query_log
WHERE created_by = {user_id}
AND event_date >= today() - INTERVAL 7 DAY
AND query != ''
ORDER BY query_start_time DESC
LIMIT {limit}
`,
values: {
user_id: values.user.id,
limit: values.limit,
},
})) as HogQLQueryResponse
// Convert array of arrays to array of objects
if (!response.results || !response.columns) {
return []
}
return response.results.map((row: any[]) => {
const obj: any = {}
response.columns!.forEach((col: string, idx: number) => {
obj[col] = row[idx]
})
return obj as QueryLogEntry
})
} catch (error) {
console.error('Error loading query logs:', error)
return []
}
},
},
],
moreQueryLogs: [
[] as QueryLogEntry[],
{
loadMoreQueryLogs: async () => {
try {
if (!values.user?.id) {
return []
}
// Load more query logs with offset
const response = (await api.query({
kind: 'HogQLQuery',
query: `
SELECT
query_id,
query,
query_start_time,
query_duration_ms,
name,
status,
exception_code,
read_rows,
read_bytes,
result_rows
FROM query_log
WHERE created_by = {user_id}
AND event_date >= today() - INTERVAL 7 DAY
AND query != ''
ORDER BY query_start_time DESC
LIMIT {limit} OFFSET {offset}
`,
values: {
user_id: values.user.id,
limit: values.limit,
offset: values.queryLogs.length,
},
})) as HogQLQueryResponse
// Convert array of arrays to array of objects
if (!response.results || !response.columns) {
return []
}
return response.results.map((row: any[]) => {
const obj: any = {}
response.columns!.forEach((col: string, idx: number) => {
obj[col] = row[idx]
})
return obj as QueryLogEntry
})
} catch (error) {
console.error('Error loading more query logs:', error)
return []
}
},
},
],
})),
reducers({
limit: [100, {}],
queryLogs: {
loadQueryLogsSuccess: (_, { queryLogs }) => queryLogs,
loadMoreQueryLogsSuccess: (state, { moreQueryLogs }) => [...state, ...moreQueryLogs],
},
}),
selectors({
queryLogsWithIndex: [
(s) => [s.queryLogs],
(queryLogs: QueryLogEntry[]): (QueryLogEntry & { index: number })[] =>
queryLogs.map((log, index) => ({ ...log, index })),
],
hasMore: [
(s) => [s.moreQueryLogs, s.limit],
(moreQueryLogs: QueryLogEntry[], limit: number): boolean => moreQueryLogs.length === limit,
],
}),
afterMount(({ actions }) => {
actions.loadQueryLogs()
}),
])