Re: [PATCH v5] pg_stat_statements: Add last_execution_start column

From: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH v5] pg_stat_statements: Add last_execution_start column
Date: 2026-06-10 21:21:10
Message-ID: CAN4CZFNbJtY_k6KeJHCgaYN=3XYghOHNjdrUuaA6h2jxux-V+A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have one more question: should statements that failed have an
execution start set?

CREATE TABLE t(d int);
INSERT INTO t VALUES (0);

SELECT pg_stat_statements_reset();
SELECT now() AS ref_ts \gset
SELECT 1/d FROM t;

SELECT calls, plans, query FROM pg_stat_statements
WHERE last_execution_start >= :'ref_ts'
AND query LIKE '%/d FROM t%';

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sami Imseih 2026-06-10 21:22:49 Re: [PATCH v5] pg_stat_statements: Add last_execution_start column
Previous Message Zsolt Parragi 2026-06-10 20:54:15 Re: Support EXCEPT for TABLES IN SCHEMA publications