explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XoLx

Settings
# exclusive inclusive rows x rows loops node
1. 2.931 105.327 ↑ 1.0 100 1

Sort (cost=717.30..717.56 rows=101 width=488) (actual time=104.950..105.327 rows=100 loops=1)

  • Sort Key: t1.fivethous
  • Sort Method: quicksort Memory: 68kB
2. 52.993 102.396 ↑ 1.0 100 1

Hash Join (cost=230.43..713.94 rows=101 width=488) (actual time=3.680..102.396 rows=100 loops=1)

  • Hash Cond: (t2.unique2 = t1.unique2)
3. 46.219 46.219 ↑ 1.0 10,000 1

Seq Scan on tenk2 t2 (cost=0.00..445.00 rows=10,000 width=244) (actual time=0.046..46.219 rows=10,000 loops=1)

4. 1.225 3.184 ↑ 1.0 100 1

Hash (cost=229.17..229.17 rows=101 width=244) (actual time=3.184..3.184 rows=100 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 27kB
5. 1.569 1.959 ↑ 1.0 100 1

Bitmap Heap Scan on tenk1 t1 (cost=5.03..229.17 rows=101 width=244) (actual time=0.612..1.959 rows=100 loops=1)

  • Recheck Cond: (unique1 < 100)
6. 0.390 0.390 ↑ 1.0 100 1

Bitmap Index Scan on tenk1_unique1 (cost=0.00..5.01 rows=101 width=0) (actual time=0.390..0.390 rows=100 loops=1)

  • Index Cond: (unique1 < 100)