explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cGP4

Settings
# exclusive inclusive rows x rows loops node
1. 400.510 7,184.252 ↑ 1.0 1,659,176 1

Hash Join (cost=28,438.69..155,070.75 rows=1,659,212 width=50) (actual time=1,202.028..7,184.252 rows=1,659,176 loops=1)

  • Hash Cond: (tp.sm001000_pi1_priorite_travailid = prirtrav.sm001000_pi1_priorite_travailid)
2. 378.141 6,783.731 ↑ 1.0 1,659,176 1

Hash Join (cost=28,437.42..149,175.82 rows=1,659,212 width=62) (actual time=1,202.010..6,783.731 rows=1,659,176 loops=1)

  • Hash Cond: (tp.sm001000_pi9_responsableid = r.sm001000_pi9_responsableid)
3. 1,769.971 6,405.587 ↑ 1.0 1,659,212 1

Hash Join (cost=28,436.37..135,589.98 rows=1,659,212 width=75) (actual time=1,202.001..6,405.587 rows=1,659,212 loops=1)

  • Hash Cond: (catp.sm001000_pi4_travail_prioritaireid = tp.sm001000_pi4_travail_prioritaireid)
4. 3,437.268 3,437.268 ↑ 1.0 1,659,212 1

Seq Scan on sm001000_pi4_cout_aa_travail_prirbase catp (cost=0.00..70,328.12 rows=1,659,212 width=43) (actual time=0.012..3,437.268 rows=1,659,212 loops=1)

5. 140.736 1,198.348 ↑ 1.0 307,572 1

Hash (cost=21,287.72..21,287.72 rows=307,572 width=64) (actual time=1,198.348..1,198.348 rows=307,572 loops=1)

  • Buckets: 65536 Batches: 16 Memory Usage: 2322kB
6. 1,057.612 1,057.612 ↑ 1.0 307,572 1

Seq Scan on sm001000_pi4_travail_prioritairebase tp (cost=0.00..21,287.72 rows=307,572 width=64) (actual time=0.008..1,057.612 rows=307,572 loops=1)

7. 0.001 0.003 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=19) (actual time=0.003..0.003 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.002 0.002 ↑ 1.0 2 1

Seq Scan on sm001000_pi9_responsablebase r (cost=0.00..1.02 rows=2 width=19) (actual time=0.002..0.002 rows=2 loops=1)

9. 0.003 0.011 ↑ 1.0 12 1

Hash (cost=1.12..1.12 rows=12 width=20) (actual time=0.011..0.011 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.008 0.008 ↑ 1.0 12 1

Seq Scan on sm001000_pi1_priorite_travailbase prirtrav (cost=0.00..1.12 rows=12 width=20) (actual time=0.005..0.008 rows=12 loops=1)

Planning time : 0.467 ms