explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3KWQ

Settings
# exclusive inclusive rows x rows loops node
1. 8.332 15,497.754 ↓ 33.0 6,605 1

GroupAggregate (cost=4,912,351.15..4,912,511.59 rows=200 width=45) (actual time=14,624.909..15,497.754 rows=6,605 loops=1)

  • Group Key: new_history_user_coordinates.user_id
  • Filter: (count(*) > 1)
  • Rows Removed by Filter: 5630
2. 122.684 15,489.422 ↓ 8.3 47,805 1

Group (cost=4,912,351.15..4,912,408.81 rows=5,759 width=69) (actual time=14,624.167..15,489.422 rows=47,805 loops=1)

  • Group Key: new_history_user_coordinates.user_id, (to_char(new_history_user_coordinates.created_at, 'DD Mon YYYY'::text))
3. 2,722.549 15,366.738 ↓ 134.8 777,274 1

Sort (cost=4,912,351.15..4,912,365.57 rows=5,768 width=69) (actual time=14,624.164..15,366.738 rows=777,274 loops=1)

  • Sort Key: new_history_user_coordinates.user_id, (to_char(new_history_user_coordinates.created_at, 'DD Mon YYYY'::text))
  • Sort Method: external merge Disk: 44824kB
4. 12,644.189 12,644.189 ↓ 134.8 777,274 1

Seq Scan on new_history_user_coordinates (cost=0.00..4,911,990.83 rows=5,768 width=69) (actual time=0.096..12,644.189 rows=777,274 loops=1)

  • Filter: ((created_at > '2019-04-14 00:00:00'::timestamp without time zone) AND ('0103000020E61000000100000006000000CBF5B6990ACB4240CA1649BBD1E14B40D788601C5CCE42408FE3874A23E04B404AB3791C06C14240B8AF03E78CDC4B40A9A0A2EA57C04240020CCB9F6FE14B4056B950F9D7C842404CA8E0F082E24B40CBF5B6990ACB4240CA1649BBD1E14B40'::geometry ~ geopoint) AND _st_contains('0103000020E61000000100000006000000CBF5B6990ACB4240CA1649BBD1E14B40D788601C5CCE42408FE3874A23E04B404AB3791C06C14240B8AF03E78CDC4B40A9A0A2EA57C04240020CCB9F6FE14B4056B950F9D7C842404CA8E0F082E24B40CBF5B6990ACB4240CA1649BBD1E14B40'::geometry, geopoint))
  • Rows Removed by Filter: 16527120
Planning time : 22.935 ms
Execution time : 15,505.388 ms