explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qAgF : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 0.696 79.255 ↓ 1.2 2,377 1

Unique (cost=17,284.66..17,299.43 rows=1,970 width=16) (actual time=78.230..79.255 rows=2,377 loops=1)

2. 0.304 78.559 ↓ 3.3 6,440 1

Sort (cost=17,284.66..17,289.58 rows=1,970 width=16) (actual time=78.229..78.559 rows=6,440 loops=1)

  • Sort Key: urtt.mobject_id, urtt.route_id
  • Sort Method: quicksort Memory: 494kB
3. 6.831 78.255 ↓ 3.3 6,440 1

Gather (cost=1,336.26..17,176.86 rows=1,970 width=16) (actual time=19.448..78.255 rows=6,440 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
4. 0.628 71.424 ↓ 2.5 1,610 4

Hash Join (cost=336.26..15,979.86 rows=635 width=16) (actual time=15.076..71.424 rows=1,610 loops=4)

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

Parallel Seq Scan on uzgps_routing_trip_template urtt (cost=0.00..15,634.11 rows=835 width=16) (actual time=12.413..68.288 rows=1,767 loops=4)

  • Filter: (((time_start)::double precision <= (date_part('epoch'::text, '2019-04-16 00:00:00+00'::timestamp with time zone) * '1000'::double precision)) AND ((time_start)::double precision >= ((date_part('epoch'::text, '2019-04-15 00:00:00+00'::timestamp with time zone) * '1000'::double precision) - '172800000'::double precision)))
  • Rows Removed by Filter: 126636
6. 0.185 2.508 ↑ 1.0 1,174 4

Hash (cost=321.41..321.41 rows=1,188 width=16) (actual time=2.507..2.508 rows=1,174 loops=4)

  • Buckets: 2048 Batches: 1 Memory Usage: 72kB
7. 0.290 2.323 ↑ 1.0 1,174 4

Hash Join (cost=202.14..321.41 rows=1,188 width=16) (actual time=1.151..2.323 rows=1,174 loops=4)

  • Hash Cond: (ums.mobject_id = um.id)
8. 0.934 0.934 ↑ 1.0 1,481 4

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

  • Filter: ((status = 'A'::bpchar) AND (mobject_state_id = 1))
  • Rows Removed by Filter: 78
9. 0.176 1.099 ↑ 1.0 1,251 4

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

  • Buckets: 2048 Batches: 1 Memory Usage: 65kB
10. 0.923 0.923 ↑ 1.0 1,251 4

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

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