Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting pg_stat_database data takes significant time - Mailing list pgsql-general

From Vijaykumar Jain
Subject Re: Getting pg_stat_database data takes significant time
Date
Msg-id CAM+6J94A7cHjGrD4bVUZz5WYKOdpZJpR_9BdfFeVso1SpMRy+g@mail.gmail.com
Whole thread Raw
In response to Getting pg_stat_database data takes significant time  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Getting pg_stat_database data takes significant time  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
Tree view
 Just taking a shot, as I have seen in some previous issues? Ignore is not relevant.

Can you run vacuum on pg_class and  check the query again , or do you see pg_class bloated ?

The other option would be gdb backtrace I think that would help.

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Getting pg_stat_database data takes significant time
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Getting pg_stat_database data takes significant time