explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WO64

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 67.614 ↑ 6.0 1 1

GroupAggregate (cost=107,964.07..107,965.74 rows=6 width=12) (actual time=67.614..67.614 rows=1 loops=1)

  • Group Key: p."BuyerId
2. 0.009 67.605 ↑ 23.8 9 1

Sort (cost=107,964.07..107,964.61 rows=214 width=4) (actual time=67.605..67.605 rows=9 loops=1)

  • Sort Key: p."BuyerId
  • Sort Method: quicksort Memory: 25kB
3. 24.888 67.596 ↑ 23.8 9 1

Seq Scan on "Proposal" p (cost=0.00..107,955.79 rows=214 width=4) (actual time=55.330..67.596 rows=9 loops=1)

  • Filter: (("DeleteTime" IS NULL) AND ("BuyerProductId" = (SubPlan 1)))
  • Rows Removed by Filter: 42701
4.          

SubPlan (for Seq Scan)

5. 42.708 42.708 ↓ 0.0 0 42,708

Index Scan using "IX_dba_18052020_1900" on "BuyerProduct" bp (cost=0.28..2.50 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=42,708)

  • Index Cond: (("DeleteTime" IS NULL) AND ("ProductId" = 942) AND ("BuyerId" = p."BuyerId"))
Planning time : 0.246 ms
Execution time : 67.655 ms