explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 71La

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

Gather (cost=1,000.42..79,890.50 rows=14 width=1,664) (actual time=1.189..3,949.498 rows=49,413 loops=1)

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

  • Index Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND ('0103000020DA0B00000100000005000000C264778AF42E38412F6DADF0528E314152C28BC464934B41885CA95289635941A755337F98F250410241A0A1DF795941B7EDCF8F36D659415128CDA2F3BD3341C264778AF42E38412F6DADF0528E3141'::geometry ~ st_transform((ellipse_95)::geometry, 3034)) AND _st_contains('0103000020DA0B00000100000005000000C264778AF42E38412F6DADF0528E314152C28BC464934B41885CA95289635941A755337F98F250410241A0A1DF795941B7EDCF8F36D659415128CDA2F3BD3341C264778AF42E38412F6DADF0528E3141'::geometry, st_transform((ellipse_95)::geometry, 3034)))
  • Rows Removed by Filter: 9424
Planning time : 0.599 ms
Execution time : 3,968.197 ms