Troubleshooting

Finding Long Running Queries

On the database server, you can see active queries by running:

echo "select now() as t, pid, usename, query from pg_stat_activity where state != 'idle'" | sudo -u postgres psql -t 

Run it several times to see if a query is running too long, or to simply figure out what is happening on the server.