explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2CDW

Settings
# exclusive inclusive rows x rows loops node
1. 4,764.263 82,446.665 ↑ 3.1 1,249,464 1

Merge Join (cost=59,297.53..159,906.81 rows=3,888,789 width=12) (actual time=2,115.675..82,446.665 rows=1,249,464 loops=1)

  • Output: atdc.transaction_id, atmc.metric_id, atdc.object_id
  • Merge Cond: (atdc.object_id = rc.object_id)
  • Buffers: shared hit=1182690 read=10645, local hit=2019
2. 73,674.528 73,674.528 ↓ 1.0 1,192,949 1

Index Scan using aed_transactions_details_idx on castoncast_central.aed_transactions_details atdc (cost=0.00..42,273.00 rows=1,192,938 width=8) (actual time=0.025..73,674.528 rows=1,192,949 loops=1)

  • Output: atdc.transaction_id, atdc.object_id, atdc.result_count, atdc.snapshot_id
  • Filter: (atdc.snapshot_id = 91)
  • Rows Removed by Filter: 3779
  • Buffers: shared hit=1182688 read=10645
3. 2,516.175 4,007.874 ↓ 3.4 1,607,821 1

Sort (cost=57,630.45..58,800.52 rows=468,028 width=8) (actual time=2,099.767..4,007.874 rows=1,607,821 loops=1)

  • Output: rc.object_id, atmc.metric_id
  • Sort Key: rc.object_id
  • Sort Method: quicksort Memory: 31090kB
  • Buffers: shared hit=2, local hit=2019
4. 991.346 1,491.699 ↑ 1.2 401,089 1

Hash Join (cost=7.53..13,551.02 rows=468,028 width=8) (actual time=0.693..1,491.699 rows=401,089 loops=1)

  • Output: rc.object_id, atmc.metric_id
  • Hash Cond: (rc.metric_id = atmc.metric_id)
  • Buffers: shared hit=2, local hit=2019
5. 499.712 499.712 ↑ 1.0 456,281 1

Seq Scan on pg_temp_3.tmp_res_cur rc (cost=0.00..6,581.81 rows=456,281 width=8) (actual time=0.016..499.712 rows=456,281 loops=1)

  • Output: rc.metric_id, rc.object_id
  • Buffers: local hit=2019
6. 0.316 0.641 ↑ 1.0 179 1

Hash (cost=5.29..5.29 rows=179 width=4) (actual time=0.641..0.641 rows=179 loops=1)

  • Output: atmc.metric_id
  • Buckets: 1024 Batches: 1 Memory Usage: 7kB
  • Buffers: shared hit=2
7. 0.325 0.325 ↑ 1.0 179 1

Seq Scan on castoncast_central.aed_transaction_metrics atmc (cost=0.00..5.29 rows=179 width=4) (actual time=0.010..0.325 rows=179 loops=1)

  • Output: atmc.metric_id
  • Filter: (atmc.snapshot_id = 91)
  • Rows Removed by Filter: 84
  • Buffers: shared hit=2