Using stat collector for collecting long SQL

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Using stat collector for collecting long SQL
Date: 2020-02-27 08:42:19
Message-ID: CAFj8pRA=kdsqyKwYnEWXN7B6yontDfuQbAkgGh_9HDtVmhPKbg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

There is a often problem with taking source of long SQL strings. The
pg_stat_activity field query is reduced to some short limit and is not too
practical to increase this limit.

I have a idea to use for solution of this problem stat_collector process.
When the query string is reduced, then full form of query string can be
saved in stat_collector process. Maybe with execution plan. Then any
process can read these information from this process.

What do you think about this idea? It can be base for implementation
EXPLAIN PID ?

Notes, comments?

Regards

Pavel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Antonin Houska 2020-02-27 08:51:41 Re: WIP: Aggregation push-down
Previous Message Sandro Santilli 2020-02-27 08:32:24 Re: [postgis-devel] About EXTENSION from UNPACKAGED on PostgreSQL 13