2018-03-19 18:09 GMT+01:00 Adrian Klaver <adrian.kla...@aklaver.com>:
> On 03/19/2018 10:04 AM, Jimmy Augustine wrote: > >> >> >> 2018-03-19 17:45 GMT+01:00 Adrian Klaver <adrian.kla...@aklaver.com >> <mailto:adrian.kla...@aklaver.com>>: >> >> On 03/19/2018 09:31 AM, Jimmy Augustine wrote: >> >> Dear Friends, >> >> I am newbie to postgresql. >> I have 162 GB on my database but when I check size of all >> tables, I approximately obtain 80 GB. >> I also see that I have 68GB of temporary files however I only >> found 2.4MB at postgres/data/base/pgsql_tmp. >> >> >> Exactly how did you determine this? >> >> I used this command and sum result for all database : >> SELECT pg_size_pretty(pg_total_relation_size('table_name')); >> >> And this for complete database : >> SELECT pg_size_pretty(pg_database_size('Database Name')); >> >> > So where did the 68GB number for temporary files come from? > > I don't measure this value by my own. I was disappointed by the gap between the two queries, so I checked pgAdmin 4 and I saw this value. > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
