Question

Will the pg_stat_statements view show old data if there is no transaction going on in the database?

score 67 · Answer 1 · 2024-01-29T12:30:34.403000

67

Views

Will the pg_stat_statements view show old data if there is no transaction going on in the database?

Published on 29 January 2024 at 12:30

score 64 · Answer 2 · 2023-10-07T12:28:47.910000

64

Views

differentiate pg_stat_statements metrics for a particualr schema

Published on 07 October 2023 at 12:28

score 205 · Answer 3 · 2023-02-22T09:56:46.330000

205

Views

pg_stat_statements same query different queryid

Published on 22 February 2023 at 09:56

score 284 · Answer 4 · 2022-10-27T10:45:43.520000

284

Views

How to make pg_stat_statement merge queries with variable number of parameters in a IN close?

Published on 27 October 2022 at 10:45

score 1.3k · Answer 5 · 2022-10-11T07:34:09.197000

1.3k

Views

How to add extension pg_stat extension to postgres bitnami helm chart?

Published on 11 October 2022 at 07:34

score 471 · Answer 6 · 2022-10-07T10:25:45.207000

471

Views

Which are the reasons why pg_stats_all_table values might reset on a database?

Published on 07 October 2022 at 10:25

score 111 · Answer 7 · 2022-09-01T13:32:08.510000

111

Views

Can pg_stat_statements.max increase cause problems?

Published on 01 September 2022 at 13:32

score 352 · Answer 8 · 2022-08-08T09:58:39.583000

352

Views

How long does pg_statio_all_tables data live for?

Published on 08 August 2022 at 09:58

score 924 · Answer 9 · 2022-03-09T13:46:11.727000

924

Views

How to get pg_stat_user_tables n_tup_ins for timescale's compressed table?

Published on 09 March 2022 at 13:46

score 576 · Answer 10 · 2022-02-16T04:45:48.660000

576

Views

In Postgres pg_stat_statements huge difference between max and mean time

Published on 16 February 2022 at 04:45

score 424 · Answer 11 · 2022-01-15T02:37:03.743000

424

Views

Details Query in pg_stat_statements

Published on 15 January 2022 at 02:37

score 679 · Answer 12 · 2021-09-07T10:51:32.333000

679

Views

How can I use pg_proctab extension in AWS Aurora for Monitoring purpose?

Published on 07 September 2021 at 10:51

score 1.6k · Answer 13 · 2021-07-21T22:34:57.823000

1.6k

Views

Join pg_stat_activity with pg_stat_statements?

Published on 21 July 2021 at 22:34

score 1.8k · Answer 14 · 2021-06-30T10:34:03.557000

1.8k

Views

pg_stat_activity keeps showing the query which has timeout due to statement_timeout

Published on 30 June 2021 at 10:34

score 1.9k · Answer 15 · 2021-03-12T23:04:43.030000

1.9k

Views

Getting error "could not access file "pg_stat_statements": No such file or directory"

Published on 12 March 2021 at 23:04

score 2k · Answer 16 · 2021-03-05T19:01:12.890000

2k

Views

GCP pg_stat_statements insufficient privileges and read replicas

Published on 05 March 2021 at 19:01

score 21.3k · Answer 17 · 2021-02-22T23:59:04.610000

21.3k

Views

DOCKER container with postgres, WARNING: could not open statistics file "pg_stat_tmp/global.stat": Operation not permitted

Published on 22 February 2021 at 23:59

score 4.9k · Answer 18 · 2020-11-30T05:19:26.103000

4.9k

Views

pg_stat_statements_reset() schedule

Published on 30 November 2020 at 05:19

score 278 · Answer 19 · 2020-11-18T05:19:55.020000

278

Views

Hourly Segregate pg_stat_statements On Reader Instance

Published on 18 November 2020 at 05:19

score 339 · Answer 20 · 2020-10-26T15:47:48.233000

339

Views

error trying to create extension: pg_stat_statement

Published on 26 October 2020 at 15:47

List Question

Will the pg_stat_statements view show old data if there is no transaction going on in the database?

differentiate pg_stat_statements metrics for a particualr schema

pg_stat_statements same query different queryid

How to make pg_stat_statement merge queries with variable number of parameters in a IN close?

How to add extension pg_stat extension to postgres bitnami helm chart?

Which are the reasons why pg_stats_all_table values might reset on a database?

Can pg_stat_statements.max increase cause problems?

How long does pg_statio_all_tables data live for?

How to get pg_stat_user_tables n_tup_ins for timescale's compressed table?

In Postgres pg_stat_statements huge difference between max and mean time

Details Query in pg_stat_statements

How can I use pg_proctab extension in AWS Aurora for Monitoring purpose?

Join pg_stat_activity with pg_stat_statements?

pg_stat_activity keeps showing the query which has timeout due to statement_timeout

Getting error "could not access file "pg_stat_statements": No such file or directory"

GCP pg_stat_statements insufficient privileges and read replicas

DOCKER container with postgres, WARNING: could not open statistics file "pg_stat_tmp/global.stat": Operation not permitted

pg_stat_statements_reset() schedule

Hourly Segregate pg_stat_statements On Reader Instance

error trying to create extension: pg_stat_statement

Trending Questions

Popular # Hahtags

Popular Questions