explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lFYu : delivery_report

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 67,250.472 ↓ 0.0 0 1

Sort (cost=991.46..1,007.33 rows=6,350 width=268) (actual time=67,250.472..67,250.472 rows=0 loops=1)

  • Sort Key: live_report_delivery._endtime_date DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=124847 read=4052
  • I/O Timings: read=60911.278
2. 0.002 67,250.455 ↓ 0.0 0 1

Merge Join (cost=332.25..590.38 rows=6,350 width=268) (actual time=67,250.455..67,250.455 rows=0 loops=1)

  • Merge Cond: (((md5(live_report_delivery._mcc_mnc))::uuid) = ((md5((c.mcc_mnc)::text))::uuid))
  • Buffers: shared hit=124844 read=4052
  • I/O Timings: read=60911.278
3. 0.018 67,250.453 ↓ 0.0 0 1

Sort (cost=60.08..62.58 rows=1,000 width=180) (actual time=67,250.453..67,250.453 rows=0 loops=1)

  • Sort Key: ((md5(live_report_delivery._mcc_mnc))::uuid)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=124844 read=4052
  • I/O Timings: read=60911.278
4. 67,250.435 67,250.435 ↓ 0.0 0 1

Function Scan on live_report_delivery (cost=0.25..10.25 rows=1,000 width=180) (actual time=67,250.435..67,250.435 rows=0 loops=1)

  • Buffers: shared hit=124840 read=4052
  • I/O Timings: read=60911.278
5. 0.000 0.000 ↓ 0.0 0

Sort (cost=272.17..275.35 rows=1,270 width=102) (never executed)

  • Sort Key: ((md5((c.mcc_mnc)::text))::uuid)
6. 0.000 0.000 ↓ 0.0 0

Seq Scan on countries c (cost=0.00..206.70 rows=1,270 width=102) (never executed)