explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VOzso

Settings
# exclusive inclusive rows x rows loops node
1. 2.812 10.954 ↑ 1.0 1 1

Aggregate (cost=371.75..371.76 rows=1 width=8) (actual time=10.953..10.954 rows=1 loops=1)

  • Planning time: 0.398 ms
  • Execution time: 11.053 ms
2. 3.281 8.142 ↑ 1.0 18,183 1

Append (cost=0.00..326.29 rows=18,184 width=0) (actual time=0.026..8.142 rows=18,183 loops=1)

3. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on stock (cost=0.00..0.00 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (annee = 2004)
4. 4.857 4.857 ↑ 1.0 18,183 1

Seq Scan on stock_2004 (cost=0.00..326.29 rows=18,183 width=0) (actual time=0.020..4.857 rows=18,183 loops=1)

  • Filter: (annee = 2004)