explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 70dd : Subselect version

Settings
# exclusive inclusive rows x rows loops node
1. 3.012 3.727 ↑ 1.2 2,563 1

HashAggregate (cost=330.49..360.56 rows=3,007 width=181) (actual time=3.086..3.727 rows=2,563 loops=1)

  • Buffers: shared hit=73group_authorization group_
2. 0.699 0.715 ↑ 1.2 2,563 1

Seq Scan on resource_type resource_type_1 (cost=106.46..217.73 rows=3,007 width=181) (actual time=0.004..0.715 rows=2,563 loops=1)

  • Filter: ((NOT authorized) OR (hashed SubPlan 1))
  • Rows Removed by Filter: 898s: 2 Memory Us
  • Buffers: shared hit=73hit=212, temp writte
  • SubPlan 1 Hash Join (cost=173.34..771.77
3. 0.001 0.016 ↓ 0.0 0 1

Nested Loop (cost=70.67..106.46 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=1)

  • Join Filter: (group_member.group_oid = group_authorization.group_oid)
4. 0.015 0.015 ↓ 0.0 0 1

Buffers: shared hit=5INNER JOIN group_member ON ((group_member.group_oid = group_authorization.group_oid) and (group_member.person_oid = group_authorization.person_oid)) -> Nested Loop (cost=0.57..28.47 rows=1 width=24) (actual time=0.015..0.015 rows=0 loops=1) ((group_authorization.expire > '2014-03-03T18:11:20.553844Z') or (group_aut Buffers: shared hit=5er.expire > '2014-03-03T18:11:20.553844Z') or (group_member.expire IS NULL)) and ((wco_group.end_date > '2014-03-03T18:11:20.553844Z') or (wco -> Index Scan using group_member_person_idx on group_member (cost=0.29..20.15 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (person_oid = 1)
  • Filter: ((expire > '2014-03-03 12:11:20.553844-06'::timestamp with time zone) OR (expire IS NULL))
  • Buffers: shared hit=5
5. 0.000 0.000 ↓ 0.0 0

Index Scan using wco_group_pkey on wco_group (cost=0.28..8.31 rows=1 width=8) (never executed)

  • Index Cond: (obj_oid = group_member.group_oid)
  • Filter: ((end_date > '2014-03-03 12:11:20.553844-06'::timestamp with time zone) OR (end_date IS NULL))
6. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on group_authorization (cost=70.10..77.98 rows=1 width=24) (never executed)

  • Recheck Cond: ((person_oid = 1) AND (group_oid = wco_group.obj_oid))
  • Filter: ((expire > '2014-03-03 12:11:20.553844-06'::timestamp with time zone) OR (expire IS NULL))
7. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=70.10..70.10 rows=2 width=0) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on group_authorization_person_idx (cost=0.00..5.11 rows=92 width=0) (never executed)

  • Index Cond: (person_oid = 1)
9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on group_authorization_group_idx (cost=0.00..64.73 rows=8,225 width=0) (never executed)

  • Index Cond: (group_oid = wco_group.obj_oid)