explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ibll

Settings
# exclusive inclusive rows x rows loops node
1. 0.457 24.230 ↑ 70.0 100 1

Bitmap Heap Scan on four tango (cost=70.740..7,692.290 rows=6,999 width=131) (actual time=23.828..24.230 rows=100 loops=1)

  • Recheck Cond: ((two)::text ~~ 'lima'::text)
  • Rows Removed by Index Recheck: 130
  • Heap Blocks: exact=228
2. 23.773 23.773 ↑ 30.4 230 1

Bitmap Index Scan on echo (cost=0.000..68.990 rows=6,999 width=0) (actual time=23.773..23.773 rows=230 loops=1)

  • Index Cond: ((two)::text ~~ 'lima'::text)
Planning time : 0.294 ms
Execution time : 24.275 ms