explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iUOk

Settings
# exclusive inclusive rows x rows loops node
1. 0.248 0.341 ↓ 0.0 0 1

Bitmap Heap Scan on customer (cost=4.32..22.02 rows=5 width=779) (actual time=0.333..0.341 rows=0 loops=1)

  • Recheck Cond: (lastname = 'Mustermann'::text)
2. 0.093 0.093 ↓ 0.0 0 1

Bitmap Index Scan on customer_lastname_idx (cost=0.00..4.32 rows=5 width=0) (actual time=0.086..0.093 rows=0 loops=1)

  • Index Cond: (lastname = 'Mustermann'::text)
Planning time : 2.639 ms
Execution time : 0.722 ms