On Sun, Feb 17, 2019 at 11:29:56AM -0500, Jeff Janes wrote: > What would I find very useful is [...] an rusage report rather than just > wall-clock duration.
Most of that's available; [pryzbyj@database ~]$ psql postgres -xtc "SET client_min_messages=log; SET log_statement_stats=on" -c 'SELECT max(i) FROM generate_series(1,999999)i' SET LOG: statement: SELECT max(i) FROM generate_series(1,999999)i LOG: QUERY STATISTICS DETAIL: ! system usage stats: ! 0.186643 s user, 0.033622 s system, 0.220780 s elapsed ! [0.187823 s user, 0.037162 s system total] ! 61580 kB max resident size ! 0/0 [0/0] filesystem blocks in/out ! 0/7918 [0/9042] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent ! 0/3 [2/3] voluntary/involuntary context switches max | 999999 See also https://commitfest.postgresql.org/20/1691/ => 88bdbd3f746049834ae3cc972e6e650586ec3c9d https://www.postgresql.org/message-id/flat/7ffb9dbe-c76f-8ca3-12ee-7914ede872e6%40stormcloud9.net https://www.postgresql.org/docs/current/runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-MONITOR max RSS added in commit c039ba0716383ccaf88c9be1a7f0803a77823de1 Justin
