Re: pg_stat_activity.query empty

2022-04-26 Thread Ian Lawrence Barwick
2022年4月26日(火) 23:24 Laurenz Albe : > > On Tue, 2022-04-26 at 06:59 -0700, David G. Johnston wrote: > > On Tue, Apr 26, 2022 at 6:55 AM Robert Lichtenberger > > wrote: > > > When executing "SELECT * FROM pg_stat_activity" I get lots of rows that > > > have an empty "query" column. > > > > > > Acco

Re: pg_stat_activity.query empty

2022-04-26 Thread Laurenz Albe
On Tue, 2022-04-26 at 06:59 -0700, David G. Johnston wrote: > On Tue, Apr 26, 2022 at 6:55 AM Robert Lichtenberger > wrote: > > When executing "SELECT * FROM pg_stat_activity" I get lots of rows that  > > have an empty "query" column. > > > > According to [1] this column should contain the "Text

Re: pg_stat_activity.query empty

2022-04-26 Thread David G. Johnston
On Tue, Apr 26, 2022 at 6:55 AM Robert Lichtenberger < r.lichtenber...@synedra.com> wrote: > When executing "SELECT * FROM pg_stat_activity" I get lots of rows that > have an empty "query" column. > > According to [1] this column should contain the "Text of this backend's > most recent query", eit

pg_stat_activity.query empty

2022-04-26 Thread Robert Lichtenberger
When executing "SELECT * FROM pg_stat_activity" I get lots of rows that have an empty "query" column. According to [1] this column should contain the "Text of this backend's most recent query", either a query that is currently running or the last query that was executed. So how comes that a