explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IIdh

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 60,628.982 ↓ 1.2 10,000,010 1

Gather Merge (cost=1,013,948.54..1,986,244.55 rows=8,333,384 width=77) (actual time=42,978.838..60,628.982 rows=10,000,010 loops=1)

  • Buffers: shared hit=29 read=47641, temp read=91342 written=91479
2. 120,660.846 145,578.504 ↑ 1.3 3,333,337 3

Sort (cost=1,012,948.52..1,023,365.25 rows=4,166,692 width=77) (actual time=42,765.496..48,526.168 rows=3,333,337 loops=3)

  • Sort Key: towns.name, towns.code DESC
  • Sort Method: external merge Disk: 283856kB
  • Buffers: shared hit=170 read=142762, temp read=273289 written=273700
3. 24,917.658 24,917.658 ↑ 1.3 3,333,337 3

Seq Scan on towns towns (cost=0..184,524.92 rows=4,166,692 width=77) (actual time=0.322..8,305.886 rows=3,333,337 loops=3)

  • Buffers: shared hit=96 read=142762