explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 541

Settings
# exclusive inclusive rows x rows loops node
1. 29,104.412 13,687,205.706 ↓ 1,323,450.3 3,970,351 1

Nested Loop (cost=0.00..98,824.24 rows=3 width=12) (actual time=9,129.083..13,687,205.706 rows=3,970,351 loops=1)

  • Output: atdc.transaction_id, atmc.metric_id, atdc.object_id
  • Join Filter: (rc.metric_id = atmc.metric_id)
  • Rows Removed by Join Filter: 468501418
  • Buffers: shared hit=29480, local hit=523512576, temp read=1258352 written=10663
2. 0.292 0.292 ↑ 1.0 119 1

Seq Scan on daimler_srs_837_central.aed_transaction_metrics atmc (cost=0.00..4.97 rows=119 width=4) (actual time=0.016..0.292 rows=119 loops=1)

  • Output: atmc.metric_id, atmc.result_count, atmc.snapshot_id
  • Filter: (atmc.snapshot_id = 4)
  • Rows Removed by Filter: 119
  • Buffers: shared hit=2
3. 37,252.065 13,658,101.002 ↓ 1,323,450.3 3,970,351 119

Materialize (cost=0.00..98,813.92 rows=3 width=12) (actual time=0.020..114,773.958 rows=3,970,351 loops=119)

  • Output: rc.metric_id, atdc.transaction_id, atdc.object_id
  • Buffers: shared hit=29478, local hit=523512576, temp read=1258352 written=10663
4. 7,374,381.259 13,620,848.937 ↓ 1,323,450.3 3,970,351 1

Nested Loop (cost=0.00..98,813.90 rows=3 width=12) (actual time=1.238..13,620,848.937 rows=3,970,351 loops=1)

  • Output: rc.metric_id, atdc.transaction_id, atdc.object_id
  • Join Filter: (rc.object_id = atdc.object_id)
  • Rows Removed by Join Filter: 118274425661
  • Buffers: shared hit=29478, local hit=523512576
5. 2,489.558 2,489.558 ↓ 2,726,628.0 2,726,628 1

Seq Scan on daimler_srs_837_central.aed_transactions_details atdc (cost=0.00..97,645.88 rows=1 width=8) (actual time=0.009..2,489.558 rows=2,726,628 loops=1)

  • Output: atdc.transaction_id, atdc.object_id, atdc.result_count, atdc.snapshot_id
  • Filter: (atdc.snapshot_id = 4)
  • Rows Removed by Filter: 2726628
  • Buffers: shared hit=29478
6. 6,243,978.120 6,243,978.120 ↑ 1.0 43,379 2,726,628

Seq Scan on pg_temp_5.tmp_res_cur rc (cost=0.00..625.79 rows=43,379 width=8) (actual time=0.004..2.290 rows=43,379 loops=2,726,628)

  • Output: rc.metric_id, rc.object_id
  • Buffers: local hit=523512576