explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0TgE

Settings
# exclusive inclusive rows x rows loops node
1. 7,109.744 65,328.796 ↓ 22.1 375 1

Hash Join (cost=427.42..952,450.82 rows=17 width=80) (actual time=21,138.385..65,328.796 rows=375 loops=1)

  • Hash Cond: (prod_char_val.prod_id = prod.prod_id)
2. 17,082.672 58,218.367 ↓ 7.8 25,028,585 1

Hash Join (cost=298.42..940,276.50 rows=3,212,039 width=80) (actual time=4.975..58,218.367 rows=25,028,585 loops=1)

  • Hash Cond: (prod_char_val.char_val_id = gnl_char_val_lang.char_val_id)
3. 16,337.662 41,131.855 ↓ 7.2 24,619,569 1

Hash Join (cost=69.35..872,337.81 rows=3,435,362 width=57) (actual time=1.122..41,131.855 rows=24,619,569 loops=1)

  • Hash Cond: (prod_char_val.char_id = gnl_char_lang.char_id)
4. 18,566.273 24,793.194 ↓ 4.1 24,619,569 1

Hash Join (cost=12.80..774,248.38 rows=6,057,085 width=27) (actual time=0.115..24,793.194 rows=24,619,569 loops=1)

  • Hash Cond: (prod_char_val.st_id = gnl_st.gnl_st_id)
5. 6,226.812 6,226.812 ↓ 1.0 26,051,284 1

Seq Scan on prod_char_val (cost=0.00..616,613.71 rows=25,880,271 width=34) (actual time=0.001..6,226.812 rows=26,051,284 loops=1)

6. 0.035 0.109 ↑ 1.0 88 1

