explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y9Q8

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=5,588.14..5,588.15 rows=1 width=0) (actual rows= loops=)

  • (actual time=21.522..21.522 rows=1 loops=1)
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on stock (cost=81.73..5,577.39 rows=4,298 width=0) (actual rows= loops=)

  • (actual time=10.932..17.579 rows=16839 loops=1)
  • Recheck Cond: (annee = 1994)
  • Heap Blocks: exact=110
  • -> Bitmap Index Scan on idx_stock_annee
  • (cost=0.00..80.66 rows=4298 width=0)
  • (actual time=10.845..10.845 rows=16839 loops=1)
  • Index Cond: (annee = 1994)