explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eAbby

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

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 5,376.101 5,376.101 ↓ 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.304..5,376.101 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 : 1.521 ms
Execution time : 5,622.272 ms