explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wfTN

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 14.275 ↑ 5.0 1 1

Hash Right Join (cost=22.41..2,430.09 rows=5 width=342) (actual time=14.273..14.275 rows=1 loops=1)

  • Hash Cond: ((organization_t_2.st_cd)::text = (organization_t.st_cd)::text)
2. 1.774 1.774 ↑ 1.0 56 1

Seq Scan on organization_t organization_t_2 (cost=0.00..57.42 rows=56 width=29) (actual time=0.539..1.774 rows=56 loops=1)

  • Filter: ((org_typ_cd)::text = 'T'::text)
  • Rows Removed by Filter: 1338
3. 0.004 0.056 ↑ 2.0 1 1

Hash (cost=22.39..22.39 rows=2 width=245) (actual time=0.056..0.056 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.001 0.052 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.67..22.39 rows=2 width=245) (actual time=0.050..0.052 rows=1 loops=1)

5. 0.001 0.046 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.39..21.53 rows=2 width=201) (actual time=0.044..0.046 rows=1 loops=1)

6. 0.000 0.041 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.11..20.75 rows=2 width=139) (actual time=0.040..0.041 rows=1 loops=1)

7. 0.001 0.035 ↑ 2.0 1 1

Nested Loop (cost=0.84..20.06 rows=2 width=129) (actual time=0.034..0.035 rows=1 loops=1)

8. 0.001 0.028 ↑ 2.0 1 1

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

9. 0.013 0.013 ↑ 1.0 1 1

Index Scan using ixf02_pin on dcpsuser_t (cost=0.28..8.29 rows=1 width=4) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((pin)::text = '9E2471'::text)
10. 0.014 0.014 ↑ 2.0 1 1

Index Scan using ixf02_useruid on userorganization_t (cost=0.28..11.01 rows=2 width=64) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (user_uid = dcpsuser_t.user_uid)
  • Filter: (eff_endt IS NULL)
11. 0.006 0.006 ↑ 1.0 1 1

Index Scan using ixpk_organization_t on organization_t (cost=0.28..0.37 rows=1 width=69) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (org_uid = userorganization_t.org_uid)
12. 0.006 0.006 ↓ 0.0 0 1

Index Scan using userwkldtrld_t_user_org_uid_idx on userwkldtrld_t (cost=0.28..0.34 rows=1 width=14) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (userorganization_t.user_org_uid = user_org_uid)
13. 0.004 0.004 ↓ 0.0 0 1

Index Scan using ixpk_dcpsuser_t on dcpsuser_t dcpsuser_t_1 (cost=0.28..0.39 rows=1 width=62) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (organization_t.org_ownr_uid = user_uid)
14. 0.005 0.005 ↑ 1.0 1 1

Index Scan using ixpk_organization_t on organization_t organization_t_1 (cost=0.28..0.43 rows=1 width=48) (actual time=0.005..0.005 rows=1 loops=1)

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

SubPlan (forHash Right Join)

16. 0.021 9.663 ↑ 1.0 1 1

Aggregate (cost=457.69..457.70 rows=1 width=32) (actual time=9.663..9.663 rows=1 loops=1)

17. 0.160 9.642 ↓ 4.7 93 1

Sort (cost=457.38..457.43 rows=20 width=20) (actual time=9.638..9.642 rows=93 loops=1)

  • Sort Key: independentpermission_t.prmis_cd
  • Sort Method: quicksort Memory: 29kB
18. 0.042 9.482 ↓ 4.7 93 1

HashAggregate (cost=456.75..456.95 rows=20 width=20) (actual time=9.473..9.482 rows=93 loops=1)

  • Group Key: independentpermission_t.prmis_cd
19. 0.007 9.440 ↓ 4.8 96 1

Append (cost=5.66..456.70 rows=20 width=20) (actual time=2.405..9.440 rows=96 loops=1)

20. 0.001 1.491 ↓ 0.0 0 1

Hash Join (cost=5.66..70.50 rows=3 width=5) (actual time=1.491..1.491 rows=0 loops=1)

  • Hash Cond: ((independentpermission_t.prmis_cd)::text = (permission_t.prmis_cd)::text)
21. 1.490 1.490 ↓ 0.0 0 1

Seq Scan on independentpermission_t (cost=0.00..64.83 rows=4 width=5) (actual time=1.490..1.490 rows=0 loops=1)

  • Filter: (user_org_uid = userorganization_t.user_org_uid)
  • Rows Removed by Filter: 2946
22. 0.000 0.000 ↓ 0.0 0

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

23. 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-13'::date))
24. 0.025 7.942 ↓ 5.6 96 1

Nested Loop (cost=144.71..386.00 rows=17 width=5) (actual time=0.913..7.942 rows=96 loops=1)

  • Join Filter: (organizationrole_t.role_uid = dcpsrole_t.role_uid)
25. 0.907 7.821 ↓ 5.6 96 1

Hash Join (cost=144.43..380.65 rows=17 width=13) (actual time=0.898..7.821 rows=96 loops=1)

  • Hash Cond: (rolepermission_t.role_uid = organizationrole_t.role_uid)
26. 6.484 6.484 ↑ 1.0 10,185 1

Seq Scan on rolepermission_t (cost=0.00..197.85 rows=10,185 width=9) (actual time=0.448..6.484 rows=10,185 loops=1)

27. 0.003 0.430 ↑ 1.0 1 1

Hash (cost=144.42..144.42 rows=1 width=4) (actual time=0.430..0.430 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
28. 0.001 0.427 ↑ 1.0 1 1

Nested Loop (cost=0.28..144.42 rows=1 width=4) (actual time=0.013..0.427 rows=1 loops=1)

29. 0.419 0.419 ↑ 1.0 1 1

Seq Scan on userorganizationrole_t (cost=0.00..135.61 rows=1 width=4) (actual time=0.005..0.419 rows=1 loops=1)

  • Filter: ((eff_strt_ts <= '2019-05-13 12:50:11.851-04'::timestamp with time zone) AND ((eff_end_ts IS NULL) OR (eff_end_ts > '2019-05-13 12:50:11.851-04'::timestamp with time zone)) AND (user_org_uid = userorganization_t.user_org_uid))
  • Rows Removed by Filter: 5005
30. 0.007 0.007 ↑ 1.0 1 1

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

  • 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))
31. 0.096 0.096 ↑ 1.0 1 96

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

  • Index Cond: (role_uid = rolepermission_t.role_uid)
  • Filter: ((eff_strt_ts <= '2019-05-13 12:50:11.851-04'::timestamp with time zone) AND ((eff_end_ts IS NULL) OR (eff_end_ts > '2019-05-13 12:50:11.851-04'::timestamp with time zone)))
32. 0.011 2.758 ↑ 1.0 1 1

Aggregate (cost=12.29..12.30 rows=1 width=32) (actual time=2.758..2.758 rows=1 loops=1)

33. 0.048 2.747 ↓ 1.3 8 1

Sort (cost=12.20..12.21 rows=6 width=11) (actual time=2.746..2.747 rows=8 loops=1)

  • Sort Key: userdshb_t.dflt_dshb_sw DESC, userdshb_t.eff_stdt
  • Sort Method: quicksort Memory: 25kB
34. 2.699 2.699 ↓ 1.3 8 1

Index Scan using ixf01_userdshb_t on userdshb_t (cost=0.29..12.12 rows=6 width=11) (actual time=0.501..2.699 rows=8 loops=1)

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