Which of the following two is more accurate?
select numbackends from pg_stat_database;
select count(*) from pg_stat_activity;
Which of the following two is more accurate?
select numbackends from pg_stat_database;
select count(*) from pg_stat_activity;
The following query is very helpful
From looking at the source code, it seems like the pg_stat_database query gives you the number of connections to the current database for all users. On the other hand, the pg_stat_activity query gives the number of connections to the current database for the querying user only.
No of tcp connections will help you. Remember that it is not for a particular database
netstat -a -n | find /c "127.0.0.1:13306"
Those two requires aren't equivalent. The equivalent version of the first one would be:
In that case, I would expect that version to be slightly faster than the second one, simply because it has fewer rows to count. But you are not likely going to be able to measure a difference.
Both queries are based on exactly the same data, so they will be equally accurate.