explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tK1

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.006 ↓ 0.0 0 1

Nested Loop (cost=105.67..14,465.06 rows=1 width=20) (actual time=0.006..0.006 rows=0 loops=1)

2. 0.000 0.005 ↓ 0.0 0 1

Nested Loop (cost=105.25..14,456.60 rows=1 width=82) (actual time=0.005..0.005 rows=0 loops=1)

3. 0.000 0.005 ↓ 0.0 0 1

Nested Loop (cost=104.82..14,455.96 rows=1 width=78) (actual time=0.005..0.005 rows=0 loops=1)

  • Join Filter: (d.version_md5 = o.version_md5)
4. 0.000 0.005 ↓ 0.0 0 1

Nested Loop (cost=4.69..12.73 rows=1 width=45) (actual time=0.005..0.005 rows=0 loops=1)

5. 0.005 0.005 ↓ 0.0 0 1

Index Only Scan using resource_disabled_versions_resource_id_version_md5_uniq on resource_disabled_versions d (cost=0.27..4.29 rows=1 width=37) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((resource_id IS NULL) AND (version_md5 IS NULL))
  • Heap Fetches: 0
6. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on resources r (cost=4.42..8.43 rows=1 width=8) (never executed)

  • Recheck Cond: (id = d.resource_id)
  • Filter: (pipeline_id = 303697)
7. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on resources_pkey (cost=0.00..4.42 rows=1 width=0) (never executed)

  • Index Cond: (id = d.resource_id)
8. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on build_resource_config_version_outputs o (cost=100.13..14,379.20 rows=5,122 width=41) (never executed)

  • Recheck Cond: (resource_id = r.id)
9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on build_resource_config_version_outputs_resource_id_idx (cost=0.00..98.85 rows=5,122 width=0) (never executed)

  • Index Cond: (resource_id = r.id)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using builds_pkey on builds b (cost=0.43..0.63 rows=1 width=8) (never executed)

  • Index Cond: (id = o.build_id)
  • Filter: (status = 'succeeded'::build_status)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using resource_config_scope_id_and_version_md5_unique on resource_config_versions v (cost=0.42..8.44 rows=1 width=45) (never executed)

  • Index Cond: ((resource_config_scope_id = r.resource_config_scope_id) AND (version_md5 = o.version_md5))
  • Filter: (check_order <> 0)
Planning time : 4.572 ms
Execution time : 0.119 ms