explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xe1r

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 18.685 ↓ 24.0 24 1

Sort (cost=899.77..899.77 rows=1 width=16) (actual time=18.684..18.685 rows=24 loops=1)

  • Sort Key: (count("tASE_ID")) DESC
  • Sort Method: quicksort Memory: 26kB
2. 0.201 18.679 ↓ 24.0 24 1

GroupAggregate (cost=899.73..899.76 rows=1 width=16) (actual time=18.429..18.679 rows=24 loops=1)

  • Group Key: "tASE_Supplier
  • Filter: (count("tASE_ID") > 1)
  • Rows Removed by Filter: 912
3. 0.244 18.478 ↓ 960.0 960 1

Sort (cost=899.73..899.74 rows=1 width=16) (actual time=18.421..18.478 rows=960 loops=1)

  • Sort Key: "tASE_Supplier
  • Sort Method: quicksort Memory: 70kB
4. 18.234 18.234 ↓ 960.0 960 1

Index Scan using tauctionssuppliersevents_tase_date_idx on "tAuctionsSuppliersEvents" tase (cost=0.44..899.72 rows=1 width=16) (actual time=0.307..18.234 rows=960 loops=1)

  • Index Cond: ("tASE_Date" >= '2020-09-03'::date)
  • Filter: ("tASE_Type" = 320,230)
  • Rows Removed by Filter: 55,343
Planning time : 0.118 ms
Execution time : 18.708 ms