explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UKxg : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 5.872 ↑ 1.0 100 1

Limit (cost=5.95..182.25 rows=100 width=68) (actual time=5.837..5.872 rows=100 loops=1)

2. 0.105 5.864 ↑ 2.1 100 1

Bitmap Heap Scan on uzgps_routing_route_station_event (cost=5.95..383.23 rows=214 width=68) (actual time=5.837..5.864 rows=100 loops=1)

  • Recheck Cond: (status = 'A'::bpchar)
  • Heap Blocks: exact=2
3. 5.759 5.759 ↓ 199.3 42,645 1

Bitmap Index Scan on uzgps_routing_route_station_event_status_idx (cost=0.00..5.90 rows=214 width=0) (actual time=5.759..5.759 rows=42,645 loops=1)

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