explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bjwn

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.036 ↑ 1.0 4 1

Bitmap Heap Scan on table1 (cost=9.72..17.76 rows=4 width=24) (actual time=0.031..0.036 rows=4 loops=1)

  • Recheck Cond: ((id = 461) OR (id = 7618) OR (id = 45581) OR (id = 5238))
  • Heap Blocks: exact=4
2. 0.001 0.024 ↓ 0.0 0 1

BitmapOr (cost=9.72..9.72 rows=4 width=0) (actual time=0.024..0.024 rows=0 loops=1)

3. 0.012 0.012 ↑ 1.0 1 1

Bitmap Index Scan on table1_pkey (cost=0.00..2.43 rows=1 width=0) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (id = 461)
4. 0.005 0.005 ↑ 1.0 1 1

Bitmap Index Scan on table1_pkey (cost=0.00..2.43 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (id = 7618)
5. 0.003 0.003 ↑ 1.0 1 1

Bitmap Index Scan on table1_pkey (cost=0.00..2.43 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (id = 45581)
6. 0.003 0.003 ↑ 1.0 1 1

Bitmap Index Scan on table1_pkey (cost=0.00..2.43 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (id = 5238)
Planning time : 0.078 ms
Execution time : 0.074 ms