Re: [BeginnerQuestion]Why these is 6 rows in my SELECT statement?

Ian Lawrence Barwick <barwick@xxxxxxxxx> · Thu, 8 Sep 2022 18:02:05 +0900

2022年9月8日(木) 17:37 BeginnerC <chuxuec@xxxxxxxxxxx>:
>
> 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?

It's empty because that's your own client session and it's not waiting
on anything :).

     postgres=# SELECT pg_backend_pid();
     pg_backend_pid
    ----------------
              24941
    (1 row)

   postgres=# SELECT pid, backend_type, wait_event_type, wait_event
FROM pg_stat_activity;
      pid  |         backend_type         | wait_event_type |
wait_event
    -------+------------------------------+-----------------+---------------------
     20859 | autovacuum launcher          | Activity        | AutoVacuumMain
     20860 | logical replication launcher | Activity        |
LogicalLauncherMain
     21554 | walsender                    | Activity        | WalSenderMain
     24941 | client backend               |                 |
     20856 | background writer            | Activity        | BgWriterHibernate
     20855 | checkpointer                 | Activity        | CheckpointerMain
     20858 | walwriter                    | Activity        | WalWriterMain
    (7 rows)

Regards

Ian Barwick