Re: Getting pg_stat_database data takes significant time

ok my guess here was, since pg_class is updated every now and then with stats, it might require some lock while adding the data.

so if it were bloated, that would block the planner to get the estimates , and hence delay the query at whole.

but that was a wild guess.

--pg_class not locked

postgres@db:~$ time psql -c 'select * from pg_stat_database;' >/dev/null

real    0m0.016s

user    0m0.003s

sys     0m0.000s

-- pg_class locked and the query completed when tx it unlocks

postgres@db:~$ time psql -c 'select * from pg_stat_database;' >/dev/null

real    0m7.269s

user    0m0.003s

sys     0m0.000s