explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n6qy

Settings
# exclusive inclusive rows x rows loops node
1. 378.502 2,121.255 ↓ 3,529.5 49,413 1

Gather (cost=1,000.42..79,723.15 rows=14 width=32) (actual time=0.968..2,121.255 rows=49,413 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,742.753 1,742.753 ↓ 2,745.2 16,471 3 / 3

Parallel Index Scan using history_place_stops_history_place_id_idx on history_place_stops (cost=0.42..78,721.75 rows=6 width=32) (actual time=1.366..1,742.753 rows=16,471 loops=3)

  • Index Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND ('0103000020E610000001000000050000009A999999991930C0713D0AD7A37040409A999999991930C07B14AE47E10A5540D7A3703D0A1744407B14AE47E10A5540D7A3703D0A174440713D0AD7A37040409A999999991930C0713D0AD7A3704040'::geometry ~ (ellipse_95)::geometry) AND _st_contains('0103000020E610000001000000050000009A999999991930C0713D0AD7A37040409A999999991930C07B14AE47E10A5540D7A3703D0A1744407B14AE47E10A5540D7A3703D0A174440713D0AD7A37040409A999999991930C0713D0AD7A3704040'::geometry, (ellipse_95)::geometry))
  • Rows Removed by Filter: 9424
Planning time : 0.188 ms
Execution time : 2,126.597 ms