explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K1yd

Settings
# exclusive inclusive rows x rows loops node
1. 73.161 6,724.062 ↓ 408,497.0 408,497 1

Nested Loop (cost=22,072.02..98,473.04 rows=1 width=20) (actual time=992.410..6,724.062 rows=408,497 loops=1)

2. 1,929.520 4,092.459 ↓ 426,407.0 426,407 1

Hash Join (cost=22,071.59..98,472.39 rows=1 width=16) (actual time=856.457..4,092.459 rows=426,407 loops=1)

  • Hash Cond: ((o.version_md5 = v.version_md5) AND (r.resource_config_scope_id = v.resource_config_scope_id))
  • Join Filter: (NOT (hashed SubPlan 1))
3. 477.865 1,799.164 ↓ 244.6 1,628,768 1

Nested Loop (cost=100.57..72,242.70 rows=6,660 width=45) (actual time=0.032..1,799.164 rows=1,628,768 loops=1)

4. 0.075 0.075 ↓ 2.4 12 1

Index Scan using resources_pipeline_id on resources r (cost=0.41..23.93 rows=5 width=8) (actual time=0.011..0.075 rows=12 loops=1)

  • Index Cond: (pipeline_id = 303697)
5. 1,049.580 1,321.224 ↓ 26.5 135,731 12

Bitmap Heap Scan on build_resource_config_version_outputs o (cost=100.17..14,392.48 rows=5,127 width=41) (actual time=29.500..110.102 rows=135,731 loops=12)

  • Recheck Cond: (resource_id = r.id)
  • Heap Blocks: exact=140912
6. 271.644 271.644 ↓ 26.5 135,731 12

Bitmap Index Scan on build_resource_config_version_outputs_resource_id_idx (cost=0.00..98.89 rows=5,127 width=0) (actual time=22.637..22.637 rows=135,731 loops=12)

  • Index Cond: (resource_id = r.id)
7. 167.193 363.728 ↓ 1.0 393,829 1

Hash (cost=12,604.70..12,604.70 rows=393,392 width=45) (actual time=363.727..363.728 rows=393,829 loops=1)

  • Buckets: 65536 Batches: 16 Memory Usage: 2467kB
8. 196.535 196.535 ↓ 1.0 393,829 1

Seq Scan on resource_config_versions v (cost=0.00..12,604.70 rows=393,392 width=45) (actual time=0.015..196.535 rows=393,829 loops=1)

  • Filter: (check_order <> 0)
  • Rows Removed by Filter: 959
9.          

SubPlan (forHash Join)

10. 0.047 0.047 ↑ 1.0 355 1

Seq Scan on resource_disabled_versions (cost=0.00..6.55 rows=355 width=37) (actual time=0.008..0.047 rows=355 loops=1)

11. 2,558.442 2,558.442 ↑ 1.0 1 426,407

Index Scan using builds_pkey on builds b (cost=0.43..0.64 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=426,407)

  • Index Cond: (id = o.build_id)
  • Filter: (status = 'succeeded'::build_status)
  • Rows Removed by Filter: 0
Planning time : 1.420 ms
Execution time : 6,778.401 ms