explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iPaH : ggdf

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 12.328 ↓ 0.0 0 1

Delete on rhnuserserverperms up (cost=1,530.68..9,937.94 rows=9,966 width=38) (actual time=12.328..12.328 rows=0 loops=1)

2. 0.001 12.327 ↓ 0.0 0 1

Hash Anti Join (cost=1,530.68..9,937.94 rows=9,966 width=38) (actual time=12.327..12.327 rows=0 loops=1)

  • Hash Cond: ((up.user_id = "*SELECT* 1".user_id) AND (up.server_id = "*SELECT* 1".server_id))
3. 3.984 12.326 ↓ 0.0 0 1

Bitmap Heap Scan on rhnuserserverperms up (cost=510.90..8,218.05 rows=19,932 width=19) (actual time=12.326..12.326 rows=0 loops=1)

  • Recheck Cond: (user_id = '138'::numeric)
  • Heap Blocks: exact=1122
4. 8.342 8.342 ↓ 2.9 57,561 1

Bitmap Index Scan on rhn_usperms_uid_sid_uq (cost=0.00..505.92 rows=19,932 width=0) (actual time=8.341..8.342 rows=57,561 loops=1)

  • Index Cond: (user_id = '138'::numeric)
5. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,016.73..1,016.73 rows=203 width=45) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Append (cost=5.27..1,016.73 rows=203 width=45) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1 (cost=5.27..205.98 rows=27 width=45) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.27..205.71 rows=27 width=13) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using rhn_usgp_u_sg_p_uq on rhnuserservergroupperms usg (cost=0.29..8.30 rows=1 width=10) (never executed)

  • Index Cond: (user_id = '138'::numeric)
  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on rhnservergroupmembers sgm (cost=4.98..196.53 rows=89 width=13) (never executed)

  • Recheck Cond: (server_group_id = usg.server_group_id)
11. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on rhn_sgmembers_sgid_idx (cost=0.00..4.96 rows=89 width=0) (never executed)

  • Index Cond: (server_group_id = usg.server_group_id)
12. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2 (cost=1.53..810.75 rows=176 width=45) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.53..808.99 rows=176 width=13) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.24..6.66 rows=1 width=37) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.10..5.31 rows=2 width=64) (never executed)

  • Hash Cond: (ug.group_type = ugt.id)
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on rhnusergroup ug (cost=0.00..4.16 rows=16 width=96) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.09..1.09 rows=1 width=32) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Seq Scan on rhnusergrouptype ugt (cost=0.00..1.09 rows=1 width=32) (never executed)

  • Filter: ((label)::text = 'org_admin'::text)
19. 0.000 0.000 ↓ 0.0 0

Index Only Scan using rhn_ugmembers_uid_ugid_temp_uq on rhnusergroupmembers ugm (cost=0.14..0.66 rows=1 width=10) (never executed)

  • Index Cond: ((user_id = '138'::numeric) AND (user_group_id = ug.id))
  • Heap Fetches: 0
20. 0.000 0.000 ↓ 0.0 0

Index Only Scan using rhn_server_oid_id_idx on rhnserver s (cost=0.29..604.86 rows=19,747 width=13) (never executed)

  • Index Cond: (org_id = ug.org_id)
  • Heap Fetches: 0