explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XmBf

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=899.14..899.15 rows=1 width=16) (actual rows= loops=)

  • Sort Key: (count("tASE_ID")) DESC
2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=899.11..899.13 rows=1 width=16) (actual rows= loops=)

  • Group Key: "tASE_Supplier
  • Filter: (count("tASE_ID") > 1)
3. 0.000 0.000 ↓ 0.0

Sort (cost=899.11..899.11 rows=1 width=16) (actual rows= loops=)

  • Sort Key: "tASE_Supplier
4. 0.000 0.000 ↓ 0.0

Index Scan using tauctionssuppliersevents_tase_date_idx on "tAuctionsSuppliersEvents" tase (cost=0.44..899.10 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ("tASE_Date" >= '2020-09-03'::date)
  • Filter: ("tASE_Type" = 320,230)