explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zC7V

Settings
# exclusive inclusive rows x rows loops node
1. 16,072.281 18,338.278 ↑ 1.0 56,337,768 1

Nested Loop (cost=0.00..706,113.56 rows=56,337,768 width=5,249) (actual time=0.019..18,338.278 rows=56,337,768 loops=1)

  • Buffers: shared hit=33
2. 46.612 59.557 ↑ 1.0 147,096 1

Nested Loop (cost=0.00..1,881.67 rows=147,096 width=5,192) (actual time=0.013..59.557 rows=147,096 loops=1)

  • Buffers: shared hit=28
3. 2.049 2.049 ↑ 1.0 1,362 1

Seq Scan on equipement a (cost=0.00..40.62 rows=1,362 width=5,149) (actual time=0.005..2.049 rows=1,362 loops=1)

  • Buffers: shared hit=27
4. 10.885 10.896 ↑ 1.0 108 1,362

Materialize (cost=0.00..2.62 rows=108 width=43) (actual time=0.000..0.008 rows=108 loops=1,362)

  • Buffers: shared hit=1
5. 0.011 0.011 ↑ 1.0 108 1

Seq Scan on ref_eqp_groupe (cost=0.00..2.08 rows=108 width=43) (actual time=0.003..0.011 rows=108 loops=1)

  • Buffers: shared hit=1
6. 2,206.395 2,206.440 ↑ 1.0 383 147,096

Materialize (cost=0.00..10.75 rows=383 width=57) (actual time=0.000..0.015 rows=383 loops=147,096)

  • Buffers: shared hit=5
7. 0.045 0.045 ↑ 1.0 383 1

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

  • Buffers: shared hit=5
Planning time : 0.353 ms
Execution time : 20,221.493 ms