explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gtK0 : asdasd

Settings
# exclusive inclusive rows x rows loops node
1. 2.901 766.955 ↓ 0.0 0 1

vGroupAggregate (cost=338,810.98..339,301.63 rows=5,394 width=36) (actual time=766.955..766.955 rows=0 loops=1)

  • Group Key: mobject_id, route_id, trip_status, time_start
  • Filter: (count(*) > 1)
  • Rows Removed by Filter: 13827
2. 8.297 764.054 ↑ 1.2 13,827 1

Sort (cost=338,810.98..338,852.17 rows=16,479 width=28) (actual time=763.403..764.054 rows=13,827 loops=1)

  • Sort Key: mobject_id, route_id, trip_status, time_start
  • Sort Method: quicksort Memory: 1465kB
3. 755.757 755.757 ↑ 1.2 13,827 1

Seq Scan on uzgps_routing_trip (cost=0.00..337,656.76 rows=16,479 width=28) (actual time=0.011..755.757 rows=13,827 loops=1)

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