explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CC88 : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.771 75.399 ↓ 1.2 2,342 1

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

2. 1.076 74.628 ↓ 3.3 6,368 1

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

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

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

  • Workers Planned: 3
  • Workers Launched: 3
4. 0.608 65.520 ↓ 2.5 1,592 4

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

  • Hash Cond: (urtt.mobject_id = um.id)
5. 62.267 62.267 ↓ 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=12.550..62.267 rows=1,741 loops=4)

6. 0.205 2.645 ↑ 1.0 1,178 4

Hash (cost=321.39..321.39 rows=1,188 width=16) (actual time=2.645..2.645 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.290 2.440 ↑ 1.0 1,178 4

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

  • Hash Cond: (ums.mobject_id = um.id)
8. 0.981 0.981 ↓ 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.023..0.981 rows=1,484 loops=4)

9. 0.193 1.169 ↑ 1.0 1,251 4

Hash (cost=186.49..186.49 rows=1,251 width=8) (actual time=1.169..1.169 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.976 0.976 ↑ 1.0 1,251 4

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

  • Rows Removed by Filter: 308
  • Filter: ((mo_status)::text = 'A'::text)