explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6i6E

Settings
# exclusive inclusive rows x rows loops node
1. 957.532 14,983.975 ↓ 9.9 30,899 1

Hash Left Join (cost=10,616.73..18,828.68 rows=3,135 width=122) (actual time=136.970..14,983.975 rows=30,899 loops=1)

  • Hash Cond: (domain_guess(d.name) = fb.brand)
2. 966.647 1,357.522 ↓ 10.4 30,889 1

Nested Loop Left Join (cost=10,579.16..15,243.21 rows=2,964 width=36) (actual time=136.047..1,357.522 rows=30,889 loops=1)

3. 20.639 174.652 ↓ 10.4 30,889 1

Hash Join (cost=10,578.48..12,771.23 rows=2,964 width=26) (actual time=135.877..174.652 rows=30,889 loops=1)

  • Hash Cond: (ra.domain_name = d.name)
4. 24.536 24.536 ↓ 1.1 30,889 1

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

  • Filter: (rgp_to_status = 'pendingDelete'::text)
  • Rows Removed by Filter: 49,566
5. 7.722 129.477 ↑ 1.0 30,889 1

Hash (cost=10,189.63..10,189.63 rows=31,108 width=18) (actual time=129.476..129.477 rows=30,889 loops=1)

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

  • Index Cond: (rgp_status_name = 'pendingDelete'::text)
7. 216.223 216.223 ↓ 0.0 0 30,889

Index Only Scan using _tmp_dictionary_words_word_key on _tmp_dictionary_words dw (cost=0.67..0.82 rows=1 width=10) (actual time=0.007..0.007 rows=0 loops=30,889)

  • Index Cond: (word = domain_guess(d.name))
  • Heap Fetches: 0
8. 0.161 0.331 ↑ 1.0 1,359 1

Hash (cost=20.59..20.59 rows=1,359 width=9) (actual time=0.330..0.331 rows=1,359 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 72kB
9. 0.170 0.170 ↑ 1.0 1,359 1

Seq Scan on _tmp_forbes_brands fb (cost=0.00..20.59 rows=1,359 width=9) (actual time=0.016..0.170 rows=1,359 loops=1)

10.          

SubPlan (for Hash Left Join)

11. 0.000 12,668.590 ↓ 0.0 0 30,899

Nested Loop (cost=0.43..12.64 rows=38 width=0) (actual time=0.410..0.410 rows=0 loops=30,899)

12. 12,205.105 12,205.105 ↑ 1.1 18 30,899

Seq Scan on object_group og (cost=0.00..6.91 rows=19 width=0) (actual time=0.241..0.395 rows=18 loops=30,899)

  • Filter: (name ~ 'tier premium$'::text)
  • Rows Removed by Filter: 210
13. 205.252 545.141 ↓ 0.0 0 545,141

Materialize (cost=0.43..5.25 rows=2 width=0) (actual time=0.001..0.001 rows=0 loops=545,141)

14. 4.646 339.889 ↓ 0.0 0 30,899

Append (cost=0.43..5.25 rows=2 width=0) (actual time=0.011..0.011 rows=0 loops=30,899)

15. 278.091 278.091 ↓ 0.0 0 30,899

Index Only Scan using object_group_member_name_idx on object_group_member ogm (cost=0.43..3.45 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=30,899)

  • Index Cond: (name = d.name)
  • Heap Fetches: 248
16. 57.152 57.152 ↓ 0.0 0 28,576

Index Only Scan using launch_phase_domain_name_idx on launch_phase_domain ogm_1 (cost=0.28..1.80 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=28,576)

  • Index Cond: (name = d.name)
  • Heap Fetches: 0