explain.depesz.com

A tool for finding a real cause for slow queries.

Result: r2F

options
# exclusive inclusive rows x rows loops node
1. 67.818 74065.581 ↓ 2933.3 8800 1
→

HashAggregate (cost=2638.13..2638.16 rows=3 width=16) (actual time=74063.094..74065.581 rows=8800 loops=1)

2. 3299.752 73997.763 ↓ 32410.3 97231 1
→

Nested Loop (cost=0.11..2638.10 rows=3 width=16) (actual time=127.155..73997.763 rows=97231 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. 70698.011 70698.011 ↓ 32410.3 97231 1
→

Index Scan using t_position_location on t_position p (cost=0.11..2612.94 rows=3 width=4) (actual time=108.928..70698.011 rows=97231 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)