explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Snkx : Plan1 Explain Analyze

Settings
# exclusive inclusive rows x rows loops node
1. 4,367.404 214,441.560 ↓ 19.4 17,658,189 1

Merge Join (cost=43.83..1,362,200.10 rows=911,341 width=32) (actual time=102.088..214,441.560 rows=17,658,189 loops=1)

  • Output: t1.id, t1.total, t1.price, t2.category
  • Merge Cond: (t1.id = t2.id)
  • Buffers: shared hit=8 read=329809
2. 97,275.248 97,275.248 ↑ 1.0 18,453,924 1

Index Scan using pk_t1 on public.t1 (cost=0.57..666,228.59 rows=18,598,858 width=30) (actual time=25.573..97,275.248 rows=18,453,924 loops=1)

  • Output: t1.id, t1.total, t1.price
  • Index Cond: (t1.id > (-9223372036513411363)::bigint)
  • Buffers: shared hit=5 read=186111
3. 112,798.908 112,798.908 ↓ 1.0 17,658,189 1

Index Scan using pk_t2 on public.t2 (cost=0.57..596,391.78 rows=17,606,469 width=10) (actual time=76.509..112,798.908 rows=17,658,189 loops=1)

  • Output: t2.id, t2.category
  • Index Cond: (t2.id > (-9223372036513411363)::bigint)
  • Buffers: shared hit=3 read=143698