explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bg3w

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1.053 ↓ 0.0 0 1

Bitmap Heap Scan on trade_item_view2 ti (cost=27.89..1,762.66 rows=68 width=1,052) (actual time=1.053..1.053 rows=0 loops=1)

  • Recheck Cond: ((supplierorganizationid)::text = '578b21e9-2d5a-4337-bb47-c570ef437a82'::text)
  • Filter: ((parentid IS NULL) AND ((source)::text <> 'CLOCK'::text))
2. 1.051 1.051 ↓ 0.0 0 1

Bitmap Index Scan on supplierorgid (cost=0.00..27.88 rows=443 width=0) (actual time=1.051..1.051 rows=0 loops=1)

  • Index Cond: ((supplierorganizationid)::text = '578b21e9-2d5a-4337-bb47-c570ef437a82'::text)
Planning time : 0.571 ms
Execution time : 1.073 ms