explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3c6d

Settings
# exclusive inclusive rows x rows loops node
1. 25.912 50.915 ↑ 1.0 1 1

Aggregate (cost=44,687.92..44,687.94 rows=1 width=16) (actual time=50.915..50.915 rows=1 loops=1)

2. 4.275 25.003 ↑ 1.7 27,334 1

Nested Loop (cost=1.14..43,624.73 rows=47,253 width=99) (actual time=0.044..25.003 rows=27,334 loops=1)

3. 0.021 0.021 ↑ 1.0 1 1

Index Scan using device_session_pkey on device_session ds (cost=0.43..2.65 rows=1 width=26) (actual time=0.020..0.021 rows=1 loops=1)

  • Index Cond: (id = '930b5ec2-2b47-4014-b1ce-f65c06dcee8c'::uuid)
4. 20.707 20.707 ↑ 1.9 27,334 1

Index Scan using idx_tep_device_id_location_date_tz on traccar_event_point (cost=0.71..43,111.77 rows=51,031 width=99) (actual time=0.021..20.707 rows=27,334 loops=1)

  • Index Cond: ((device_instance_id = ds.device_instance_id) AND (timezone('Europe/Paris'::text, location_date) >= lower(ds.date_range)) AND (timezone('Europe/Paris'::text, location_date) <= upper(ds.date_range)))
Planning time : 0.665 ms
Execution time : 51.002 ms