explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QZy

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

Aggregate (cost=15,125.85..15,125.86 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on users (cost=2,000.98..15,075.34 rows=20,202 width=0) (actual rows= loops=)

  • Recheck Cond: (first_name ~~* '%aeb%'::text)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_3 (cost=0.00..1,995.92 rows=20,202 width=0) (actual rows= loops=)

  • Index Cond: (first_name ~~* '%aeb%'::text)