[GENERAL] Generalized pg_stat_statements? - Mailing list pgsql-general

From Jacob Scott
Subject [GENERAL] Generalized pg_stat_statements?
Date
Msg-id CA+yM-qa7QXh3vpFqSV8n4DMjmg-EVBAjyZY1=ywRThkxroGtcw@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Generalized pg_stat_statements?  (James Sewell <james.sewell@jirotech.com>)
List pgsql-general
When reviewing execution statistics, I am frequently interested in the behavior of "classes" of queries, rather than individual queries, for example queries which
  • Contain a join
  • Touch a specific column
  • Use POSIX regular expressions
AFAIK this sort of summary/rollup information can't be computed reliably from pg_stat_statements because of rows being discarded in the face of a large number of (post normalization/jumble) distinct statements.

Is there a way to retrieve these kinds of statistics in Postgres today?

Thanks,

Jacob

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [GENERAL] [PERFORM] Questionaire: Common WAL write rates on busy servers.
Next
From: Andres Freund
Date:
Subject: Re: [GENERAL] [PERFORM] Questionaire: Common WAL write rates on busy servers.