explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jDxF

Settings
# exclusive inclusive rows x rows loops node
1. 14.490 1,291.353 ↓ 7.2 32,009 1

Hash Left Join (cost=10,619.11..21,084.00 rows=4,420 width=90) (actual time=53.762..1,291.353 rows=32,009 loops=1)

  • Hash Cond: (ogm.object_group_id = og.id)
2. 15.076 1,276.426 ↓ 7.2 32,009 1

Nested Loop Left Join (cost=10,611.96..21,023.52 rows=4,420 width=39) (actual time=53.315..1,276.426 rows=32,009 loops=1)

3. 901.362 983.277 ↓ 10.4 30,897 1

Hash Left Join (cost=10,611.53..13,944.75 rows=2,964 width=35) (actual time=53.291..983.277 rows=30,897 loops=1)

  • Hash Cond: (domain_guess(d.name) = fb.brand)
4. 17.457 81.399 ↓ 10.4 30,887 1

Hash Join (cost=10,578.48..12,771.23 rows=2,964 width=26) (actual time=52.639..81.399 rows=30,887 loops=1)

  • Hash Cond: (ra.domain_name = d.name)
5. 15.702 15.702 ↓ 1.1 30,887 1

Seq Scan on rgp_action ra (cost=0.00..2,060.79 rows=27,285 width=22) (actual time=4.337..15.702 rows=30,887 loops=1)

  • Filter: (rgp_to_status = 'pendingDelete'::text)
  • Rows Removed by Filter: 49,566
6. 7.987 48.240 ↑ 1.0 30,887 1

Hash (cost=10,189.63..10,189.63 rows=31,108 width=18) (actual time=48.240..48.240 rows=30,887 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,847kB
7. 40.253 40.253 ↑ 1.0 30,887 1

Index Scan using domain_rgp_status_name_idx on domain d (cost=0.42..10,189.63 rows=31,108 width=18) (actual time=0.035..40.253 rows=30,887 loops=1)

  • Index Cond: (rgp_status_name = 'pendingDelete'::text)
8. 0.201 0.516 ↓ 2.9 1,306 1

Hash (cost=27.38..27.38 rows=453 width=9) (actual time=0.516..0.516 rows=1,306 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 70kB
9. 0.315 0.315 ↓ 2.9 1,306 1

Seq Scan on _tmp_forbes_brands fb (cost=0.00..27.38 rows=453 width=9) (actual time=0.015..0.315 rows=1,306 loops=1)

  • Filter: (length(brand) > 3)
  • Rows Removed by Filter: 53
10. 0.000 278.073 ↓ 0.0 0 30,897

Append (cost=0.43..2.37 rows=2 width=15) (actual time=0.009..0.009 rows=0 loops=30,897)

11. 216.279 216.279 ↓ 0.0 0 30,897

Index Scan using object_group_member_name_idx on object_group_member ogm (cost=0.43..2.07 rows=1 width=15) (actual time=0.007..0.007 rows=0 loops=30,897)

  • Index Cond: (name = d.name)
12. 61.794 61.794 ↓ 0.0 0 30,897

Index Scan using launch_phase_domain_name_idx on launch_phase_domain ogm_1 (cost=0.28..0.30 rows=1 width=15) (actual time=0.002..0.002 rows=0 loops=30,897)

  • Index Cond: (name = d.name)
13. 0.003 0.437 ↑ 1.0 19 1

Hash (cost=6.91..6.91 rows=19 width=23) (actual time=0.437..0.437 rows=19 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
14. 0.434 0.434 ↑ 1.0 19 1

Seq Scan on object_group og (cost=0.00..6.91 rows=19 width=23) (actual time=0.257..0.434 rows=19 loops=1)

  • Filter: (name ~ 'tier premium$'::text)
  • Rows Removed by Filter: 215