explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RW4t

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

GroupAggregate (cost=118.31..119.1 rows=35 width=44) (never executed)

  • Group Key: t.animal_id, t.type_name
2. 0.000 0.000 ↓ 0.0

Sort (cost=118.31..118.4 rows=35 width=72) (never executed)

  • Sort Key: t.type_name
3. 0.000 0.000 ↓ 0.0

Subquery Scan on t (cost=116.97..117.41 rows=35 width=72) (never executed)

4. 0.000 0.000 ↓ 0.0

Sort (cost=116.97..117.06 rows=35 width=92) (never executed)

  • Sort Key: api_pastureareahistory.entrance_date
5. 0.000 0.000 ↓ 0.0

WindowAgg (cost=114.5..116.08 rows=35 width=92) (never executed)

6. 0.000 0.000 ↓ 0.0

Sort (cost=114.5..114.59 rows=35 width=22) (never executed)

  • Sort Key: ((api_pastureareahistory.entrance_date)::date)
7. 0.000 0.000 ↓ 0.0

Index Scan using api_pastureareahistory_33c37742 on api_pastureareahistory api_pastureareahistory (cost=0.43..113.6 rows=35 width=22) (never executed)

  • Index Cond: (api_pastureareahistory.animal_id = 956615)
  • Filter: (NOT api_pastureareahistory.deleted)