explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZYCP

Settings
# exclusive inclusive rows x rows loops node
1. 931.299 1,652.345 ↑ 1.8 3,970,351 1

Hash Join (cost=1,770.95..254,711.27 rows=7,053,824 width=12) (actual time=13.541..1,652.345 rows=3,970,351 loops=1)

  • Output: atdc.transaction_id, atmc.metric_id, atdc.object_id
  • Hash Cond: (atdc.object_id = rc.object_id)
  • Buffers: shared hit=3 read=29477, local hit=192
2. 707.713 707.713 ↓ 1.0 2,726,628 1

Seq Scan on daimler_srs_837_central.aed_transactions_details atdc (cost=0.00..97,643.70 rows=2,712,268 width=8) (actual time=0.023..707.713 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=2 read=29476
3. 4.640 13.333 ↓ 1.1 43,231 1

Hash (cost=1,258.84..1,258.84 rows=40,969 width=8) (actual time=13.333..13.333 rows=43,231 loops=1)

  • Output: rc.object_id, atmc.metric_id
  • Buckets: 65536 Batches: 1 Memory Usage: 2201kB
  • Buffers: shared hit=1 read=1, local hit=192
4. 6.504 8.693 ↓ 1.1 43,231 1

Hash Join (cost=6.46..1,258.84 rows=40,969 width=8) (actual time=0.067..8.693 rows=43,231 loops=1)

  • Output: rc.object_id, atmc.metric_id
  • Hash Cond: (rc.metric_id = atmc.metric_id)
  • Buffers: shared hit=1 read=1, local hit=192
5. 2.135 2.135 ↑ 1.0 43,379 1

Seq Scan on pg_temp_4.maint_tmp_res_cur rc (cost=0.00..625.79 rows=43,379 width=8) (actual time=0.009..2.135 rows=43,379 loops=1)

  • Output: rc.metric_id, rc.object_id
  • Buffers: local hit=192
6. 0.013 0.054 ↑ 1.0 119 1

Hash (cost=4.97..4.97 rows=119 width=4) (actual time=0.054..0.054 rows=119 loops=1)

  • Output: atmc.metric_id
  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
  • Buffers: shared hit=1 read=1
7. 0.041 0.041 ↑ 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.008..0.041 rows=119 loops=1)

  • Output: atmc.metric_id
  • Filter: (atmc.snapshot_id = 4)
  • Rows Removed by Filter: 119
  • Buffers: shared hit=1 read=1