explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tJc2

Settings
# exclusive inclusive rows x rows loops node
1. 17,932.870 149,210.777 ↑ 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=74) (actual time=0.217..149,210.777 rows=4,500,347 loops=1)

2. 1,277.907 1,277.907 ↑ 1.0 10,000,000 1

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

3. 20,000.000 130,000.000 ↓ 0.0 0 10,000,000

Bitmap Heap Scan on 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)

  • Recheck Cond: (tok3 && a.tok3)
  • Filter: (objid > a.objid)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=19000620
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: (tok3 && a.tok3)