Finding the size of your biggest relations

From: Artem Tomyuk <admin(at)leboutique(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Finding the size of your biggest relations
Date: 2016-09-23 12:57:52
Message-ID: CANYYVqJrOSYCaryawYt95f-hQR6FHjMAk7CZ6eycb5i=GSu-Zg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all.

i am running this query to get to 20 biggest tables but getting only
pg_temp** records like this without size:

"pg_toast_temp_39.pg_toast_1384618609";""
"pg_toast_temp_146.pg_toast_1384509547_index";""
"pg_temp_5.tt_photo";""
"pg_toast_temp_146.pg_toast_1384494807";""
"pg_temp_58.tt_category_action_brands_АкцияГУИД_idx";""
"pg_toast_temp_56.pg_toast_1384618787_index";""
"pg_toast_temp_47.pg_toast_1384618711";""
"pg_toast_temp_58.pg_toast_1384618621_index";""
"pg_toast_temp_5.pg_toast_1384618426_index";""
"pg_temp_32.tt1";""
"pg_temp_5.tt_accessory_kit_composition_НоменклатураГУИД_idx";""
"pg_toast_temp_112.pg_toast_1384472524";""
"pg_toast_temp_27.pg_toast_1384618423_index";""

How can i fix it? As i understand this is temp tables that was created
during run of some heavy queries that didn't fit in to work_mem and was
dumped on disk.
How i can remove it from stats, just restart postgre will help?
pgsql_tmp dir doesn't contain those files, so i can assume that they
already deleted from disk?

Thanks!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message hubert depesz lubaczewski 2016-09-23 13:21:23 Re: Finding the size of your biggest relations
Previous Message Κοκμάδης Δημήτριος 2016-09-23 09:14:35 Streaming Replication Error