explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pNYc

Settings
# exclusive inclusive rows x rows loops node
1. 18.286 169.720 ↓ 85.9 40,134 1

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

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

Hash Left Join (cost=13.54..7,244.94 rows=465 width=256) (actual time=0.206..95.844 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. 68.553 77.229 ↓ 23.0 40,134 1

Hash Join (cost=6.46..7,209.51 rows=1,745 width=224) (actual time=0.137..77.229 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.556 8.556 ↑ 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.556 rows=40,134 loops=1)

5. 0.009 0.120 ↓ 1.1 40 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
6. 0.038 0.111 ↓ 1.1 40 1

Hash Right Join (cost=2.52..6.00 rows=37 width=132) (actual time=0.074..0.111 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.011 0.065 ↑ 1.0 23 1

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

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

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

10. 0.014 0.063 ↑ 1.0 48 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
11. 0.049 0.049 ↑ 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.049 rows=48 loops=1)

12. 0.811 55.590 ↑ 1.0 3,936 1

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

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

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

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

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

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

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

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

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

  • Hash Cond: (xxaddress1.parentid = accountbase.accountid)
17. 18.139 18.139 ↑ 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..18.139 rows=67,404 loops=1)

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

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

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

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

Planning time : 56.796 ms