explain analyze doesn't reveal much:
explain analyze SELECT * FROM pg_stat_database WHERE
datname='prime_production';
QUERY
PLAN
----------------------------------------------------------------------------------------------------------
Seq Scan on pg_database d (cost=0.00..1.11 rows=1
width=68) (actual time=11.201..11.203 rows=1 loops=1)
Filter: (datname = 'prime_production'::name)
Rows Removed by Filter: 4
Total runtime: 11.320 ms
(4 rows)
explain on another 'offending' query also isn't very helpful
explain analyze select * from pg_stat_bgwriter
;
QUERY
PLAN
--------------------------------------------------------------------------------------
Result (cost=0.00..0.04 rows=1 width=0) (actual
time=10.771..10.771 rows=1 loops=1)
Total runtime: 10.794 ms
I've performed a pg_stat_reset this morning. That hasn't
been done in awhile.
