explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CCRa

Settings
# exclusive inclusive rows x rows loops node
1. 154.557 5,507.494 ↓ 3,529.5 49,413 1

Gather (cost=1,000.42..79,890.53 rows=14 width=32) (actual time=1.871..5,507.494 rows=49,413 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 5,352.937 5,352.937 ↓ 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=2.312..5,352.937 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.433 ms
Execution time : 5,521.680 ms