explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zku

Settings
# exclusive inclusive rows x rows loops node
1. 18,874.532 150,169.780 ↑ 74,068.4 4,500,347 1

Nested Loop (cost=10,000,000,758.35..35,927,019,748.00 rows=333,333,333,333 width=8) (actual time=0.209..150,169.780 rows=4,500,347 loops=1)

  • Output: a.objid, b.objid
  • Buffers: shared hit=149154467
2. 1,295.248 1,295.248 ↑ 1.0 10,000,000 1

Seq Scan on public.objtokd a (cost=10,000,000,000.00..10,000,253,847.00 rows=10,000,000 width=37) (actual time=0.011..1,295.248 rows=10,000,000 loops=1)

  • Output: a.objid, a.tok1, a.tok2, a.tok3
  • Buffers: shared hit=153847
3. 20,000.000 130,000.000 ↓ 0.0 0 10,000,000

Bitmap Heap Scan on public.objtokd b (cost=758.35..2,259.35 rows=33,333 width=37) (actual time=0.013..0.013 rows=0 loops=10,000,000)

  • Output: b.objid, b.tok1, b.tok2, b.tok3
  • Recheck Cond: (b.tok3 && a.tok3)
  • Filter: (a.objid < b.objid)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=19000620
  • Buffers: shared hit=149000620
4. 110,000.000 110,000.000 ↑ 50,000.0 2 10,000,000

Bitmap Index Scan on objtokd3 (cost=0.00..750.01 rows=100,000 width=0) (actual time=0.011..0.011 rows=2 loops=10,000,000)

  • Index Cond: (b.tok3 && a.tok3)
  • Buffers: shared hit=130000000