explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ha6J

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=181,168.83..181,168.84 rows=1 width=8) (actual rows= loops=)

2.          

CTE base_executions

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..166,397.53 rows=2,110 width=1,794) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using test_requests_by_branch_commit on branch_commit_test_requests r (cost=0.55..48.75 rows=11 width=16) (actual rows= loops=)

  • Index Cond: ((git_branch = 'develop'::text) AND (git_commit = '4f640df029719efb767f460aa88c74638dc57314'::text))
5. 0.000 0.000 ↓ 0.0

Index Scan using test_executions_by_request on test_executions e (cost=0.57..15,085.38 rows=3,724 width=1,794) (actual rows= loops=)

  • Index Cond: (test_request_id = r.id)
6.          

CTE feature_executions

7. 0.000 0.000 ↓ 0.0

Index Scan using test_executions_by_request on test_executions e_1 (cost=0.57..13,711.75 rows=3,382 width=1,794) (actual rows= loops=)

  • Index Cond: (test_request_id = '6f642bb6-971a-4764-a0ce-15a4b7537e65'::uuid)
8. 0.000 0.000 ↓ 0.0

Aggregate (cost=1,059.54..1,059.55 rows=1 width=8) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Merge Join (cost=424.59..970.34 rows=35,680 width=0) (actual rows= loops=)

  • Merge Cond: (b.scenario_id = f.scenario_id)
10. 0.000 0.000 ↓ 0.0

Sort (cost=158.70..163.98 rows=2,110 width=32) (actual rows= loops=)

  • Sort Key: b.scenario_id
11. 0.000 0.000 ↓ 0.0

CTE Scan on base_executions b (cost=0.00..42.20 rows=2,110 width=32) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Sort (cost=265.89..274.34 rows=3,382 width=32) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Sort Key: f.scenario_id" -> CTE Scan on feature_executions f (cost=0.00..67.64 rows=3,382 width=32) (actual rows= loops=)