Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [pg-stat-statements]

Any questions particularly about the PostgreSQL pg_stat_statements extension. It is part of the contrib "Additional Supplied Modules" and is highly recommended for server environments.

Filter by
Sorted by
Tagged with
0 votes
1 answer
28 views

PostgreSQL: What are different operations make the use of Temp files?

We have time series monitoring on both pg_stat_database as well as pg_stat_statements. Recently We have been observing temp file usage in our DB during certain period. But for the same period we are ...
mediocre's user avatar
  • 107
2 votes
1 answer
107 views

Use case of ALTER EXTENSION ADD/DROP in upgrade script of extensions

I am recently looking at the pg_stat_statements upgrade script and found out these set of commands here /* First we have to remove them from the extension */ ALTER EXTENSION pg_stat_statements DROP ...
Ayush Vatsa's user avatar
0 votes
1 answer
2k views

pg_stat_statements slows down the database

I have an aws aurora postgresql cluster running posgresql 13.7 engine. The cluster is using the default parameter group. These are the default settings used for pg_stat_statements in the parameter ...
mario's user avatar
  • 3
1 vote
1 answer
987 views

Why does pg_stat_statement need to be included in shared_preload_libraries?

I am working on AWS RDS Postgres v9.6, and also v14. I noticed that in our shared_preload_libraries parameter, we have pg_stat_statement included. I don't understand why that needs to be there. In the ...
Mark Grobaker's user avatar
0 votes
0 answers
47 views

Unable to use equal operator in where clause on `queryid` from `pg_stat_statements`

When analyzing an issue on a PostgreSQL 13 server we can successfully retrieve information querying from pg_stat_statements, but we are unable to retrieve a single record using a queryid = -1234567600 ...
Justin Zandbergen's user avatar
0 votes
1 answer
3k views

Analyzing queries with high disk IO

RDS Aurora PostgreSQL 10.14 instance db.r5.4xlarge. I'm trying to figure out some high RDS IO costs in my machine. I'm looking at the pg_stat_statements and asking whether the following query make ...
Cowabunga's user avatar
  • 135
3 votes
1 answer
2k views

ERROR: invalid byte sequence for encoding "UTF8": 0x00 in pg_stat_statements

I'm attempting to use pg_stat_statements to optimise my queries but ran into an unexpected roadblock. SELECT total_plan_time + total_exec_time as total_time, query FROM pg_stat_statements ORDER BY ...
shrumm's user avatar
  • 43
7 votes
1 answer
4k views

What is the performance impact of pg_stat_statements?

I am using pg_stat_statements to find the slow queries in my production PostgreSQL 13. Two things: I am unsure of the performance impact of this extension. Is there anything I can do to improve its ...
Dolphin's user avatar
  • 775