May 2018
Intermediate to advanced
576 pages
30h 25m
English
As most queries on modern online transaction processing (OLTP) systems take only a few milliseconds to run, it is often hard to catch the active ones when simply probing the pg_stat_activity table.
Most likely, you will be able to see only the last executed query for those backends that have state different from active. In some cases, this can be enough.
In general, if you need to perform a deeper analysis, I strongly recommend installing and configuring the pg_stat_statements module, which is described in the Analyzing the real-time performance of your queries recipe in this chapter. Another option is to run a post analysis of log files using pgBadger. Depending on the workload of your ...