explain.depesz.com

A tool for finding a real cause for slow queries.

Result: r2F

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 67.818 74,065.581 ↓ 2,933.3 8,800 1

HashAggregate (cost=2,638.13..2,638.16 rows=3 width=16) (actual time=74,063.094..74,065.581 rows=8,800 loops=1)

2. 3,299.752 73,997.763 ↓ 32,410.3 97,231 1

Nested Loop (cost=0.11..2,638.10 rows=3 width=16) (actual time=127.155..73,997.763 rows=97,231 loops=1)

  • -> Index Scan using t_movement_norm_id on t_movement m (cost=0.00..8.37 rows=1 width=16) (actualtime=0.033..0.033 rows=1 loops=97231)
3. 70,698.011 70,698.011 ↓ 32,410.3 97,231 1

Index Scan using t_position_location on t_position p (cost=0.11..2,612.94 rows=3 width=4) (actual time=108.928..70,698.011 rows=97,231 loops=1)

  • Index Cond: (loc && (box2d(st_geometryfromtext((((((((((((((((((((('POLYGON(('::text || ($3)::text) || ' '::text) || ($4)::text) || ', '::text) || ($3)::text) || ' '::text) || ($6)::text) || ', '::text) || ($5)::text) || ' '::text) || ($6)::text) || ', '::text) || ($5)::text) || ' '::text) || ($4)::text) ||', '::text) || ($3)::text) || ' '::text) || ($4)::text) || '))'::text), 4326)))::geometry)
  • Filter: (("timestamp" >= $1) AND ("timestamp" <= $2))
  • Index Cond: (id = p.movement_id)