explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ECPC

Settings
# exclusive inclusive rows x rows loops node
1. 28.417 45.165 ↑ 1.0 4 1

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

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

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

3. 11.230 11.230 ↑ 1.0 1 1

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

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

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

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

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

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

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

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