Slide 21
Slide 21 text
postgres=# SELECT state, wait_event_type, wait_event, substring(query for 100) FROM pg_stat_activity WHERE backend_type = 'client backend';
state | wait_event_type | wait_event | substring
--------+-----------------+------------+------------------------------------------------------------------------------------------------------
active | | | COPY public.log_lines_30d_20200516 (log_line_id, server_id, backend_pid, occurred_at, log_file_id, l
active | | | COPY public.log_lines_30d_20200514 (log_line_id, server_id, backend_pid, occurred_at, log_file_id, l
active | | | COPY public.log_lines_30d_20200517 (log_line_id, server_id, backend_pid, occurred_at, log_file_id, l
active | | | COPY public.log_lines_30d_20200515 (log_line_id, server_id, backend_pid, occurred_at, log_file_id, l
active | | | SELECT state, wait_event_type, wait_event, substring(query for 100) FROM pg_stat_activity WHERE back
idle | Client | ClientRead |
(6 rows)