explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4HYy

Settings
# exclusive inclusive rows x rows loops node
1. 19.119 174.385 ↓ 85.9 40,134 1

Hash Join (cost=11,299.20..18,541.69 rows=467 width=316) (actual time=55.267..174.385 rows=40,134 loops=1)

  • Hash Cond: (sm001000_pi2_projet_infrastructurebase.sm001000_pi_ni_orgn_reqr = accountbase.accountid)
2. 19.403 100.184 ↓ 86.3 40,134 1

Hash Left Join (cost=13.54..7,244.94 rows=465 width=256) (actual time=0.175..100.184 rows=40,134 loops=1)

  • Hash Cond: (sm001000_pi1_voletbase.sm001000_pi1_voletid = sm001000_pi1_sous_voletbase.sm001000_pi1_voletid)
  • Filter: ((sm001000_pi2_projet_infrastructurebase.sm001000_pi1_sous_voletid = sm001000_pi1_sous_voletbase.sm001000_pi1_sous_voletid) OR (sm001000_pi2_projet_infrastructurebase.sm001000_pi1_sous_voletid IS NULL))
  • Rows Removed by Filter: 39995
3. 71.882 80.716 ↓ 23.0 40,134 1

Hash Join (cost=6.46..7,209.51 rows=1,745 width=224) (actual time=0.105..80.716 rows=40,134 loops=1)

  • Hash Cond: (sm001000_pi2_projet_infrastructurebase.sm001000_pi1_programmeid = sm001000_pi1_programmebase.sm001000_pi1_programmeid)
  • Join Filter: ((sm001000_pi2_projet_infrastructurebase.sm001000_pi1_voletid = sm001000_pi1_voletbase.sm001000_pi1_voletid) OR (sm001000_pi2_projet_infrastructurebase.sm001000_pi1_voletid IS NULL))
  • Rows Removed by Join Filter: 79628
4. 8.745 8.745 ↑ 1.0 40,134 1

Seq Scan on sm001000_pi2_projet_infrastructurebase (cost=0.00..6,195.34 rows=40,134 width=508) (actual time=0.008..8.745 rows=40,134 loops=1)

5. 0.009 0.089 ↓ 1.1 40 1

Hash (cost=6.00..6.00 rows=37 width=132) (actual time=0.089..0.089 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
6. 0.037 0.080 ↓ 1.1 40 1

Hash Right Join (cost=2.52..6.00 rows=37 width=132) (actual time=0.043..0.080 rows=40 loops=1)

  • Hash Cond: (sm001000_pi1_voletbase.sm001000_pi1_programmeid = sm001000_pi1_programmebase.sm001000_pi1_programmeid)
7. 0.008 0.008 ↑ 1.0 37 1

Seq Scan on sm001000_pi1_voletbase (cost=0.00..3.37 rows=37 width=240) (actual time=0.003..0.008 rows=37 loops=1)

8. 0.010 0.035 ↑ 1.0 23 1

Hash (cost=2.23..2.23 rows=23 width=292) (actual time=0.035..0.035 rows=23 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
9. 0.025 0.025 ↑ 1.0 23 1

Seq Scan on sm001000_pi1_programmebase (cost=0.00..2.23 rows=23 width=292) (actual time=0.006..0.025 rows=23 loops=1)

10. 0.014 0.065 ↑ 1.0 48 1

Hash (cost=6.48..6.48 rows=48 width=240) (actual time=0.065..0.065 rows=48 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
11. 0.051 0.051 ↑ 1.0 48 1

Seq Scan on sm001000_pi1_sous_voletbase (cost=0.00..6.48 rows=48 width=240) (actual time=0.004..0.051 rows=48 loops=1)

12. 0.795 55.082 ↑ 1.0 3,936 1

Hash (cost=11,236.24..11,236.24 rows=3,954 width=39) (actual time=55.082..55.082 rows=3,936 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 307kB
13. 7.978 54.287 ↑ 1.0 3,936 1

Hash Right Join (cost=5,792.61..11,236.24 rows=3,954 width=39) (actual time=31.655..54.287 rows=3,936 loops=1)

  • Hash Cond: (xxaddress2.parentid = accountbase.accountid)
14. 14.678 14.678 ↓ 1.0 67,404 1

Seq Scan on customeraddressbase xxaddress2 (cost=0.00..5,154.10 rows=66,802 width=16) (actual time=0.006..14.678 rows=67,404 loops=1)

  • Filter: (addressnumber = 2)
  • Rows Removed by Filter: 67404
15. 0.700 31.631 ↑ 1.0 3,936 1

Hash (cost=5,743.19..5,743.19 rows=3,954 width=39) (actual time=31.631..31.631 rows=3,936 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 307kB
16. 7.968 30.931 ↑ 1.0 3,936 1

Hash Right Join (cost=410.56..5,743.19 rows=3,954 width=39) (actual time=4.659..30.931 rows=3,936 loops=1)

  • Hash Cond: (xxaddress1.parentid = accountbase.accountid)
17. 18.319 18.319 ↑ 1.0 67,404 1

Seq Scan on customeraddressbase xxaddress1 (cost=0.00..5,154.10 rows=68,006 width=16) (actual time=0.005..18.319 rows=67,404 loops=1)

  • Filter: (addressnumber = 1)
  • Rows Removed by Filter: 67404
18. 1.258 4.644 ↑ 1.0 3,936 1

Hash (cost=361.36..361.36 rows=3,936 width=583) (actual time=4.644..4.644 rows=3,936 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 962kB
19. 3.386 3.386 ↑ 1.0 3,936 1

Seq Scan on accountbase (cost=0.00..361.36 rows=3,936 width=583) (actual time=0.006..3.386 rows=3,936 loops=1)

Planning time : 57.218 ms