explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jplv : wer

Settings
# exclusive inclusive rows x rows loops node
1. 0.763 79.793 ↓ 1.2 2,342 1

Unique (cost=17,150.30..17,164.97 rows=1,955 width=16) (actual time=78.674..79.793 rows=2,342 loops=1)

2. 1.497 79.030 ↓ 3.3 6,368 1

Sort (cost=17,150.30..17,155.19 rows=1,955 width=16) (actual time=78.673..79.030 rows=6,368 loops=1)

  • Sort Method: quicksort Memory: 491kB
  • Sort Key: urtt.mobject_id, urtt.route_id
3. 6.390 77.533 ↓ 3.3 6,368 1

Gather (cost=1,336.24..17,043.43 rows=1,955 width=16) (actual time=20.437..77.533 rows=6,368 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
4. 0.748 71.143 ↓ 2.5 1,592 4

Hash Join (cost=336.24..15,847.93 rows=631 width=16) (actual time=16.128..71.143 rows=1,592 loops=4)

  • Hash Cond: (urtt.mobject_id = um.id)
5. 67.760 67.760 ↓ 2.1 1,741 4

Parallel Seq Scan on uzgps_routing_trip_template urtt (cost=0.00..15,502.29 rows=827 width=16) (actual time=13.280..67.760 rows=1,741 loops=4)

6. 0.205 2.635 ↑ 1.0 1,178 4

Hash (cost=321.39..321.39 rows=1,188 width=16) (actual time=2.635..2.635 rows=1,178 loops=4)

  • Rows Removed by Filter: 126510
  • Filter: (((time_start)::double precision <= (date_part('epoch'::text, '2019-04-15 00:00:00+00'::timestamp with time zone) * '1000'::double precision)) AND ((time_start)::double precision >= ((date_part('epoch'::text, '2019-04-14 00:00:00+00'::timestamp with time zone) * '1000'::double precision) - '172800000'::double precision)))
  • Buckets: 2048 Batches: 1 Memory Usage: 72kB
7. 0.315 2.430 ↑ 1.0 1,178 4

Hash Join (cost=202.12..321.39 rows=1,188 width=16) (actual time=1.196..2.430 rows=1,178 loops=4)

  • Hash Cond: (ums.mobject_id = um.id)
8. 0.978 0.978 ↓ 1.0 1,484 4

Seq Scan on uzgps_mobject_settings ums (cost=0.00..115.37 rows=1,481 width=8) (actual time=0.039..0.978 rows=1,484 loops=4)

9. 0.194 1.137 ↑ 1.0 1,251 4

Hash (cost=186.49..186.49 rows=1,251 width=8) (actual time=1.137..1.137 rows=1,251 loops=4)

  • Rows Removed by Filter: 74
  • Filter: ((status = 'A'::bpchar) AND (mobject_state_id = 1))
  • Buckets: 2048 Batches: 1 Memory Usage: 65kB
10. 0.943 0.943 ↑ 1.0 1,251 4

Seq Scan on uzgps_mobject um (cost=0.00..186.49 rows=1,251 width=8) (actual time=0.019..0.943 rows=1,251 loops=4)

  • Rows Removed by Filter: 308
  • Filter: ((mo_status)::text = 'A'::text)
Planning time : 0.716 ms
Execution time : 81.288 ms