explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MspS

Settings
# exclusive inclusive rows x rows loops node
1. 904.368 37,153.721 ↑ 586.7 29,389 1

GroupAggregate (cost=2,694,516.55..4,289,329.77 rows=17,241,224 width=141) (actual time=36,183.181..37,153.721 rows=29,389 loops=1)

  • Group Key: a.pos_usr_id, c.cell_id, c.influence_radius, c.mean_x, c.mean_y, a.is_domestic
  • Filter: (count(DISTINCT date(a.pos_time)) > 1)
  • Rows Removed by Filter: 45904
2. 505.878 36,249.353 ↑ 23.7 726,319 1

Sort (cost=2,694,516.55..2,737,619.61 rows=17,241,224 width=73) (actual time=36,183.064..36,249.353 rows=726,319 loops=1)

  • Sort Key: a.pos_usr_id, c.cell_id, c.influence_radius, c.mean_x, c.mean_y, a.is_domestic
  • Sort Method: quicksort Memory: 117325kB
3. 114.280 35,743.475 ↑ 23.7 726,319 1

Nested Loop (cost=0.42..622,176.70 rows=17,241,224 width=73) (actual time=0.914..35,743.475 rows=726,319 loops=1)

4. 15.606 15.606 ↑ 1.0 75,293 1

Seq Scan on test_anchor_test c (cost=0.00..1,630.93 rows=75,293 width=92) (actual time=0.028..15.606 rows=75,293 loops=1)

5. 35,613.589 35,613.589 ↑ 22.9 10 75,293

Index Scan using temp_anchor_data_test_pos_usr_id_idx on temp_anchor_data_test a (cost=0.42..5.95 rows=229 width=21) (actual time=0.192..0.473 rows=10 loops=75,293)

  • Index Cond: (pos_usr_id = c.pos_usr_id)
  • Filter: (idx(c.cell_seen_arr, cell_id) <> 0)
  • Rows Removed by Filter: 381