How can we monitor the number of parallel workers that were used by CREATE INDEX? #PostgreSQL
Conversation
Replying to
The pg_stat_progress_create_index view on v12. The trace_sort GUC + client_min_messages=LOG on v11.
2
1
6
Replying to
Which column in pg_stat_progress_create_index indicates that? Thanks in advance!
1
Replying to
Hmm. I guess it doesn't actually say anything about the number of workers (though pg_stat_activity will show that). Parallel workers are only used for the scan and initial sorting, which usually means that they are only active for about the first half of an index build.
Replying to
Thanks! Yes, I'm thinking to use pg_stat_activity for that monitoring purpose.