[PATCH] Add statement_timeout in pg_stat_activity

From: Anthonin Bonnefoy <anthonin(dot)bonnefoy(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: [PATCH] Add statement_timeout in pg_stat_activity
Date: 2023-04-03 18:51:31
Message-ID: CAD9KVnRZwcKwfTdTX1HrrJiwmUiWGHtvA30-cur2VXS1ZZB14A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello hackers.

This patch adds the backend's statement_timeout value to pg_stat_activity.

This would provide some insights on clients that are disabling a default
statement timeout or overriding it through a pgbouncer, messing with other
sessions.

pg_stat_activity seemed like the best place to have this information.

Regards,
Anthonin

Attachment Content-Type Size
0001-statement-timeout-in-pg-stat-activity.patch text/x-patch 14.8 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2023-04-03 18:52:13 Re: Why enable_hashjoin Completely disables HashJoin
Previous Message Pavel Stehule 2023-04-03 18:49:35 Re: possible proposal plpgsql GET DIAGNOSTICS oid = PG_ROUTINE_OID