Home > mailing lists

[BeginnerQuestion]Why these is 6 rows in my SELECT statement? - Mailing list pgsql-general

From	BeginnerC
Subject	[BeginnerQuestion]Why these is 6 rows in my SELECT statement?
Date	September 8, 2022 11:37:00
Msg-id	TYAP286MB063680EB7BB92F95F170FA65A9409@TYAP286MB0636.JPNP286.PROD.OUTLOOK.COM Whole thread Raw
Responses	Re: [BeginnerQuestion]Why these is 6 rows in my SELECT statement? Re: [BeginnerQuestion]Why these is 6 rows in my SELECT statement?
List	pgsql-general

Hello community,

I am checking my pg_stat_activity view,but something confused me.

Just like this:

postgres=# SELECT wait_event_type, wait_event FROM pg_stat_activity;

wait_event_type | wait_event

-----------------+---------------------

Activity | AutoVacuumMain

Activity | LogicalLauncherMain

Activity | BgWriterHibernate

Activity | CheckpointerMain

Activity | WalWriterMain

(6 rows)

As you can see, the third row is empty,but I don't know why.

Can anyone provide some solution to me?

Thanks in advance!

Yours,

BeginnerC.

From: Tom Lane
Date: 07 September 2022, 16:30:49
Subject: Re: [EXT] Re: log_min_messages = warning

From: Ian Lawrence Barwick
Date: 08 September 2022, 12:02:05
Subject: Re: [BeginnerQuestion]Why these is 6 rows in my SELECT statement?