explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AS3H

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 0.151 ↑ 1.0 1 1

Aggregate (cost=14.48..14.49 rows=1 width=8) (actual time=0.150..0.151 rows=1 loops=1)

2. 0.061 0.120 ↑ 1.0 97 1

Bitmap Heap Scan on seats (cost=5.03..14.24 rows=97 width=0) (actual time=0.086..0.120 rows=97 loops=1)

  • Recheck Cond: (aircraft_code = 'SU9'::bpchar)
  • Heap Blocks: exact=2
3. 0.059 0.059 ↑ 1.0 97 1

Bitmap Index Scan on seats_pkey (cost=0.00..5.00 rows=97 width=0) (actual time=0.059..0.059 rows=97 loops=1)

  • Index Cond: (aircraft_code = 'SU9'::bpchar)
Planning time : 0.227 ms
Execution time : 0.239 ms