Skip to content

: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.

547 B
Raw Blame
-- Statement text per fingerprint, joined by pgapi from ts_query_durations. Created
-- here rather than on first data so the join works before the log collector has
-- seen a statement.

CREATE TABLE IF NOT EXISTS cur_query_texts (
    server_id   text NOT NULL,
    instance    text NOT NULL DEFAULT 'writer',
    datname     text NOT NULL DEFAULT '',
    first_seen  timestamptz NOT NULL,
    last_seen   timestamptz NOT NULL,
    fingerprint bigint NOT NULL,
    query       text,
    PRIMARY KEY (server_id, instance, datname, fingerprint)
);