explain.depesz.com

PostgreSQL's explain analyze made readable

Result: REK

Settings
# exclusive inclusive rows x rows loops node
1. 1,988.667 2,042.295 ↓ 4.0 733,932 1

Seq Scan on users (cost=5,924.44..111,706.06 rows=182,013 width=1,045) (actual time=70.152..2,042.295 rows=733,932 loops=1)

  • Filter: (verified AND (avatar_file_name IS NOT NULL) AND (NOT (hashed SubPlan 1)) AND (NOT (hashed SubPlan 2)))
  • Rows Removed by Filter: 632443
2.          

SubPlan (forSeq Scan)

3. 1.891 1.891 ↓ 1.1 2,062 1

Index Only Scan using draft_day_index_via_jeffrey on invitations (cost=0.28..2,493.94 rows=1,928 width=4) (actual time=0.021..1.891 rows=2,062 loops=1)

  • Heap Fetches: 2062
4. 40.714 51.737 ↓ 1.2 35,238 1

HashAggregate (cost=3,065.04..3,353.55 rows=28,851 width=4) (actual time=41.157..51.737 rows=35,238 loops=1)

  • Group Key: flaggings.flagged_user_id
5. 11.023 11.023 ↓ 1.0 61,531 1

Seq Scan on flaggings (cost=0.00..2,911.23 rows=61,523 width=4) (actual time=0.012..11.023 rows=61,531 loops=1)