/PgExplainAnalyze
Breaks down complex PostgreSQL query plans, flags hidden sequential scans, nested loop bottlenecks, buffer cache misses, and generates targeted index recommendations.
Databases & SQL🔴 Advanced#postgres#explain
Query Authoring
67 commands
/ParameterizeAggregateQuery
Parameterize and secure against injection an aggregation query — e.g. total revenue by region and month.
Databases & SQL🟢 Beginner#aggregate#groupby
/ExplainStoredProcedure
Explain step by step what a stored procedure — e.g. a procedure that recalculates loyalty points nightly.
Databases & SQL🟢 Beginner#stored-procedure#plsql
/DebugSlowQuery
Find and fix the bug in a slow-running production query — e.g. a report query that now takes 40 seconds instead of.
Databases & SQL🟢 Beginner#performance#slow-query
/OptimizePivotQuery
Optimize the performance of a pivot/unpivot query — e.g. turning monthly rows into columns for a dashboard.
Databases & SQL🟢 Beginner#pivot#reshape
/WriteRecursiveCte
Write an efficient SQL query for a recursive common table expression — e.g. traversing an employee-manager hierarchy.
Databases & SQL🟢 Beginner#cte#recursive
/ParameterizeMigrationScript
Parameterize and secure against injection a data migration SQL script — e.g. moving legacy order data into a new normalized schema.
Databases & SQL🟢 Beginner#migration#etl
/ConvertDeduplicationQuery
Convert to a different SQL dialect a deduplication query — e.g. removing duplicate customer records keeping the most recent.
Databases & SQL🟢 Beginner#dedupe#cleanup
/ExplainUpsertStatement
Explain step by step what an upsert (insert-or-update) statement — e.g. syncing a nightly product feed into a catalog table.
Databases & SQL🟢 Beginner#upsert#merge
/DebugSubqueryChain
Find and fix the bug in a nested subquery — e.g. finding customers whose spend is above their region's average.
Databases & SQL🟢 Beginner#subquery#nested
/OptimizeAggregateQuery
Optimize the performance of an aggregation query — e.g. total revenue by region and month.
Databases & SQL🟢 Beginner#aggregate#groupby
/ParameterizeRecursiveCte
Parameterize and secure against injection a recursive common table expression — e.g. traversing an employee-manager hierarchy.
Databases & SQL🟢 Beginner#cte#recursive
/ConvertWindowFunctionQuery
Convert to a different SQL dialect a window function query — e.g. running totals of daily signups per week.
Databases & SQL🟢 Beginner#window-function#analytics
/ExplainJoinQuery
Explain step by step what a multi-table join query — e.g. joining orders, customers and products for a sales report.
Databases & SQL🟢 Beginner#join#sql
/OptimizeMigrationScript
Optimize the performance of a data migration SQL script — e.g. moving legacy order data into a new normalized schema.
Databases & SQL🟢 Beginner#migration#etl
/WriteDeduplicationQuery
Write an efficient SQL query for a deduplication query — e.g. removing duplicate customer records keeping the most recent.
Databases & SQL🟢 Beginner#dedupe#cleanup
/ConvertStoredProcedure
Convert to a different SQL dialect a stored procedure — e.g. a procedure that recalculates loyalty points nightly.
Databases & SQL🟢 Beginner#stored-procedure#plsql
/ExplainSlowQuery
Explain step by step what a slow-running production query — e.g. a report query that now takes 40 seconds instead of.
Databases & SQL🟢 Beginner#performance#slow-query
/DebugPivotQuery
Find and fix the bug in a pivot/unpivot query — e.g. turning monthly rows into columns for a dashboard.
Databases & SQL🟢 Beginner#pivot#reshape
/OptimizeRecursiveCte
Optimize the performance of a recursive common table expression — e.g. traversing an employee-manager hierarchy.
Databases & SQL🟢 Beginner#cte#recursive
/WriteWindowFunctionQuery
Write an efficient SQL query for a window function query — e.g. running totals of daily signups per week.
Databases & SQL🟢 Beginner#window-function#analytics
/ParameterizeDeduplicationQuery
Parameterize and secure against injection a deduplication query — e.g. removing duplicate customer records keeping the most recent.
Databases & SQL🟢 Beginner#dedupe#cleanup
/ConvertUpsertStatement
Convert to a different SQL dialect an upsert (insert-or-update) statement — e.g. syncing a nightly product feed into a catalog table.
Databases & SQL🟢 Beginner#upsert#merge
/ExplainSubqueryChain
Explain step by step what a nested subquery — e.g. finding customers whose spend is above their region's average.
Databases & SQL🟢 Beginner#subquery#nested
/DebugAggregateQuery
Find and fix the bug in an aggregation query — e.g. total revenue by region and month.
Databases & SQL🟢 Beginner#aggregate#groupby
/WriteStoredProcedure
Write an efficient SQL query for a stored procedure — e.g. a procedure that recalculates loyalty points nightly.
Databases & SQL🟢 Beginner#stored-procedure#plsql
/ParameterizeWindowFunctionQuery
Parameterize and secure against injection a window function query — e.g. running totals of daily signups per week.
Databases & SQL🟢 Beginner#window-function#analytics
/ConvertJoinQuery
Convert to a different SQL dialect a multi-table join query — e.g. joining orders, customers and products for a sales report.
Databases & SQL🟢 Beginner#join#sql
/DebugMigrationScript
Find and fix the bug in a data migration SQL script — e.g. moving legacy order data into a new normalized schema.
Databases & SQL🟢 Beginner#migration#etl
/OptimizeDeduplicationQuery
Optimize the performance of a deduplication query — e.g. removing duplicate customer records keeping the most recent.
Databases & SQL🟢 Beginner#dedupe#cleanup
/WriteUpsertStatement
Write an efficient SQL query for an upsert (insert-or-update) statement — e.g. syncing a nightly product feed into a catalog table.
Databases & SQL🟢 Beginner#upsert#merge
/ParameterizeStoredProcedure
Parameterize and secure against injection a stored procedure — e.g. a procedure that recalculates loyalty points nightly.
Databases & SQL🟢 Beginner#stored-procedure#plsql
/ConvertSlowQuery
Convert to a different SQL dialect a slow-running production query — e.g. a report query that now takes 40 seconds instead of.
Databases & SQL🟢 Beginner#performance#slow-query
/ExplainPivotQuery
Explain step by step what a pivot/unpivot query — e.g. turning monthly rows into columns for a dashboard.
Databases & SQL🟢 Beginner#pivot#reshape
/DebugRecursiveCte
Find and fix the bug in a recursive common table expression — e.g. traversing an employee-manager hierarchy.
Databases & SQL🟢 Beginner#cte#recursive
/OptimizeWindowFunctionQuery
Optimize the performance of a window function query — e.g. running totals of daily signups per week.
Databases & SQL🟢 Beginner#window-function#analytics
/WriteJoinQuery
Write an efficient SQL query for a multi-table join query — e.g. joining orders, customers and products for a sales report.
Databases & SQL🟢 Beginner#join#sql
/ParameterizeUpsertStatement
Parameterize and secure against injection an upsert (insert-or-update) statement — e.g. syncing a nightly product feed into a catalog table.
Databases & SQL🟢 Beginner#upsert#merge
/ConvertSubqueryChain
Convert to a different SQL dialect a nested subquery — e.g. finding customers whose spend is above their region's average.
Databases & SQL🟢 Beginner#subquery#nested
/ExplainAggregateQuery
Explain step by step what an aggregation query — e.g. total revenue by region and month.
Databases & SQL🟢 Beginner#aggregate#groupby
/OptimizeStoredProcedure
Optimize the performance of a stored procedure — e.g. a procedure that recalculates loyalty points nightly.
Databases & SQL🟢 Beginner#stored-procedure#plsql
/WriteSlowQuery
Write an efficient SQL query for a slow-running production query — e.g. a report query that now takes 40 seconds instead of.
Databases & SQL🟢 Beginner#performance#slow-query
/ParameterizeJoinQuery
Parameterize and secure against injection a multi-table join query — e.g. joining orders, customers and products for a sales report.
Databases & SQL🟢 Beginner#join#sql
/ExplainMigrationScript
Explain step by step what a data migration SQL script — e.g. moving legacy order data into a new normalized schema.
Databases & SQL🟢 Beginner#migration#etl
/DebugDeduplicationQuery
Find and fix the bug in a deduplication query — e.g. removing duplicate customer records keeping the most recent.
Databases & SQL🟢 Beginner#dedupe#cleanup
/OptimizeUpsertStatement
Optimize the performance of an upsert (insert-or-update) statement — e.g. syncing a nightly product feed into a catalog table.
Databases & SQL🟢 Beginner#upsert#merge
/WriteSubqueryChain
Write an efficient SQL query for a nested subquery — e.g. finding customers whose spend is above their region's average.
Databases & SQL🟢 Beginner#subquery#nested
/ParameterizeSlowQuery
Parameterize and secure against injection a slow-running production query — e.g. a report query that now takes 40 seconds instead of.
Databases & SQL🟢 Beginner#performance#slow-query
/ConvertPivotQuery
Convert to a different SQL dialect a pivot/unpivot query — e.g. turning monthly rows into columns for a dashboard.
Databases & SQL🟢 Beginner#pivot#reshape
/ExplainRecursiveCte
Explain step by step what a recursive common table expression — e.g. traversing an employee-manager hierarchy.
Databases & SQL🟢 Beginner#cte#recursive
/DebugWindowFunctionQuery
Find and fix the bug in a window function query — e.g. running totals of daily signups per week.
Databases & SQL🟢 Beginner#window-function#analytics
/OptimizeJoinQuery
Optimize the performance of a multi-table join query — e.g. joining orders, customers and products for a sales report.
Databases & SQL🟢 Beginner#join#sql
/ParameterizeSubqueryChain
Parameterize and secure against injection a nested subquery — e.g. finding customers whose spend is above their region's average.
Databases & SQL🟢 Beginner#subquery#nested
/ConvertAggregateQuery
Convert to a different SQL dialect an aggregation query — e.g. total revenue by region and month.
Databases & SQL🟢 Beginner#aggregate#groupby
/DebugStoredProcedure
Find and fix the bug in a stored procedure — e.g. a procedure that recalculates loyalty points nightly.
Databases & SQL🟢 Beginner#stored-procedure#plsql
/OptimizeSlowQuery
Optimize the performance of a slow-running production query — e.g. a report query that now takes 40 seconds instead of.
Databases & SQL🟢 Beginner#performance#slow-query
/WritePivotQuery
Write an efficient SQL query for a pivot/unpivot query — e.g. turning monthly rows into columns for a dashboard.
Databases & SQL🟢 Beginner#pivot#reshape
/ConvertMigrationScript
Convert to a different SQL dialect a data migration SQL script — e.g. moving legacy order data into a new normalized schema.
Databases & SQL🟢 Beginner#migration#etl
/ExplainDeduplicationQuery
Explain step by step what a deduplication query — e.g. removing duplicate customer records keeping the most recent.
Databases & SQL🟢 Beginner#dedupe#cleanup
/DebugUpsertStatement
Find and fix the bug in an upsert (insert-or-update) statement — e.g. syncing a nightly product feed into a catalog table.
Databases & SQL🟢 Beginner#upsert#merge
/OptimizeSubqueryChain
Optimize the performance of a nested subquery — e.g. finding customers whose spend is above their region's average.
Databases & SQL🟢 Beginner#subquery#nested
/WriteAggregateQuery
Write an efficient SQL query for an aggregation query — e.g. total revenue by region and month.
Databases & SQL🟢 Beginner#aggregate#groupby
/ParameterizePivotQuery
Parameterize and secure against injection a pivot/unpivot query — e.g. turning monthly rows into columns for a dashboard.
Databases & SQL🟢 Beginner#pivot#reshape
/ConvertRecursiveCte
Convert to a different SQL dialect a recursive common table expression — e.g. traversing an employee-manager hierarchy.
Databases & SQL🟢 Beginner#cte#recursive
/ExplainWindowFunctionQuery
Explain step by step what a window function query — e.g. running totals of daily signups per week.
Databases & SQL🟢 Beginner#window-function#analytics
/DebugJoinQuery
Find and fix the bug in a multi-table join query — e.g. joining orders, customers and products for a sales report.
Databases & SQL🟢 Beginner#join#sql
/WriteMigrationScript
Write an efficient SQL query for a data migration SQL script — e.g. moving legacy order data into a new normalized schema.
Databases & SQL🟢 Beginner#migration#etl