explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qMU4

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

Aggregate (cost=2,486,684.75..2,486,684.76 rows=1 width=0) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Merge Anti Join (cost=40.57..2,470,791.17 rows=6,357,433 width=0) (actual rows= loops=)

  • Merge Cond: (t.group_id = v.id)
3. 0.000 0.000 ↓ 0.0

Index Only Scan using index_users_on_group_id on users t (cost=0.44..2,390,142.19 rows=9,988,635 width=4) (actual rows= loops=)

  • Index Cond: (group_id IS NOT NULL)
4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.41..1,272.81 rows=25,383 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Only Scan using groups_pkey on groups v (cost=0.41..1,209.36 rows=25,383 width=4) (actual rows= loops=)