explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t7xD

Settings
# exclusive inclusive rows x rows loops node
1. 4.659 32.352 ↑ 1.1 106,496 1

Append (cost=1,984.20..11,690.69 rows=115,524 width=4) (actual time=3.314..32.352 rows=106,496 loops=1)

2. 12.968 16.034 ↑ 1.1 65,536 1

Bitmap Heap Scan on product p (cost=1,984.20..5,839.70 rows=70,257 width=4) (actual time=3.314..16.034 rows=65,536 loops=1)

  • Recheck Cond: ((product_id = 101) AND (opid = 1) AND (opvalue = 2))
  • Heap Blocks: exact=2626
3. 3.066 3.066 ↑ 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.066..3.066 rows=65,536 loops=1)

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

Bitmap Heap Scan on product p_1 (cost=1,277.58..4,695.75 rows=45,267 width=4) (actual time=2.874..11.659 rows=40,960 loops=1)

  • Recheck Cond: ((product_id = 101) AND (opid = 2) AND (opvalue = 2))
  • Heap Blocks: exact=2626
5. 2.604 2.604 ↑ 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=2.604..2.604 rows=40,960 loops=1)

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