Query Tuning

Query Tuning

Tuning and optimizing query performance

Tune and optimize query performance in YugabyteDB.

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.

Analyze queries with EXPLAIN

Tune your queries by creating and analyzing execution plans.

Optimize YSQL queries using pg_hint_plan

Control query execution plans with hinting phrases.