explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 96p3 : sdfsdf

Settings
# exclusive inclusive rows x rows loops node
1. 11.724 167.567 ↓ 0.0 0 1

HashAggregate (cost=34,111.23..34,305.71 rows=5,186 width=36) (actual time=167.567..167.567 rows=0 loops=1)

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

Index Scan using uzgps_routing_trip_time_start_reg_date_status_index on uzgps_routing_trip (cost=0.43..33,873.58 rows=15,843 width=28) (actual time=139.822..155.843 rows=13,935 loops=1)

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