explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qVKi : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 1,207.002 ↑ 2.6 89 1

vLimit (cost=5,664,111.99..5,664,114.93 rows=235 width=28) (actual time=1,206.968..1,207.002 rows=89 loops=1)

2. 0.024 1,206.993 ↑ 2.6 89 1

Unique (cost=5,664,111.99..5,664,114.93 rows=235 width=28) (actual time=1,206.965..1,206.993 rows=89 loops=1)

3. 0.084 1,206.969 ↑ 2.6 89 1

Sort (cost=5,664,111.99..5,664,112.58 rows=235 width=28) (actual time=1,206.964..1,206.969 rows=89 loops=1)

  • Sort Key: t.mobject_id, t.trip_pass_status, (count(trs.is_konechka)), (count(((NOT trs.is_konechka) OR (trs.is_konechka IS NULL))))
  • Sort Method: quicksort Memory: 31kB
4. 0.090 1,206.885 ↑ 2.6 89 1

GroupAggregate (cost=5,664,097.45..5,664,102.73 rows=235 width=28) (actual time=1,206.842..1,206.885 rows=89 loops=1)

  • Group Key: t.mobject_id, t.trip_pass_status
5. 0.161 1,206.795 ↑ 1.9 123 1

Sort (cost=5,664,097.45..5,664,098.03 rows=235 width=13) (actual time=1,206.788..1,206.795 rows=123 loops=1)

  • Sort Key: t.mobject_id, t.trip_pass_status
  • Sort Method: quicksort Memory: 30kB
6. 3.058 1,206.634 ↑ 1.9 123 1

Nested Loop (cost=1.64..5,664,088.19 rows=235 width=13) (actual time=67.097..1,206.634 rows=123 loops=1)

7. 912.450 912.450 ↑ 3.5 4,411 1

Index Scan using uzgps_routing_trip_mobject_id_time_start_time_end_status_idx on uzgps_routing_trip t (cost=1.07..237,650.58 rows=15,372 width=20) (actual time=2.147..912.450 rows=4,411 loops=1)

  • Index Cond: ((time_start > trip_routing_uzb.timetomillisecond((date_trunc('day'::text, now()) + '03:00:00'::interval))) AND (time_end < trip_routing_uzb.timetomillisecond((date_trunc('day'::text, now()) + '23:00:00'::interval))))
  • Filter: (status = 'A'::bpchar)
  • Rows Removed by Filter: 1382
8. 291.126 291.126 ↓ 0.0 0 4,411

Index Scan using uzgps_routing_trip_route_station_trip_id_idx on uzgps_routing_trip_route_station trs (cost=0.56..352.98 rows=3 width=9) (actual time=0.065..0.066 rows=0 loops=4,411)

  • Index Cond: (trip_id = t.id)
  • Filter: ((time_period_parking_exceed > 0) AND (status = 'A'::bpchar))
  • Rows Removed by Filter: 34