explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ndk3

Settings
# exclusive inclusive rows x rows loops node
1. 0.504 1.736 ↑ 1.0 3 1

Hash Join (cost=13.62..87.38 rows=3 width=5,206) (actual time=0.511..1.736 rows=3 loops=1)

  • Hash Cond: (a.fk_pmv_bibliotheque_id = b.id)
  • Buffers: shared hit=63
2. 0.842 0.842 ↑ 1.0 1,362 1

Seq Scan on equipement a (cost=0.00..68.62 rows=1,362 width=5,149) (actual time=0.031..0.842 rows=1,362 loops=1)

  • Buffers: shared hit=55
3. 0.211 0.390 ↑ 1.0 383 1

Hash (cost=8.83..8.83 rows=383 width=57) (actual time=0.390..0.390 rows=383 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
  • Buffers: shared hit=5
4. 0.179 0.179 ↑ 1.0 383 1

Seq Scan on pmv_bibliotheque b (cost=0.00..8.83 rows=383 width=57) (actual time=0.039..0.179 rows=383 loops=1)

  • Buffers: shared hit=5
Planning time : 3.530 ms
Execution time : 2.089 ms