explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CiHa

Settings
# exclusive inclusive rows x rows loops node
1. 1.469 2,297,301.280 ↑ 733.1 182 1

GroupAggregate (cost=539.26..2,603,351.95 rows=133,416 width=12) (actual time=472,963.345..2,297,301.280 rows=182 loops=1)

  • Output: cur.transaction_id, 67921, cur.metric_id, count(cur.object_id), 51
  • Buffers: local hit=24209258 read=38244338
2. 87,305.423 2,297,299.811 ↑ 473.4 286 1

Merge Anti Join (cost=539.26..2,601,002.27 rows=135,402 width=12) (actual time=455,932.752..2,297,299.811 rows=286 loops=1)

  • Output: cur.transaction_id, cur.metric_id, cur.object_id
  • Merge Cond: ((cur.transaction_id = previous.transaction_id) AND (cur.metric_id = previous.metric_id) AND (cur.object_id = previous.object_id))
  • Buffers: local hit=24209258 read=38244338
3. 366,218.832 366,218.832 ↑ 1.0 31,121,737 1

Index Only Scan using wk_cur_idx on pg_temp_31.wk_cur cur (cost=0.00..1,042,948.86 rows=31,121,748 width=12) (actual time=0.016..366,218.832 rows=31,121,737 loops=1)

  • Output: cur.transaction_id, cur.metric_id, cur.object_id
  • Heap Fetches: 31121737
  • Buffers: local hit=12103761 read=19121657
4. 1,843,775.556 1,843,775.556 ↓ 1.0 31,124,732 1

Index Only Scan using wk_prev_idx on pg_temp_31.wk_prev previous (cost=0.00..1,043,044.29 rows=31,124,700 width=12) (actual time=0.012..1,843,775.556 rows=31,124,732 loops=1)

  • Output: previous.transaction_id, previous.metric_id, previous.object_id
  • Heap Fetches: 31124732
  • Buffers: local hit=12105497 read=19122681