explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C5hh

Settings
# exclusive inclusive rows x rows loops node
1. 105.239 523.364 ↓ 3,529.5 49,413 1

Gather (cost=1,000.42..79,723.12 rows=14 width=1,664) (actual time=0.478..523.364 rows=49,413 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 418.125 418.125 ↓ 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.72 rows=6 width=1,664) (actual time=0.115..418.125 rows=16,471 loops=3)

  • Index Cond: (history_place_id = 168,436)
  • Filter: ((ellipse_95 IS NOT NULL) AND ('0103000020E610000001000000050000009A999999991930C0713D0AD7A37040409A999999991930C07B14AE47E10A5540D7A3703D0A1744407B14AE47E10A5540D7A3703D0A174440713D0AD7A37040409A999999991930C0713D0AD7A3704040'::geometry ~ (ellipse_95)::geometry) AND _st_contains('0103000020E610000001000000050000009A999999991930C0713D0AD7A37040409A999999991930C07B14AE47E10A5540D7A3703D0A1744407B14AE47E10A5540D7A3703D0A174440713D0AD7A37040409A999999991930C0713D0AD7A3704040'::geometry, (ellipse_95)::geometry))
  • Rows Removed by Filter: 9,424
Planning time : 0.234 ms
Execution time : 527.938 ms