explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B2gO

Settings
# exclusive inclusive rows x rows loops node
1. 20.799 73.349 ↑ 6.3 28,890 1

Hash Join (cost=4,707.37..14,259.93 rows=182,376 width=156) (actual time=47.963..73.349 rows=28,890 loops=1)

  • Hash Cond: (crm_progtrav.sm001000_pi2_programmation_travauxid = progtrav.sm001000_pi2_programmation_travauxid_actv)
2. 4.685 4.685 ↓ 1.0 34,063 1

Seq Scan on crm_progtrav (cost=0.00..1,035.14 rows=32,614 width=16) (actual time=0.006..4.685 rows=34,063 loops=1)

3. 15.700 47.865 ↑ 1.2 28,890 1

Hash (cost=3,649.61..3,649.61 rows=34,061 width=124) (actual time=47.865..47.865 rows=28,890 loops=1)

  • Buckets: 32768 Batches: 2 Memory Usage: 2611kB
4. 32.165 32.165 ↓ 1.0 34,063 1

Seq Scan on sm001000_pi2_programmation_travauxbase progtrav (cost=0.00..3,649.61 rows=34,061 width=124) (actual time=0.006..32.165 rows=34,063 loops=1)

Planning time : 0.202 ms