PostgresDB 25P03: Idle in Transaction Session Timeout

What is PostgresDB 25P03: Idle in Transaction Session Timeout

Identify the offending transaction/query causing the timeout by checking the current activity in the database:SELECT pid, usename, application_name, state, query, state_change FROM pg_stat_activity WHERE state = 'idle in transaction';Terminate the idle transaction using the PID obtained from the above query:SELECT pg_terminate_backend(<pid_here>);Review application logs connected to the PostgreSQL database for any transactions that were not properly closed or committed. This can help identify the part of your application responsible for the issue.Adjust the idle_in_transaction_session_timeout setting to a suitable value, if necessary, based on the investigation findings to prevent future occurrences:ALTER SYSTEM SET idle_in_transaction_session_timeout = '5min';Followed by reloading the configuration:SELECT pg_reload_conf();