Manual:$wgDebugDBTransactions

Details
This feature work currently only for PostgreSQL.

This setting enables additional database transaction lifecycle tracing in the debug output:

Transaction state changed from IDLE -> TRANS

Whenever transaction status is changed
 * IDLE: no database transaction is open
 * TRANS: a transaction has been open
 * ERROR: a transaction is in an error state

Example output: Query trunk (15) (slave): BEGIN Transaction state changed from IDLE -> TRANS Query trunk (16) (slave): SELECT /* DatabasePostgres::schemaExists */  1 FROM "pg_catalog"."pg_namespace" WHERE nspname = 'mediawiki'  LIMIT 1 Query trunk (17) (slave): SELECT /* DatabasePostgres::getSchemas */ current_schemas(false) Schema "mediawiki" already in the search path Query trunk (18) (slave): COMMIT Transaction state changed from TRANS -> IDLE