explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gPXL : PRO

Settings
# exclusive inclusive rows x rows loops node
1. 818.354 76,962.134 ↓ 201.8 1,405,368 1

Hash Join (cost=260,357.34..409,903.88 rows=6,963 width=128) (actual time=67,547.911..76,962.134 rows=1,405,368 loops=1)

  • Hash Cond: (((loc.emcdpo)::text = (zones.zpcdpo)::text) AND ((prpzone_locs.z6czpr)::text = (zones.zpczpr)::text))
2. 6,484.335 76,143.670 ↓ 190.3 1,405,368 1

Hash Join (cost=260,352.59..409,787.07 rows=7,384 width=138) (actual time=67,547.745..76,143.670 rows=1,405,368 loops=1)

  • Hash Cond: (((prpzone_locs.z6cdpo)::text = (loc.emcdpo)::text) AND (prpzone_locs.z6nemp = loc.emnemp))
3. 2,115.542 2,115.542 ↓ 1.0 4,593,448 1

Seq Scan on hlzpemp prpzone_locs (cost=0.00..114,980.18 rows=4,584,062 width=15) (actual time=0.364..2,115.542 rows=4,593,448 loops=1)

  • Filter: ((z6czpr)::text ~~ 'P%'::text)
  • Rows Removed by Filter: 32151
4. 3,820.851 67,543.793 ↓ 191.5 1,454,698 1

Hash (cost=260,238.62..260,238.62 rows=7,598 width=141) (actual time=67,543.793..67,543.793 rows=1,454,698 loops=1)

  • Buckets: 32768 (originally 8192) Batches: 256 (originally 1) Memory Usage: 3841kB
5. 1,490.642 63,722.942 ↓ 191.5 1,454,698 1

Gather (cost=125,290.05..260,238.62 rows=7,598 width=141) (actual time=20,043.716..63,722.942 rows=1,454,698 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 10,087.075 62,232.300 ↓ 153.2 484,899 3

Nested Loop (cost=124,290.05..258,478.82 rows=3,166 width=141) (actual time=19,888.246..62,232.300 rows=484,899 loops=3)

7. 13,181.817 52,145.206 ↓ 153.6 484,993 3

Nested Loop (cost=124,289.62..256,568.29 rows=3,157 width=158) (actual time=19,888.185..52,145.206 rows=484,993 loops=3)

8. 11,192.820 38,963.363 ↓ 152.3 486,123 3

Nested Loop (cost=124,289.19..252,708.17 rows=3,192 width=136) (actual time=19,888.110..38,963.363 rows=486,123 loops=3)

9. 5,779.892 27,770.522 ↓ 152.3 486,133 3

Hash Join (cost=124,288.64..250,022.39 rows=3,192 width=149) (actual time=19,887.986..27,770.522 rows=486,133 loops=3)

  • Hash Cond: ((ipg.gecart)::text = (item.arcart)::text)
10. 2,104.756 2,104.756 ↑ 1.2 486,133 3

Parallel Seq Scan on hlgeinp ipg (cost=0.00..123,427.29 rows=606,544 width=122) (actual time=0.077..2,104.756 rows=486,133 loops=3)

  • Filter: (((gecact)::text = 'BOL'::text) AND ((gecprp)::text = 'BOL'::text) AND ((gecdpo)::text = 'BFC'::text) AND ((gecqal)::text = 'AVL'::text) AND ((getgbl)::text = '0'::text) AND ((gectst)::text = '200'::text))
  • Rows Removed by Filter: 13274
11. 1,693.863 19,885.874 ↓ 182.7 2,136,582 3

Hash (cost=124,142.46..124,142.46 rows=11,694 width=40) (actual time=19,885.874..19,885.874 rows=2,136,582 loops=3)

  • Buckets: 65536 (originally 16384) Batches: 64 (originally 1) Memory Usage: 3585kB
12. 16,808.823 18,192.011 ↓ 182.7 2,136,582 3

Nested Loop (cost=0.14..124,142.46 rows=11,694 width=40) (actual time=0.077..18,192.011 rows=2,136,582 loops=3)

  • Join Filter: ((item.arcfpm)::text = (expiry_group.pmcfpm)::text)
  • Rows Removed by Join Filter: 12819492
13. 0.080 0.080 ↓ 7.0 7 3

Index Scan using hlfapmp_pkey on hlfapmp expiry_group (cost=0.14..8.16 rows=1 width=21) (actual time=0.046..0.080 rows=7 loops=3)

  • Index Cond: ((pmcact)::text = 'BOL'::text)
14. 1,383.108 1,383.108 ↑ 1.0 2,136,582 21

Seq Scan on hlartip item (cost=0.00..96,362.15 rows=2,221,772 width=37) (actual time=0.009..1,383.108 rows=2,136,582 loops=21)

  • Filter: ((arcact)::text = 'BOL'::text)
15. 0.021 0.021 ↑ 1.0 1 1,458,398

Index Scan using hlsuppp_pkey on hlsuppp hd (cost=0.55..0.84 rows=1 width=33) (actual time=0.021..0.021 rows=1 loops=1,458,398)

  • Index Cond: (((sucact)::text = 'BOL'::text) AND ((sunsup)::text = (ipg.gensup)::text))
16. 0.026 0.026 ↑ 1.0 1 1,458,368

Index Scan using hlemplp_pkey on hlemplp loc (cost=0.43..1.21 rows=1 width=22) (actual time=0.026..0.026 rows=1 loops=1,458,368)

  • Index Cond: (((emcdpo)::text = (hd.sucdpo)::text) AND (emnemp = hd.sunemp))
  • Filter: ((emtebs)::text = '0'::text)
  • Rows Removed by Filter: 0
17. 0.019 0.019 ↑ 1.0 1 1,454,980

Index Scan using boglitp_pkey on boglitp (cost=0.43..0.61 rows=1 width=22) (actual time=0.019..0.019 rows=1 loops=1,454,980)

  • Index Cond: (((gicact)::text = 'BOL'::text) AND ((giglobid)::text = (item.armrqa)::text))
18. 0.028 0.110 ↓ 1.1 105 1

Hash (cost=3.25..3.25 rows=100 width=9) (actual time=0.110..0.110 rows=105 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
19. 0.082 0.082 ↓ 1.1 105 1

Seq Scan on hlzprpp zones (cost=0.00..3.25 rows=100 width=9) (actual time=0.045..0.082 rows=105 loops=1)

  • Filter: ((zptopd)::text = '0'::text)