explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BdCH

Settings
# exclusive inclusive rows x rows loops node
1. 962.685 7,846.388 ↑ 586.7 29,389 1

GroupAggregate (cost=2,461,929.53..4,056,742.75 rows=17,241,224 width=141) (actual time=6,834.971..7,846.388 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. 416.602 6,883.703 ↑ 23.7 726,319 1

Sort (cost=2,461,929.53..2,505,032.59 rows=17,241,224 width=73) (actual time=6,834.861..6,883.703 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. 4,156.294 6,467.101 ↑ 23.7 726,319 1

Merge Join (cost=0.72..389,589.68 rows=17,241,224 width=73) (actual time=1.989..6,467.101 rows=726,319 loops=1)

  • Merge Cond: (c.pos_usr_id = a.pos_usr_id)
  • Join Filter: (idx(c.cell_seen_arr, a.cell_id) <> 0)
  • Rows Removed by Join Filter: 28673982
4. 213.180 213.180 ↑ 1.0 75,293 1

Index Scan using test_anchor_test_pos_usr_id_idx on test_anchor_test c (cost=0.29..5,473.69 rows=75,293 width=92) (actual time=0.042..213.180 rows=75,293 loops=1)

5. 1,185.982 2,097.627 ↓ 40.5 29,400,301 1

Materialize (cost=0.42..39,186.29 rows=726,319 width=21) (actual time=0.055..2,097.627 rows=29,400,301 loops=1)

6. 911.645 911.645 ↑ 1.0 726,319 1

Index Scan using temp_anchor_data_test_pos_usr_id_idx on temp_anchor_data_test a (cost=0.42..37,370.50 rows=726,319 width=21) (actual time=0.052..911.645 rows=726,319 loops=1)