explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gxgvu

Settings
# exclusive inclusive rows x rows loops node
1. 0.723 15.933 ↑ 1.7 66 1

Hash Left Join (cost=333.56..5,026.94 rows=111 width=300) (actual time=0.891..15.933 rows=66 loops=1)

  • Hash Cond: ((organization_t.st_cd)::text = (organization_t_2.st_cd)::text)
2. 0.049 0.899 ↓ 1.2 66 1

Nested Loop Left Join (cost=169.51..345.00 rows=54 width=202) (actual time=0.171..0.899 rows=66 loops=1)

3. 0.228 0.784 ↓ 1.2 66 1

Merge Join (cost=169.23..322.96 rows=54 width=157) (actual time=0.161..0.784 rows=66 loops=1)

  • Merge Cond: (organization_t.org_uid = userorganization_t.org_uid)
4. 0.473 0.473 ↑ 1.8 2,517 1

Index Scan using ixpk_organization_t on organization_t (cost=0.28..264.53 rows=4,508 width=73) (actual time=0.008..0.473 rows=2,517 loops=1)

5. 0.051 0.083 ↓ 1.2 66 1

Sort (cost=168.95..169.08 rows=54 width=88) (actual time=0.077..0.083 rows=66 loops=1)

  • Sort Key: userorganization_t.org_uid
  • Sort Method: quicksort Memory: 34kB
6. 0.032 0.032 ↓ 1.2 66 1

Index Scan using ixf02_useruid on userorganization_t (cost=0.29..167.40 rows=54 width=88) (actual time=0.008..0.032 rows=66 loops=1)

  • Index Cond: (user_uid = 15)
  • Filter: (eff_endt IS NULL)
7. 0.066 0.066 ↑ 1.0 1 66

Index Scan using ixpk_organization_t on organization_t organization_t_1 (cost=0.28..0.41 rows=1 width=49) (actual time=0.001..0.001 rows=1 loops=66)

  • Index Cond: (organization_t.site_org_uid = org_uid)
8. 0.013 0.517 ↑ 1.0 56 1

Hash (cost=163.35..163.35 rows=56 width=30) (actual time=0.517..0.517 rows=56 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
9. 0.504 0.504 ↑ 1.0 56 1

Seq Scan on organization_t organization_t_2 (cost=0.00..163.35 rows=56 width=30) (actual time=0.004..0.504 rows=56 loops=1)

  • Filter: ((org_typ_cd)::text = 'T'::text)
  • Rows Removed by Filter: 4471
10.          

SubPlan (for Hash Left Join)

11. 8.382 13.332 ↓ 4.0 105 66

Sort (cost=31.74..31.80 rows=26 width=20) (actual time=0.197..0.202 rows=105 loops=66)

  • Sort Key: independentpermission_t.prmis_cd
  • Sort Method: quicksort Memory: 30kB
12. 1.716 4.950 ↓ 4.0 105 66

HashAggregate (cost=30.87..31.13 rows=26 width=20) (actual time=0.065..0.075 rows=105 loops=66)

  • Group Key: independentpermission_t.prmis_cd
13. 0.528 3.234 ↓ 4.3 112 66

Append (cost=0.29..30.80 rows=26 width=20) (actual time=0.002..0.049 rows=112 loops=66)

14. 0.132 0.132 ↑ 1.0 2 66

Index Scan using testind2 on independentpermission_t (cost=0.29..8.69 rows=2 width=5) (actual time=0.001..0.002 rows=2 loops=66)

  • Index Cond: (user_org_uid = userorganization_t.user_org_uid)
15. 1.138 2.574 ↓ 4.6 110 66

Nested Loop (cost=1.13..21.73 rows=24 width=5) (actual time=0.007..0.039 rows=110 loops=66)

  • Join Filter: (organizationrole_t.role_uid = rolepermission_t.role_uid)
16. 0.053 0.330 ↑ 1.0 1 66

Nested Loop (cost=0.84..19.55 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=66)

17. 0.000 0.198 ↑ 1.0 1 66

Nested Loop (cost=0.57..16.97 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=66)

18. 0.132 0.132 ↑ 1.0 1 66

Index Scan using ixf01_userorganizationrole_t on userorganizationrole_t (cost=0.29..8.31 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=66)

  • Index Cond: (user_org_uid = userorganization_t.user_org_uid)
  • Filter: ((eff_strt_ts <= '2019-11-04 16:41:04.375+00'::timestamp with time zone) AND ((eff_end_ts IS NULL) OR (eff_end_ts > '2019-11-04 16:41:04.375+00'::timestamp with time zone)))
19. 0.079 0.079 ↑ 1.0 1 79

Index Scan using ixpk_organizationrole_t on organizationrole_t (cost=0.28..8.30 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=79)

  • 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))
20. 0.079 0.079 ↑ 1.0 1 79

Index Scan using ixpk_dcpsrole_t on dcpsrole_t (cost=0.28..2.57 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=79)

  • Index Cond: (role_uid = organizationrole_t.role_uid)
  • Filter: ((eff_strt_ts <= '2019-11-04 16:41:04.375+00'::timestamp with time zone) AND ((eff_end_ts IS NULL) OR (eff_end_ts > '2019-11-04 16:41:04.375+00'::timestamp with time zone)))
21. 1.106 1.106 ↓ 3.8 92 79

Index Scan using testind3 on rolepermission_t (cost=0.29..1.88 rows=24 width=9) (actual time=0.002..0.014 rows=92 loops=79)

  • Index Cond: (role_uid = dcpsrole_t.role_uid)
22. 0.198 0.462 ↑ 1.1 8 66

Sort (cost=8.83..8.85 rows=9 width=11) (actual time=0.007..0.007 rows=8 loops=66)

  • Sort Key: userdshb_t.dflt_dshb_sw DESC, userdshb_t.eff_stdt
  • Sort Method: quicksort Memory: 25kB
23. 0.264 0.264 ↑ 1.1 8 66

Index Scan using ixf01_userdshb_t on userdshb_t (cost=0.42..8.69 rows=9 width=11) (actual time=0.002..0.004 rows=8 loops=66)

  • Index Cond: (user_org_uid = userorganization_t.user_org_uid)
  • Filter: ((eff_stdt <= '2019-11-04'::date) AND ((eff_endt IS NULL) OR (eff_endt > '2019-11-04'::date)))
Planning time : 2.301 ms
Execution time : 16.197 ms