0

I'd noticed different commit types in Postgres log:

2019-12-20 12:00:00  [99999]: [12-1] host=...,user=...,db=... LOG:  duration: 1000.000 ms execute S_2: COMMIT
2019-12-20 12:00:00  [99999]: [12-1] host=...,user=...,db=... LOG:  duration: 1000.000 ms execute S_3: COMMIT
2019-12-20 12:00:00  [99999]: [12-1] host=...,user=...,db=... LOG:  duration: 1000.000 ms execute S_4: COMMIT

Note: I changed some information to omit sensitive data.

What can I conclude when I see these different types of commit in the log?

2
  • here is answer from a few years ago
    – zsheep
    Dec 21 '19 at 2:08
  • @zsheep thanks, but It's not clear yet. These entries are created by connection drivers or Postgres internals? And what I can infer with them?
    – Rogerlr
    Jan 9 '20 at 1:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.