explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jjmJ

Settings
# exclusive inclusive rows x rows loops node
1. 918.083 7,901.519 ↑ 229.0 75,293 1

GroupAggregate (cost=2,461,929.53..3,970,536.63 rows=17,241,224 width=141) (actual time=6,937.777..7,901.519 rows=75,293 loops=1)

  • Group Key: a.pos_usr_id, c.cell_id, c.influence_radius, c.mean_x, c.mean_y, a.is_domestic
2. 421.113 6,983.436 ↑ 23.7 726,319 1

Sort (cost=2,461,929.53..2,505,032.59 rows=17,241,224 width=73) (actual time=6,937.673..6,983.436 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,192.593 6,562.323 ↑ 23.7 726,319 1

Merge Join (cost=0.72..389,589.68 rows=17,241,224 width=73) (actual time=1.973..6,562.323 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. 212.758 212.758 ↑ 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.052..212.758 rows=75,293 loops=1)

5. 1,250.018 2,156.972 ↓ 40.5 29,400,301 1

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

6. 906.954 906.954 ↑ 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.051..906.954 rows=726,319 loops=1)