explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kOEE

Settings
# exclusive inclusive rows x rows loops node
1. 117.317 138.029 ↑ 1.0 521,646 1

Nested Loop (cost=0.00..6,598.98 rows=521,646 width=5,149) (actual time=0.035..138.029 rows=521,646 loops=1)

  • Buffers: shared hit=60
2. 0.282 0.282 ↑ 1.0 1,362 1

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

  • Buffers: shared hit=55
3. 20.351 20.430 ↑ 1.0 383 1,362

Materialize (cost=0.00..10.75 rows=383 width=0) (actual time=0.000..0.015 rows=383 loops=1,362)

  • Buffers: shared hit=5
4. 0.079 0.079 ↑ 1.0 383 1

Seq Scan on pmv_bibliotheque b (cost=0.00..8.83 rows=383 width=0) (actual time=0.007..0.079 rows=383 loops=1)

  • Buffers: shared hit=5
Planning time : 0.376 ms
Execution time : 155.900 ms