Example demo
Slow queries and index suggestions04Queries
Query
Avg time
Rows scanned
Suggestion
SELECT … WHERE project_id = $1
182 ms
2.4M
Index (project_id, created_at)
SELECT … ORDER BY updated_at DESC
96 ms
380k
Index exists · keep
JOIN tasks ON …
240 ms
5.1M
Use a pre-aggregated view
COUNT(*) audit_log
1.2 s
102M
Use estimated counts or partitions
How It Works
Query and inspect PostgreSQL databases. Open OmniMind and add the extension to your task to work with the relevant materials.
What Else Can You Do?
Query Business Metrics
Summarize business metrics using read-only queries and explain the results.
Use in OmniMind
Inspect Data Structures
Inspect tables, columns, and indexes.
Use in OmniMind
Analyze a Query Plan
Analyze a read-only query's execution plan and optimization options.
Use in OmniMind
How to Use
Find this extension in OmniMind, complete the required software setup or account authorization, and then use it in your task.