explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nxBz

Settings
# exclusive inclusive rows x rows loops node
1. 204.827 7,403.535 ↓ 3,529.5 49,413 1

Gather (cost=1,000.42..79,890.53 rows=14 width=32) (actual time=2.773..7,403.535 rows=49,413 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 7,198.708 7,198.708 ↓ 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.13 rows=6 width=32) (actual time=4.697..7,198.708 rows=16,471 loops=3)

  • Index Cond: (history_place_id = 168,436)
  • 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: 9,424
Planning time : 0.705 ms
Execution time : 7,419.305 ms