explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OfU5

Settings
# exclusive inclusive rows x rows loops node
1. 25.611 370.742 ↑ 1.0 194 1

HashAggregate (cost=1,456.14..1,458.13 rows=199 width=4) (actual time=370.720..370.742 rows=194 loops=1)

  • Group Key: link."group
2. 14.175 345.131 ↓ 176.5 77,655 1

Nested Loop (cost=0.28..1,455.04 rows=440 width=4) (actual time=0.407..345.131 rows=77,655 loops=1)

3. 300.443 300.443 ↓ 174.4 4,359 1

Seq Scan on education (cost=0.00..1,397.91 rows=25 width=16) (actual time=0.359..300.443 rows=4,359 loops=1)

  • Filter: (((cache.flags(education.*) & '010'::"bit"))::bit varying = '010'::bit varying)
  • Rows Removed by Filter: 652
4. 30.513 30.513 ↓ 2.0 18 4,359

Index Only Scan using "education ~~ (degree, group)" on education link (cost=0.28..2.20 rows=9 width=20) (actual time=0.004..0.007 rows=18 loops=4,359)

  • Index Cond: (degree = education.degree)
  • Heap Fetches: 0