explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D8sT

Settings
# exclusive inclusive rows x rows loops node
1. 17.436 22.483 ↓ 1.1 106,496 1

Bitmap Heap Scan on product p (cost=3,280.71..8,217.21 rows=95,637 width=4) (actual time=5.279..22.483 rows=106,496 loops=1)

  • Recheck Cond: (((product_id = 101) AND (opid = 1) AND (opvalue = 2)) OR ((product_id = 101) AND (opid = 2) AND (opvalue = 2)))
  • Heap Blocks: exact=2626
2. 0.001 5.047 ↓ 0.0 0 1

BitmapOr (cost=3,280.71..3,280.71 rows=115,525 width=0) (actual time=5.047..5.047 rows=0 loops=1)

3. 3.076 3.076 ↑ 1.1 65,536 1

Bitmap Index Scan on product_product_id_idx12 (cost=0.00..1,966.63 rows=70,257 width=0) (actual time=3.076..3.076 rows=65,536 loops=1)

  • Index Cond: ((product_id = 101) AND (opid = 1) AND (opvalue = 2))
4. 1.970 1.970 ↑ 1.1 40,960 1

Bitmap Index Scan on product_product_id_idx12 (cost=0.00..1,266.26 rows=45,267 width=0) (actual time=1.970..1.970 rows=40,960 loops=1)

  • Index Cond: ((product_id = 101) AND (opid = 2) AND (opvalue = 2))
Planning time : 0.077 ms
Execution time : 24.977 ms