I'm reviewing the output of log_statement_stats and would to like to understand the following questions.
[0.526408 user 0.112125 sys total] => The previous line already shows CPU seconds of user and system. What is the significance of this line?
Every other line as values in brackets. What is the significance of those values in enclosed in brackets?
2016-03-03 10:33:29.259 CET [56868] user@db STATEMENT: SELECT field1 AS a1, field2 AS a2, field3 AS a3, field4 AS a4, field5 AS a5, field6 AS a6, MSISDN AS a7, field8 AS a8, RETRY_COUNT AS a9 FROM table WHERE ((field3 <= $1) AND (field8 IS NULL)) ORDER BY field3 ASC LIMIT $2 OFFSET $3
2016-03-03 10:33:29.259 CET [56868] user@db LOG: EXECUTE MESSAGE STATISTICS
2016-03-03 10:33:29.259 CET [56868] user@db DETAIL: ! system usage stats:
! 0.000006 elapsed 0.000000 user 0.000000 system sec
! [0.526408 user 0.112125 sys total]
! 0/0 [0/0] filesystem blocks in/out
! 0/0 [0/1281] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [3516/0] voluntary/involuntary context switches
Thank you