explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T3fJ

Settings
# exclusive inclusive rows x rows loops node
1. 18.758 177.406 ↓ 85.9 40,134 1

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

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

Hash Left Join (cost=13.54..7,244.94 rows=465 width=256) (actual time=0.213..99.382 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. 69.240 80.120 ↓ 23.0 40,134 1

Hash Join (cost=6.46..7,209.51 rows=1,745 width=224) (actual time=0.126..80.120 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. 10.770 10.770 ↑ 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.007..10.770 rows=40,134 loops=1)

5. 0.010 0.110 ↓ 1.1 40 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
6. 0.048 0.100 ↓ 1.1 40 1

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

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

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

8. 0.011 0.038 ↑ 1.0 23 1

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

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

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

10. 0.017 0.081 ↑ 1.0 48 1

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

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

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

12. 0.799 59.266 ↑ 1.0 3,936 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Planning time : 63.876 ms