explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BY6u : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.417 0.489 ↓ 224.0 224 1

Bitmap Heap Scan on uzgps_routing_route rr (cost=4.16..10.82 rows=1 width=32) (actual time=0.089..0.489 rows=224 loops=1)

  • Recheck Cond: (status = 'A'::bpchar)
  • Filter: (id > 100)
  • Rows Removed by Filter: 98
  • Heap Blocks: exact=25
2. 0.072 0.072 ↓ 161.0 322 1

Bitmap Index Scan on uzgps_routing_route_status_idx (cost=0.00..4.16 rows=2 width=0) (actual time=0.072..0.072 rows=322 loops=1)

  • Index Cond: (status = 'A'::bpchar)