explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JHFO

Settings
# exclusive inclusive rows x rows loops node
1. 75,329.882 75,329.882 ↓ 4.8 256 1

Index Scan using parent_id_idx on trade_item_view2 ti (cost=0.56..1,815.56 rows=53 width=32) (actual time=74,809.384..75,329.882 rows=256 loops=1)

  • Index Cond: ((parentid IS NULL) AND ((supplierorganizationid)::text = '5b98c99c-cef3-3e66-a3f9-8f9f38f8f66f'::text))
  • Filter: ((source)::text <> 'CLOCK'::text)
  • Rows Removed by Filter: 5561
Planning time : 0.293 ms
Execution time : 75,329.985 ms