explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AFNm

Settings
# exclusive inclusive rows x rows loops node
1. 7.177 25,925.008 ↓ 32.6 6,517 1

GroupAggregate (cost=5,648,104.99..5,648,207.45 rows=200 width=45) (actual time=25,344.102..25,925.008 rows=6,517 loops=1)

  • Group Key: new_history_user_coordinates.user_id
  • Filter: (count(*) > 1)
  • Rows Removed by Filter: 5578
2. 72.938 25,917.831 ↓ 11.7 46,865 1

Group (cost=5,648,104.99..5,648,135.14 rows=4,018 width=41) (actual time=25,343.704..25,917.831 rows=46,865 loops=1)

  • Group Key: new_history_user_coordinates.user_id, new_history_user_coordinates.date
3. 3,087.234 25,844.893 ↓ 191.2 768,802 1

Sort (cost=5,648,104.99..5,648,115.04 rows=4,020 width=41) (actual time=25,343.702..25,844.893 rows=768,802 loops=1)

  • Sort Key: new_history_user_coordinates.user_id, new_history_user_coordinates.date
  • Sort Method: external merge Disk: 40536kB
4. 13,672.820 22,757.659 ↓ 191.2 768,802 1

Bitmap Heap Scan on new_history_user_coordinates (cost=1,769,857.38..5,647,864.33 rows=4,020 width=41) (actual time=9,097.699..22,757.659 rows=768,802 loops=1)

  • Recheck Cond: (date > '2019-04-14'::date)
  • Rows Removed by Index Recheck: 5656
  • Filter: (('0103000020E61000000100000006000000CBF5B6990ACB4240CA1649BBD1E14B40D788601C5CCE42408FE3874A23E04B404AB3791C06C14240B8AF03E78CDC4B40A9A0A2EA57C04240020CCB9F6FE14B4056B950F9D7C842404CA8E0F082E24B40CBF5B6990ACB4240CA1649BBD1E14B40'::geometry ~ geopoint) AND _st_contains('0103000020E61000000100000006000000CBF5B6990ACB4240CA1649BBD1E14B40D788601C5CCE42408FE3874A23E04B404AB3791C06C14240B8AF03E78CDC4B40A9A0A2EA57C04240020CCB9F6FE14B4056B950F9D7C842404CA8E0F082E24B40CBF5B6990ACB4240CA1649BBD1E14B40'::geometry, geopoint))
  • Rows Removed by Filter: 16149280
  • Heap Blocks: exact=25161 lossy=344507
5. 9,084.839 9,084.839 ↓ 1.4 17,196,661 1

Bitmap Index Scan on user_id_created_at_idx (cost=0.00..1,769,856.37 rows=12,059,547 width=0) (actual time=9,084.839..9,084.839 rows=17,196,661 loops=1)

  • Index Cond: (date > '2019-04-14'::date)