explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pKgd

Settings
# exclusive inclusive rows x rows loops node
1. 114,781.294 907,739.224 ↓ 0.0 0 1

Delete on receipt_payment (cost=50.88..57.63 rows=311 width=12) (actual time=907,739.224..907,739.224 rows=0 loops=1)

  • Buffers: shared hit=95,593,627 read=2,281,424 dirtied=8
  • I/O Timings: read=725,440.112
2. 10,557.000 792,957.930 ↓ 429.1 133,459 1

Merge Join (cost=50.88..57.63 rows=311 width=12) (actual time=71.122..792,957.930 rows=133,459 loops=1)

  • Merge Cond: ((receipt_payment.receiptid = receipt_payment_tmp.receiptid) AND (receipt_payment.paymentguid = receipt_payment_tmp.paymentguid))
  • Buffers: shared hit=95,460,168 read=2,281,424
  • I/O Timings: read=725,440.112
3. 782,318.875 782,318.875 ↑ 1.0 96,996,900 1

Index Scan using receipt_payment_idx on receipt_payment (cost=0.57..352,516,546.72 rows=97,018,153 width=49) (actual time=0.012..782,318.875 rows=96,996,900 loops=1)

  • Buffers: shared hit=95,460,160 read=2,281,416
  • I/O Timings: read=725,403.141
4. 44.942 82.055 ↓ 211.8 133,460 1

Sort (cost=45.59..47.17 rows=630 width=49) (actual time=71.104..82.055 rows=133,460 loops=1)

  • Sort Key: receipt_payment_tmp.receiptid, receipt_payment_tmp.paymentguid
  • Sort Method: quicksort Memory: 99kB
  • Buffers: shared hit=8 read=8
  • I/O Timings: read=36.971
5. 37.113 37.113 ↑ 1.2 528 1

Seq Scan on receipt_payment_tmp (cost=0.00..16.30 rows=630 width=49) (actual time=12.418..37.113 rows=528 loops=1)

  • Buffers: shared read=8
  • I/O Timings: read=36.971
Planning time : 773.147 ms
Execution time : 907,763.791 ms