explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c6h8

Settings
# exclusive inclusive rows x rows loops node
1. 174.816 6,301.421 ↓ 3,529.5 49,413 1

Gather (cost=1,000.42..79,890.53 rows=14 width=32) (actual time=2.052..6,301.421 rows=49,413 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 6,126.605 6,126.605 ↓ 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.852..6,126.605 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.488 ms
Execution time : 6,314.525 ms