explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jtmN

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

Aggregate (cost=17,635,296.36..17,635,296.37 rows=1 width=0) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Only Scan using index_users_on_group_id on users t (cost=0.44..17,622,810.57 rows=4,994,317 width=0) (actual rows= loops=)

  • Index Cond: (group_id IS NOT NULL)
  • Filter: (NOT (SubPlan 1))
3.          

SubPlan (for Index Only Scan)

4. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = t.group_id)