Hash (cost=11.70..11.70 rows=88 width=6) (actual time=0.109..0.109 rows=88 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
7. 0.074 0.074 ↑ 1.0 88 1

Seq Scan on gnl_st (cost=0.00..11.70 rows=88 width=6) (actual time=0.005..0.074 rows=88 loops=1)

  • Filter: ((shrt_code)::text = ANY ('{ACTV,PNDG}'::text[]))
  • Rows Removed by Filter: 288
8. 0.154 0.999 ↑ 1.0 304 1

Hash (cost=52.75..52.75 rows=304 width=40) (actual time=0.999..0.999 rows=304 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 31kB
9. 0.333 0.845 ↑ 1.0 304 1

Hash Join (cost=25.00..52.75 rows=304 width=40) (actual time=0.377..0.845 rows=304 loops=1)

  • Hash Cond: (gnl_char.char_id = gnl_char_lang.char_id)
10. 0.143 0.143 ↑ 1.0 536 1

Seq Scan on gnl_char (cost=0.00..21.36 rows=536 width=15) (actual time=0.001..0.143 rows=536 loops=1)

11. 0.112 0.369 ↑ 1.0 304 1

Hash (cost=21.20..21.20 rows=304 width=25) (actual time=0.369..0.369 rows=304 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
12. 0.257 0.257 ↑ 1.0 304 1

Seq Scan on gnl_char_lang (cost=0.00..21.20 rows=304 width=25) (actual time=0.006..0.257 rows=304 loops=1)

  • Filter: ((is_actv = '1'::numeric) AND ((lang)::text = 'en'::text))
  • Rows Removed by Filter: 443
13. 0.617 3.840 ↓ 1.0 1,353 1

Hash (cost=212.17..212.17 rows=1,352 width=36) (actual time=3.840..3.840 rows=1,353 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 109kB
14. 0.955 3.223 ↓ 1.0 1,353 1

Hash Join (cost=82.54..212.17 rows=1,352 width=36) (actual time=1.082..3.223 rows=1,353 loops=1)

  • Hash Cond: (gnl_char_val_lang.char_val_id = gnl_char_val.char_val_id)
15. 1.202 1.202 ↓ 1.0 1,353 1

Seq Scan on gnl_char_val_lang (cost=0.00..111.04 rows=1,352 width=17) (actual time=0.005..1.202 rows=1,353 loops=1)

  • Filter: ((is_actv = '1'::numeric) AND ((lang)::text = 'en'::text))
  • Rows Removed by Filter: 2,383
16. 0.546 1.066 ↑ 1.0 1,446 1

Hash (cost=64.46..64.46 rows=1,446 width=19) (actual time=1.066..1.066 rows=1,446 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 90kB
17. 0.520 0.520 ↑ 1.0 1,446 1

Seq Scan on gnl_char_val (cost=0.00..64.46 rows=1,446 width=19) (actual time=0.001..0.520 rows=1,446 loops=1)

18. 0.016 0.685 ↓ 1.9 48 1

Hash (cost=128.69..128.69 rows=25 width=6) (actual time=0.685..0.685 rows=48 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
19. 0.043 0.669 ↓ 1.9 48 1

Nested Loop (cost=123.93..128.69 rows=25 width=6) (actual time=0.590..0.669 rows=48 loops=1)

20. 0.018 0.594 ↓ 1.8 16 1

Merge Join (cost=123.65..123.90 rows=9 width=19) (actual time=0.579..0.594 rows=16 loops=1)

  • Merge Cond: (gnl_tp.gnl_tp_id = prod_ofr.prod_ofr_tp_id)
21. 0.015 0.015 ↑ 144.0 3 1

Index Only Scan using gnl_tp_pkey on gnl_tp (cost=0.27..22.75 rows=432 width=5) (actual time=0.014..0.015 rows=3 loops=1)

  • Heap Fetches: 0
22. 0.017 0.561 ↓ 1.8 16 1

Sort (cost=123.38..123.40 rows=9 width=24) (actual time=0.559..0.561 rows=16 loops=1)

  • Sort Key: prod_ofr.prod_ofr_tp_id
  • Sort Method: quicksort Memory: 26kB
23. 0.020 0.544 ↓ 1.8 16 1

Hash Join (cost=40.98..123.24 rows=9 width=24) (actual time=0.499..0.544 rows=16 loops=1)

  • Hash Cond: (prod.prod_ofr_id = prod_ofr.prod_ofr_id)
24. 0.028 0.228 ↓ 1.8 16 1

Hash Join (cost=15.44..97.57 rows=9 width=24) (actual time=0.193..0.228 rows=16 loops=1)

  • Hash Cond: (prod.st_id = gnl_st_1.gnl_st_id)
25. 0.030 0.030 ↑ 1.8 16 1

Index Scan using prod_bill_acct_id_idx on prod (cost=0.43..82.37 rows=29 width=25) (actual time=0.012..0.030 rows=16 loops=1)

  • Index Cond: (bill_acct_id = '80490221'::numeric)
26. 0.050 0.170 ↑ 1.0 114 1

Hash (cost=13.58..13.58 rows=114 width=6) (actual time=0.170..0.170 rows=114 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
27. 0.120 0.120 ↑ 1.0 114 1

Seq Scan on gnl_st gnl_st_1 (cost=0.00..13.58 rows=114 width=6) (actual time=0.006..0.120 rows=114 loops=1)

  • Filter: ((shrt_code)::text = ANY ('{PHANTOM,SPND,QUOTE,ACTV,PNDG,CNCL}'::text[]))
  • Rows Removed by Filter: 262
28. 0.163 0.296 ↑ 1.0 424 1

Hash (cost=20.24..20.24 rows=424 width=10) (actual time=0.296..0.296 rows=424 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 26kB
29. 0.133 0.133 ↑ 1.0 424 1

Seq Scan on prod_ofr (cost=0.00..20.24 rows=424 width=10) (actual time=0.002..0.133 rows=424 loops=1)

30. 0.032 0.032 ↑ 1.0 3 16

Index Only Scan using idx_gnl_st_lang_gnl_st_id on gnl_st_lang (cost=0.28..0.50 rows=3 width=5) (actual time=0.002..0.002 rows=3 loops=16)

  • Index Cond: (gnl_st_id = gnl_st_1.gnl_st_id)
  • Heap Fetches: 0
Planning time : 4.776 ms
Execution time : 65,329.011 ms