explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 65K

Settings
# exclusive inclusive rows x rows loops node
1. 7.959 21,075.813 ↑ 140.6 14 1

Nested Loop (cost=244.09..1,066.68 rows=1,969 width=505) (actual time=4,362.004..21,075.813 rows=14 loops=1)

2.          

CTE track_table

3. 15.403 22.724 ↑ 1.0 1 1

Aggregate (cost=243.66..243.68 rows=1 width=32) (actual time=22.724..22.724 rows=1 loops=1)

4. 5.093 7.321 ↓ 99.8 26,457 1

Bitmap Heap Scan on calculations_gps (cost=3.44..243.00 rows=265 width=40) (actual time=2.344..7.321 rows=26,457 loops=1)

  • Recheck Cond: (traccar_session_id = 589541)
  • Heap Blocks: exact=756
5. 2.228 2.228 ↓ 192.5 51,013 1

Bitmap Index Scan on calculations_gps_traccar_session_id_idx (cost=0.00..3.38 rows=265 width=0) (actual time=2.228..2.228 rows=51,013 loops=1)

  • Index Cond: (traccar_session_id = 589541)
6. 22.920 22.920 ↑ 1.0 1 1

CTE Scan on track_table (cost=0.00..0.02 rows=1 width=32) (actual time=22.917..22.920 rows=1 loops=1)

7. 21,044.934 21,044.934 ↑ 14.1 14 1

Index Scan using idx_parcel_geometry on parcel p (cost=0.42..821.02 rows=197 width=505) (actual time=4,331.164..21,044.934 rows=14 loops=1)

  • Index Cond: (geometry_area && (track_table.line)::geography)
  • Filter: ((cluster_id IS NULL) AND ((status)::text = 'ACTIVE'::text) AND (_st_distance(geometry_area, (track_table.line)::geography, '0'::double precision, false) < '1e-05'::double precision))
  • Rows Removed by Filter: 915