Delete query from pg_stat_statements in postgresql

Question

I need to use pg_stat_statements, I have read about pg_stat_statements_reset() which can discards all statistics. But is there a function which can discards statisctic of one custom query? Can it be removed automatically?

Frank Heikens · Accepted Answer · 2022-06-06 08:47:21Z

6

Yes, that's possible, just reset the stats for this specific userid, database and query id:

SELECT pg_stat_statements_reset(userid Oid, dbid Oid, queryid bigint);

Check your stats for the right userid, dbid and queryid.

answered Jun 6, 2022 at 8:47

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

yuoggy Over a year ago

But thats is not in version 11?

Frank Heikens Over a year ago

@yuoggy: check the extension

jjnrmason Over a year ago

Thanks @FrankHeikens worked a charm 👌

yuoggy · Accepted Answer · 2022-06-06 07:05:03Z

-2

There are no options to delete statistics for a specific object.

answered Jun 6, 2022 at 7:05

yuoggy

1471 gold badge3 silver badges14 bronze badges

Collectives™ on Stack Overflow

Delete query from pg_stat_statements in postgresql

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related