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)
FROMgenerate_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