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_pg_stat_get_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.