explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kCsH

Settings
# exclusive inclusive rows x rows loops node
1. 104.453 141.087 ↑ 1.0 100,000 1

Sort (cost=15,630.32..15,880.32 rows=100,000 width=61) (actual time=115.493..141.087 rows=100,000 loops=1)

  • Output: province_id, district_id, district_name_en, district_name_th
  • Sort Key: myi_address_code.district_id
  • Sort Method: external sort Disk: 6960kB
  • Buffers: shared hit=2563, temp read=870 written=870
2. 36.634 36.634 ↑ 1.0 100,000 1

Seq Scan on public.myi_address_code (cost=0.00..3,563.00 rows=100,000 width=61) (actual time=0.007..36.634 rows=100,000 loops=1)

  • Output: province_id, district_id, district_name_en, district_name_th
  • Buffers: shared hit=2563
Planning time : 0.057 ms
Execution time : 161.243 ms