explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JFML

Settings
# exclusive inclusive rows x rows loops node
1. 28,420.088 28,846.901 ↓ 6.3 72,326 1

Bitmap Heap Scan on trade_item_view2 ti (cost=4,578.62..194,880.48 rows=11,502 width=1,052) (actual time=434.255..28,846.901 rows=72,326 loops=1)

  • Recheck Cond: ((supplierorganizationid)::text = 'aa677197-b686-39d4-9789-9d33f2c81655'::text)
  • Rows Removed by Index Recheck: 133131
  • Filter: ((parentid IS NULL) AND ((source)::text <> 'CLOCK'::text))
  • Rows Removed by Filter: 8
  • Heap Blocks: exact=33226 lossy=27603
2. 426.813 426.813 ↓ 1.0 77,521 1

Bitmap Index Scan on supplierorgid (cost=0.00..4,575.75 rows=74,559 width=0) (actual time=426.813..426.813 rows=77,521 loops=1)

  • Index Cond: ((supplierorganizationid)::text = 'aa677197-b686-39d4-9789-9d33f2c81655'::text)
Planning time : 0.078 ms
Execution time : 28,866.919 ms