Tuning and optimizing query performance
Get query statistics using pg_stat_statements
Track planning and execution statistics for all SQL statements executed by a server.
View live queries with pg_stat_activity
Troubleshoot problems and identify long-running queries with the activity view.
View terminated queries with yb_terminated_queries
Identify terminated queries with the get queries function.
View COPY status with pg_stat_progress_copy
Get the COPY command status, number of tuples processed, and other COPY progress reports with this view.
View CREATE INDEX status with pg_stat_progress_create_index
Get the CREATE INDEX command status, including the status of an ongoing concurrent index backfill, and the index build's progress reports.