explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jXJo

Settings
# exclusive inclusive rows x rows loops node
1. 0.117 966.603 ↑ 12.4 126 1

Hash Left Join (cost=10,619.11..16,466.42 rows=1,558 width=90) (actual time=68.004..966.603 rows=126 loops=1)

  • Hash Cond: (ogm.object_group_id = og.id)
2. 0.039 966.033 ↑ 12.4 126 1

Nested Loop Left Join (cost=10,611.96..16,440.47 rows=1,558 width=39) (actual time=67.539..966.033 rows=126 loops=1)

3. 870.140 963.906 ↑ 9.0 116 1

Hash Join (cost=10,611.53..13,944.75 rows=1,045 width=35) (actual time=67.508..963.906 rows=116 loops=1)

  • Hash Cond: (domain_guess(d.name) = fb.brand)
4. 15.559 92.760 ↓ 10.4 30,886 1

Hash Join (cost=10,578.48..12,771.23 rows=2,964 width=26) (actual time=64.423..92.760 rows=30,886 loops=1)

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

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

  • Filter: (rgp_to_status = 'pendingDelete'::text)
  • Rows Removed by Filter: 49,565
6. 7.072 59.222 ↑ 1.0 30,886 1

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

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,847kB
7. 52.150 52.150 ↑ 1.0 30,886 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.041..52.150 rows=30,886 loops=1)

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

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

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

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

  • Filter: (length(brand) > 3)
  • Rows Removed by Filter: 53
10. 0.116 2.088 ↓ 0.0 0 116

Append (cost=0.43..2.37 rows=2 width=15) (actual time=0.017..0.018 rows=0 loops=116)

11. 1.508 1.508 ↓ 0.0 0 116

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.013..0.013 rows=0 loops=116)

  • Index Cond: (name = d.name)
12. 0.464 0.464 ↓ 0.0 0 116

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.004..0.004 rows=0 loops=116)

  • Index Cond: (name = d.name)
13. 0.005 0.453 ↑ 1.0 19 1

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

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

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

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