explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vEho

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.024 ↓ 0.0 0 1

Hash Right Join (cost=22.36..2,881.14 rows=6 width=346) (actual time=0.024..0.024 rows=0 loops=1)

  • Hash Cond: ((organization_t_2.st_cd)::text = (organization_t.st_cd)::text)
2. 0.000 0.000 ↓ 0.0 0

Seq Scan on organization_t organization_t_2 (cost=0.00..38.51 rows=56 width=30) (never executed)

  • Filter: ((org_typ_cd)::text = 'T'::text)
3. 0.001 0.015 ↓ 0.0 0 1

Hash (cost=22.34..22.34 rows=2 width=248) (actual time=0.015..0.015 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
4. 0.000 0.014 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.67..22.34 rows=2 width=248) (actual time=0.014..0.014 rows=0 loops=1)

5. 0.000 0.014 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.39..21.53 rows=2 width=203) (actual time=0.014..0.014 rows=0 loops=1)

6. 0.000 0.014 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.11..20.69 rows=2 width=141) (actual time=0.014..0.014 rows=0 loops=1)

  • -> Index Scan using userwkldtrld_t_user_org_uid_idx on userwkldtrld_t (cost=0.28..0.34 rows=1 width=14) (never execut
7. 0.000 0.014 ↓ 0.0 0 1

Nested Loop (cost=0.84..20.01 rows=2 width=131) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (userorganization_t.user_org_uid = user_org_uid)
8. 0.014 0.014 ↓ 0.0 0 1

Nested Loop (cost=0.56..19.32 rows=2 width=64) (actual time=0.014..0.014 rows=0 loops=1)

  • -> Index Scan using ixf02_pin on dcpsuser_t (cost=0.28..8.29 rows=1 width=4) (actual time=0.014..0.014 ro
  • Index Cond: ((pin)::text = '904289'::text)
  • -> Index Scan using ixf02_useruid on userorganization_t (cost=0.28..11.01 rows=2 width=64) (never execute
  • Index Cond: (user_uid = dcpsuser_t.user_uid)
  • Filter: (eff_endt IS NULL)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpk_organization_t on organization_t (cost=0.28..0.34 rows=1 width=71) (never executed)

  • Index Cond: (org_uid = userorganization_t.org_uid)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpk_dcpsuser_t on dcpsuser_t dcpsuser_t_1 (cost=0.28..0.42 rows=1 width=62) (never executed)

  • Index Cond: (organization_t.org_ownr_uid = user_uid)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpk_organization_t on organization_t organization_t_1 (cost=0.28..0.41 rows=1 width=49) (never executed)

  • Index Cond: (organization_t.site_org_uid = org_uid)
12.          

SubPlan (forHash Right Join)

13. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=457.69..457.70 rows=1 width=32) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Sort (cost=457.38..457.43 rows=20 width=20) (never executed)

  • Sort Key: independentpermission_t.prmis_cd
15. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=456.75..456.95 rows=20 width=20) (never executed)

  • Group Key: independentpermission_t.prmis_cd
16. 0.000 0.000 ↓ 0.0 0

Append (cost=5.66..456.70 rows=20 width=20) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.66..70.50 rows=3 width=5) (never executed)

  • Hash Cond: ((independentpermission_t.prmis_cd)::text = (permission_t.prmis_cd)::text)
18. 0.000 0.000 ↓ 0.0 0

Seq Scan on independentpermission_t (cost=0.00..64.83 rows=4 width=5) (never executed)

  • Filter: (user_org_uid = userorganization_t.user_org_uid)
19. 0.000 0.000 ↓ 0.0 0

Hash (cost=4.64..4.64 rows=82 width=5) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Seq Scan on permission_t (cost=0.00..4.64 rows=82 width=5) (never executed)

  • Filter: ((eff_endt IS NULL) OR (eff_endt > '2019-05-15'::date))
21. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=144.71..386.00 rows=17 width=5) (never executed)

  • Join Filter: (organizationrole_t.role_uid = dcpsrole_t.role_uid)
22. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=144.43..380.65 rows=17 width=13) (never executed)

  • Hash Cond: (rolepermission_t.role_uid = organizationrole_t.role_uid)
23. 0.000 0.000 ↓ 0.0 0

Seq Scan on rolepermission_t (cost=0.00..197.85 rows=10,185 width=9) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Hash (cost=144.42..144.42 rows=1 width=4) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..144.42 rows=1 width=4) (never executed)

  • -> Index Scan using ixpk_organizationrole_t on organizationrole_t (cost=0.28..8.30 rows=1 w
26. 0.000 0.000 ↓ 0.0 0

Seq Scan on userorganizationrole_t (cost=0.00..135.61 rows=1 width=4) (never executed)

  • Filter: ((eff_strt_ts <= '2019-05-15 00:00:00.985+00'::timestamp with time zone) AND ((
  • Index Cond: (org_role_uid = userorganizationrole_t.org_role_uid)
  • Filter: ((org_uid = organization_t_2.org_uid) OR (org_uid = organization_t.site_org_uid
27. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpk_dcpsrole_t on dcpsrole_t (cost=0.28..0.30 rows=1 width=4) (never executed)

  • Index Cond: (role_uid = rolepermission_t.role_uid)
  • Filter: ((eff_strt_ts <= '2019-05-15 00:00:00.985+00'::timestamp with time zone) AND ((eff_end_ts IS NULL
28. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=12.29..12.30 rows=1 width=32) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Sort (cost=12.20..12.21 rows=6 width=11) (never executed)

  • Sort Key: userdshb_t.dflt_dshb_sw DESC, userdshb_t.eff_stdt
30. 0.000 0.000 ↓ 0.0 0

Index Scan using ixf01_userdshb_t on userdshb_t (cost=0.29..12.12 rows=6 width=11) (never executed)

  • Index Cond: (user_org_uid = userorganization_t.user_org_uid)
  • Filter: ((eff_stdt <= '2019-05-15'::date) AND ((eff_endt IS NULL) OR (eff_endt > '2019-05-15'::date)))