explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gcrf

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 50,029.650 ↑ 1.0 10 1

Limit (cost=0.84..1,554.89 rows=10 width=60) (actual time=79.771..50,029.650 rows=10 loops=1)

2. 0.131 50,029.642 ↑ 296.4 10 1

Nested Loop (cost=0.84..460,620.89 rows=2,964 width=60) (actual time=79.770..50,029.642 rows=10 loops=1)

3. 0.091 0.091 ↑ 3,343.0 10 1

Index Scan using domain_rgp_status_name_idx on domain d (cost=0.42..10,230.27 rows=33,430 width=18) (actual time=0.066..0.091 rows=10 loops=1)

  • Index Cond: (rgp_status_name = 'pendingDelete'::text)
4. 0.160 0.160 ↑ 1.0 1 10

Index Only Scan using rgp_action_transaction_date_idx2 on rgp_action ra (cost=0.42..0.53 rows=1 width=22) (actual time=0.015..0.016 rows=1 loops=10)

  • Index Cond: ((domain_name = d.name) AND (rgp_to_status = 'pendingDelete'::text))
  • Heap Fetches: 10
5.          

SubPlan (for Nested Loop)

6. 0.014 0.240 ↓ 0.0 0 10

Nested Loop (cost=0.57..13.09 rows=1 width=0) (actual time=0.024..0.024 rows=0 loops=10)

7. 0.020 0.190 ↓ 0.0 0 10

Append (cost=0.43..6.75 rows=2 width=4) (actual time=0.018..0.019 rows=0 loops=10)

8. 0.110 0.110 ↓ 0.0 0 10

Index Scan using object_group_member_name_idx on object_group_member ogm (cost=0.43..3.45 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=10)

  • Index Cond: (name = d.name)
9. 0.060 0.060 ↓ 0.0 0 10

Index Scan using launch_phase_domain_name_idx on launch_phase_domain ogm_1 (cost=0.28..3.30 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=10)

  • Index Cond: (name = d.name)
10. 0.036 0.036 ↓ 0.0 0 1

Index Scan using object_group_pkey on object_group og (cost=0.14..3.17 rows=1 width=4) (actual time=0.036..0.036 rows=0 loops=1)

  • Index Cond: (id = ogm.object_group_id)
  • Filter: (name ~ 'tier premium$'::text)
  • Rows Removed by Filter: 1
11. 0.020 625.030 ↓ 0.0 0 10

Result (cost=68.18..68.19 rows=1 width=1) (actual time=62.503..62.503 rows=0 loops=10)

  • One-Time Filter: $5
12.          

Initplan (for Result)

13. 625.010 625.010 ↓ 0.0 0 10

Index Scan using fb_brand_len_idx on _tmp_forbes_brands fb (cost=0.28..136.09 rows=2 width=0) (actual time=62.501..62.501 rows=0 loops=10)

  • Index Cond: (length(brand) > 2)
  • Filter: (domain_guess(d.name) ~ brand)
  • Rows Removed by Filter: 1,354
14. 0.010 49,403.990 ↑ 1.0 1 10

Result (cost=64.53..64.54 rows=1 width=1) (actual time=4,940.399..4,940.399 rows=1 loops=10)

  • One-Time Filter: $7
15.          

Initplan (for Result)

16. 49,403.980 49,403.980 ↑ 617.0 1 10

Index Scan using dw_word_len_idx on _tmp_dictionary_words dw (cost=0.42..39,557.28 rows=617 width=0) (actual time=4,940.398..4,940.398 rows=1 loops=10)

  • Index Cond: (length(word) > 2)
  • Filter: (domain_guess(d.name) ~ word)
  • Rows Removed by Filter: 111,200
Planning time : 2.685 ms
Execution time : 50,029.757 ms