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

Why is this Postgres query so slow?

Reading 11,378,536 rows isn't magically fast just because you do it with an index. And that is where the problem is, it has to read that number of rows. We don't know which parts of that complex ...
jjanes's user avatar
  • 40.1k
1 vote
Accepted

Where to get the error/info logs of what happens when committing several statements?

The strange statement you see was run from a trigger that implements foreign key constraints in PostgreSQL. There are two ways to get data about these statements: If you set shared_preload_libraries =...
Laurenz Albe's user avatar
1 vote

Where to get the error/info logs of what happens when committing several statements?

Can't comment on DBeaver. It's a generic client, not optimized for Postgres. I have seen occasional complaints about frictions here on dba.SE and SO. It's the responsibility of the client to show ...
Erwin Brandstetter's user avatar
1 vote
Accepted

Why is this Postgres query so slow?

Split up the query along the ugly OR. The resulting two queries are mutually exclusive, so combine them with UNION ALL: ( SELECT id, item_id, item_name, type, updated_time FROM changes WHERE ...
Erwin Brandstetter's user avatar
1 vote
Accepted

mysqldump select queries appearing in slow query log after upgrade

Posting the OP's solution (originally added as an edit to the question) on their behalf. After further investigation, it turns out we are piping mysqldump through gzip, to compress the resulting dump ...

Only top scored, non community-wiki answers of a minimum length are eligible