Re: Question on pg_stat* views

2024-10-07 Thread Greg Sabino Mullane
Adrian and Veem were saying: > > so does it mean that we should increase the pg_stat_statement.max to > further higher value? > Yes, you should raise this setting if you find your queries are getting pushed out. Moving to version 17 will also help, as myself and others have been working on norma

Re: Question on pg_stat* views

2024-10-06 Thread Adrian Klaver
On 10/6/24 12:11, veem v wrote: Hi, As per my understanding , the pg_stat_statements stores the aggregated statistics of the query execution history(with almost near real time executions) and the max number of statements or queries it can store depends on the pg_stat_statement.max value(which

Question on pg_stat* views

2024-10-06 Thread veem v
Hi, As per my understanding , the pg_stat_statements stores the aggregated statistics of the query execution history(with almost near real time executions) and the max number of statements or queries it can store depends on the pg_stat_statement.max value(which I am seeing as ~5000 in pg_settings).