explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bfuW

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,943.015 ↑ 1.0 1 1

Sort (cost=319,779.57..319,779.57 rows=1 width=5,371) (actual time=1,943.015..1,943.015 rows=1 loops=1)

  • Sort Key: prodentity0_.prod_id
  • Sort Method: quicksort Memory: 25kB
2. 4.826 1,944.184 ↑ 1.0 1 1

Gather (cost=1,590.35..319,779.56 rows=1 width=5,371) (actual time=1,942.954..1,944.184 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 203.971 1,939.358 ↓ 0.0 0 3 / 3

Hash Join (cost=590.35..318,779.46 rows=1 width=5,371) (actual time=1,861.065..1,939.358 rows=0 loops=3)

  • Hash Cond: (prodentity0_.prod_id = prod.prod_id)
4. 1,503.139 1,735.235 ↓ 20.8 2,016,309 3 / 3

Hash Join (cost=12.17..317,838.24 rows=96,808 width=5,371) (actual time=0.110..1,735.235 rows=2,016,309 loops=3)

  • Hash Cond: (prodentity0_.st_id = gnlstentit1_.gnl_st_id)
5. 232.030 232.030 ↑ 1.2 2,902,914 3 / 3

Parallel Seq Scan on prod prodentity0_ (cost=0.00..308,191.04 rows=3,624,904 width=5,371) (actual time=0.002..232.030 rows=2,902,914 loops=3)

6. 0.008 0.066 ↑ 1.0 9 3 / 3

Hash (cost=12.05..12.05 rows=9 width=5) (actual time=0.066..0.066 rows=9 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.058 0.058 ↑ 1.0 9 3 / 3

Seq Scan on gnl_st gnlstentit1_ (cost=0.00..12.05 rows=9 width=5) (actual time=0.008..0.058 rows=9 loops=3)

  • Filter: (((ext_shrt_code)::text = 'Active'::text) OR ((ext_shrt_code)::text = 'Pending'::text))
  • Rows Removed by Filter: 328
8. 0.004 0.152 ↑ 4.0 1 3 / 3

Hash (cost=578.13..578.13 rows=4 width=13) (actual time=0.152..0.152 rows=1 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 0.006 0.148 ↑ 4.0 1 3 / 3

Nested Loop (cost=2.00..578.13 rows=4 width=13) (actual time=0.119..0.148 rows=1 loops=3)

  • Join Filter: (gnl_char.char_id = gnl_char_lang.char_id)
10. 0.002 0.129 ↑ 4.0 1 3 / 3

Nested Loop (cost=1.72..576.89 rows=4 width=28) (actual time=0.101..0.129 rows=1 loops=3)

11. 0.003 0.121 ↑ 14.0 1 3 / 3

Nested Loop (cost=1.58..574.51 rows=14 width=35) (actual time=0.093..0.121 rows=1 loops=3)

12. 0.003 0.105 ↑ 14.0 1 3 / 3

Nested Loop (cost=1.14..472.38 rows=14 width=22) (actual time=0.077..0.105 rows=1 loops=3)

  • Join Filter: (gnl_char_val.char_val_id = gnl_char_val_lang.char_val_id)
13. 0.002 0.093 ↑ 15.0 1 3 / 3

Nested Loop (cost=0.86..467.34 rows=15 width=31) (actual time=0.065..0.093 rows=1 loops=3)

14. 0.003 0.079 ↑ 15.0 1 3 / 3

Nested Loop (cost=0.72..464.86 rows=15 width=25) (actual time=0.052..0.079 rows=1 loops=3)

15. 0.005 0.064 ↑ 65.0 1 3 / 3

Nested Loop (cost=0.57..453.84 rows=65 width=32) (actual time=0.037..0.064 rows=1 loops=3)

16. 0.031 0.031 ↑ 1.0 1 3 / 3

Seq Scan on gnl_char (cost=0.00..8.36 rows=1 width=6) (actual time=0.005..0.031 rows=1 loops=3)

  • Filter: ((shrt_code)::text = 'comcastAccountId'::text)
  • Rows Removed by Filter: 268
17. 0.028 0.028 ↑ 112.0 1 3 / 3

Index Scan using idx_prod_char_val_v02 on prod_char_val (cost=0.57..444.35 rows=112 width=26) (actual time=0.028..0.028 rows=1 loops=3)

  • Index Cond: ((char_id = gnl_char.char_id) AND ((val)::text = '4a52997d-cff2-4745-b6bb-1b57c7ed369d'::text))
18. 0.012 0.012 ↑ 1.0 1 3 / 3

Index Scan using gnl_st_pkey on gnl_st charvalstatus (cost=0.15..0.17 rows=1 width=5) (actual time=0.012..0.012 rows=1 loops=3)

  • Index Cond: (gnl_st_id = prod_char_val.st_id)
  • Filter: ((shrt_code)::text = ANY ('{ACTV,PNDG}'::text[]))
19. 0.012 0.012 ↑ 1.0 1 3 / 3

Index Only Scan using gnl_char_val_pkey on gnl_char_val (cost=0.15..0.17 rows=1 width=6) (actual time=0.012..0.012 rows=1 loops=3)

  • Index Cond: (char_val_id = prod_char_val.char_val_id)
  • Heap Fetches: 0
20. 0.009 0.009 ↑ 1.0 1 3 / 3

Index Scan using idx_gcvl_char_val_id on gnl_char_val_lang (cost=0.28..0.32 rows=1 width=9) (actual time=0.008..0.009 rows=1 loops=3)

  • Index Cond: (char_val_id = prod_char_val.char_val_id)
  • Filter: ((is_actv = '1'::numeric) AND ((lang)::text = 'en'::text))
  • Rows Removed by Filter: 1
21. 0.013 0.013 ↑ 1.0 1 3 / 3

Index Scan using pk_prod on prod (cost=0.43..7.29 rows=1 width=13) (actual time=0.013..0.013 rows=1 loops=3)

  • Index Cond: (prod_id = prod_char_val.prod_id)
22. 0.006 0.006 ↑ 1.0 1 3 / 3

Index Scan using gnl_st_pkey on gnl_st prodstatus (cost=0.15..0.17 rows=1 width=5) (actual time=0.006..0.006 rows=1 loops=3)

  • Index Cond: (gnl_st_id = prod.st_id)
  • Filter: ((shrt_code)::text = ANY ('{ACTV,PNDG,SPND,CNCL}'::text[]))
23. 0.013 0.013 ↑ 1.0 1 3 / 3

Index Only Scan using idx_gnl_char_lang_char_id_lang_is_actv on gnl_char_lang (cost=0.28..0.30 rows=1 width=9) (actual time=0.013..0.013 rows=1 loops=3)

  • Index Cond: ((char_id = prod_char_val.char_id) AND (lang = 'en'::text) AND (is_actv = '1'::numeric))
  • Heap Fetches: 0
Planning time : 9.446 ms
Execution time : 1,944.475 ms