Help decrypting postgresql logs?

Question

PostgreSQL

Good afternoon.
Help to understand what is the difference between the operation in the logs "execution" and "operator". in fact, the operation is the same, but how to send a request for execution on your own? In the first option, the request comes from third-party software; in the second, I send it. you need to understand how to send a request like a software sender yourself 2019-08-27
10:41:58 EEST TAG: operator: SELECT 1
fir_type = $2
2019-08-27 10:41:58 EEST DETAILS: parameters: $1 = 'iwmfKQwL', $2 = '2'
2019-08-27 10:42:06 EEST TAG: operator: ROLLBACK
2019-08-27 10:42:06 EEST MARK: operator: BEGIN
2019-08-27 10:42:06 EEST TAG: statement: DELETE FROM fr_enrolled_persons WHERE fr_enrolled_persons.person_guid = 'iwmfKQwL' AND fr_enrolled_persons.fir_type = 2
2019-08-27 10:42:06 EEST TAG: statement: COMMIT

Answer 1

Not an "operator" because it's a statement - and it will immediately be a little clearer what it's about.
The first delete came through the extended protocol, also known as prepared statements. Next to execute, there should also be parse and bind.
The second - through the simple query protocol, that is, just the text of the request.