View running statements

From: Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Subject: View running statements
Date: 2009-03-12 05:51:52
Message-ID: 49B8A2F8.6070107@dc.baikal.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Is there any way to inspect current running statements (optionally full
stack of these statements)? I've found there is error_context_stack
variable in each backend, but it seems there is no way to get this
variable from another backend. It will be great if Postgres have such
kind of mechanism, for instance a system table that consists statements
running longer than certain time (5-10 seconds).

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message A. Kretschmer 2009-03-12 06:12:41 Re: View running statements
Previous Message KaiGai Kohei 2009-03-12 05:04:27 Row-Trigger implicitly allows users ACL_SELECT