Skip to main content
edited title
Link
sudo
  • 1.1k
  • 1
  • 12
  • 18

Viewing disk usage of temporary buffers of running queries in Postgres

Source Link
sudo
  • 1.1k
  • 1
  • 12
  • 18

Viewing disk usage of running queries in Postgres

I know how to get the sizes of relations or total table disk usage per table in Postgres 9.5 (https://wiki.postgresql.org/wiki/Disk_Usage), but I have some queries running whose temporary disk buffers use significant amounts of space. How can I see how much each is using? My disk is slowly running out of space due to many long-running queries, and I need to kill one of them.