explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5izt : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 10.162 161.526 ↓ 0.0 0 1

HashAggregate (cost=31,885.06..32,080.13 rows=5,202 width=36) (actual time=161.526..161.526 rows=0 loops=1)

  • Group Key: mobject_id, route_id, trip_status, time_start
  • Filter: (count(*) > 1)
  • Rows Removed by Filter: 13834
2. 151.364 151.364 ↑ 1.1 13,834 1

Index Scan using uzgps_routing_trip_time_start_reg_date_index on uzgps_routing_trip (cost=0.43..31,646.68 rows=15,892 width=28) (actual time=126.751..151.364 rows=13,834 loops=1)

  • Index Cond: ((time_start IS NOT NULL) AND (reg_date > (now() - '1 day'::interval)))
  • Filter: (status = 'A'::bpchar)
  • Rows Removed by Filter: 6548