Skip to content

Instantly share code, notes, and snippets.

@mmr
Created July 31, 2015 21:10
Show Gist options
  • Save mmr/c65a6a5707aa2acfab52 to your computer and use it in GitHub Desktop.
Save mmr/c65a6a5707aa2acfab52 to your computer and use it in GitHub Desktop.
postgresql-update-logfile
2015-07-31 19:59:59 UTC:172.31.21.110(36736):user@db:[869]:STATEMENT: UPDATE "my_table" SET "my_field" = 'value'
2015-07-31 19:59:59 UTC:172.31.17.44(38844):user@db:[2306]:LOG: EXECUTOR STATISTICS
2015-07-31 19:59:59 UTC:172.31.17.44(38844):user@db:[2306]:DETAIL: ! system usage stats:
! 0.000031 elapsed 0.000000 user 0.000000 system sec
! [4.164260 user 1.196074 sys total]
! 0/0 [0/1408] filesystem blocks in/out
! 0/0 [0/22947] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [18272/680] voluntary/involuntary context switches
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment