explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tHTz

Settings
# exclusive inclusive rows x rows loops node
1. 178.717 185.425 ↓ 5.7 387 1

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

  • Recheck Cond: ((supplierorganizationid)::text = '435c98cf-2a6c-3ebc-971a-39b3d6ecc80e'::text)
  • Filter: ((parentid IS NULL) AND ((source)::text <> 'CLOCK'::text))
  • Rows Removed by Filter: 143
  • Heap Blocks: exact=519
2. 6.708 6.708 ↓ 1.3 588 1

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

  • Index Cond: ((supplierorganizationid)::text = '435c98cf-2a6c-3ebc-971a-39b3d6ecc80e'::text)
Planning time : 0.101 ms
Execution time : 185.564 ms