pg_stat_activity.query_id <-> pg_stat_statements.queryid

From: "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: pg_stat_activity.query_id <-> pg_stat_statements.queryid
Date: 2024-02-15 10:52:42
Message-ID: GV0P278MB04197CCE6876C100DEA76818D24D2@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

quick question: What would be the cases for a query_id in pg_stat_activity not showing up in pg_stat_statements.queryid assuming pg_stat_statements.max is not yet reached?

Regards
Daniel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julien Rouhaud 2024-02-15 15:04:02 Re: pg_stat_activity.query_id <-> pg_stat_statements.queryid
Previous Message Daniel Gustafsson 2024-02-15 08:31:32 Re: Query regarding function cleanup in extension upgrade path