explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FEOt

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

Bitmap Heap Scan on authors (cost=7,503.85..21,896.36 rows=304,441 width=19) (actual rows= loops=)

  • Recheck Cond: ((name)::text < 'David J. DeWitt'::text)
2. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_auth_name (cost=0.00..7,427.73 rows=304,441 width=0) (actual rows= loops=)

  • Index Cond: ((name)::text < 'David J. DeWitt'::text)