explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 38bA : test

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

HashAggregate (cost=1,451.62..1,461.80 rows=3,394 width=929) (actual rows= loops=)

  • Group Key: internship_offers.id
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=532.51..1,424.69 rows=53,870 width=929) (actual rows= loops=)

  • Hash Cond: (internship_offer_weeks.week_id = weeks.id)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=504.00..1,365.95 rows=57,374 width=937) (actual rows= loops=)

  • Hash Cond: (internship_offer_weeks.internship_offer_id = internship_offers.id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on internship_offer_weeks (cost=0.00..829.00 rows=62,665 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=492.12..492.12 rows=3,394 width=929) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on internship_offers (cost=0.00..492.12 rows=3,394 width=929) (actual rows= loops=)

  • Filter: ((discarded_at IS NULL) AND (discarded_at IS NULL))
7. 0.000 0.000 ↓ 0.0

Hash (cost=23.02..23.02 rows=1,568 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on weeks (cost=0.00..23.02 rows=1,568 width=8) (actual rows= loops=)

  • Filter: (((year > 2019) OR ((year = 2019) AND (number > 40))) AND ((year > 2019) OR ((year = 2019) AND (number > 40))))