Re: Query on pg_stat_activity table got stuck

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: neeraj kumar <neeru(dot)cse(at)gmail(dot)com>
Cc: Jeremy Schneider <schnjere(at)amazon(dot)com>, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Query on pg_stat_activity table got stuck
Date: 2019-05-12 01:36:47
Message-ID: 23276.1557625007@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

I wrote:
> This patch is against HEAD --- I've not looked at how much adjustment
> it'll need for the back branches, but I'm sure there's some.

I've back-patched this now. If you want to test the patch, the v10-branch
version is at

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c3d113136bbaa86fbf1edde7aaf70ba06a6166b7

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message pavan95 2019-05-13 11:23:44 Re: Installation of login_hook in PostgreSQL 10
Previous Message Tom Lane 2019-05-11 02:57:20 Re: Query on pg_stat_activity table got stuck

Browse pgsql-general by date

  From Date Subject
Next Message Paul Costello 2019-05-13 03:51:06 logical replication on 9.6: replica configuration
Previous Message Bruce Momjian 2019-05-11 18:06:01 Re: Linked data from upgrade after VACUUM FULL not deleted.