explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Utcy

Settings
# exclusive inclusive rows x rows loops node
1. 1.164 91,908.164 ↑ 1.0 1 1

Aggregate (cost=19,409,903.20..19,409,903.21 rows=1 width=8) (actual time=91,908.164..91,908.164 rows=1 loops=1)

2. 407.322 91,907.000 ↑ 51.9 951 1

Index Scan using t12227_accountfact_2397_ptimestamp on t12227_accountfact (cost=0.29..19,409,779.75 rows=49,380 width=4) (actual time=23.728..91,907.000 rows=951 loops=1)

  • Filter: ((NOT deleted) AND ((SubPlan 5) OR (SubPlan 10) OR (SubPlan 15) OR (SubPlan 20) OR (SubPlan 25) OR (SubPlan 30)))
  • Rows Removed by Filter: 60,204
3.          

SubPlan (for Index Scan)

4. 42,739.390 42,748.860 ↓ 0.0 0 37,012

Index Scan using idx_8128_t12247_emailactivityaccountfact_c66673_activitydate_st on t12247_emailactivityaccountfact (cost=0.42..41.13 rows=1 width=0) (actual time=1.155..1.155 rows=0 loops=37,012)

  • Index Cond: ((c66673_activitydate >= '1602226800000'::bigint) AND (c66673_activitydate < '1602918000000'::bigint) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (NOT c66624_isinternalinitiated) AND (c66670_accountid = t12227_accountfact.sid) AND ((alternatives: SubPlan 1 or hashed SubPlan 2) OR (alternatives: SubPlan 3 or hashed SubPlan 4)))
  • Rows Removed by Filter: 2,139
5.          

SubPlan (for Index Scan)

6. 1.750 9.464 ↑ 1.0 1 169

Hash Join (cost=16.91..24.38 rows=1 width=0) (actual time=0.056..0.056 rows=1 loops=169)

  • Hash Cond: (t9123_userroledim.sid = t10977_userrolehierarchy.c61341_user_role_id)
7. 5.010 5.010 ↑ 1.7 29 167

Seq Scan on t9123_userroledim (cost=0.00..7.28 rows=50 width=4) (actual time=0.004..0.030 rows=29 loops=167)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c54405_portaltype IS NULL) OR (c54405_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
  • Rows Removed by Filter: 50
8. 1.014 2.704 ↑ 1.0 1 169

Hash (cost=16.89..16.89 rows=1 width=4) (actual time=0.016..0.016 rows=1 loops=169)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 1.690 1.690 ↑ 1.0 1 169

Index Scan using idx_6301_t10977_userrolehierarchy_sid_c61342_ancestor_role_id_e on t10977_userrolehierarchy (cost=0.28..16.89 rows=1 width=4) (actual time=0.008..0.010 rows=1 loops=169)

  • Index Cond: ((sid = t12247_emailactivityaccountfact.c66665_activityownersfuserid) AND (c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
10. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=24.84..99.46 rows=478 width=4) (never executed)

  • Hash Cond: (t10977_userrolehierarchy_1.c61341_user_role_id = t9123_userroledim_1.sid)
11. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t10977_userrolehierarchy t10977_userrolehierarchy_1 (cost=16.94..90.40 rows=398 width=8) (never executed)

  • Recheck Cond: ((c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
12. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_6300_t10977_userrolehierarchy_c61342_ancestor_role_id_end_s (cost=0.00..16.84 rows=398 width=0) (never executed)

  • Index Cond: ((c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
13. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.28..7.28 rows=50 width=4) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on t9123_userroledim t9123_userroledim_1 (cost=0.00..7.28 rows=50 width=4) (never executed)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c54405_portaltype IS NULL) OR (c54405_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
15. 0.006 0.006 ↓ 0.0 0 2

Index Scan using t9120_userdim_sidendstampunique on t9120_userdim (cost=0.28..8.30 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=2)

  • Index Cond: ((sid = t12247_emailactivityaccountfact.c66665_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c54370_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c54396_usertype = 'Standard'::text))
16. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t9120_userdim t9120_userdim_1 (cost=4.99..53.08 rows=69 width=4) (never executed)

  • Recheck Cond: ((c54370_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND (c54396_usertype = 'Standard'::text))
17. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_4430_t9120_userdim_c54370_userroleid_end_stamp_start_stamp_ (cost=0.00..4.98 rows=70 width=0) (never executed)

  • Index Cond: ((c54370_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
18. 94.683 110.535 ↓ 0.0 0 36,845

Index Scan using t12298_meetingactivityaccountfact_2476_ptimestamp on t12298_meetingactivityaccountfact (cost=0.28..77.69 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=36,845)

  • Index Cond: (c67681_accountid = t12227_accountfact.sid)
  • Filter: ((NOT deleted) AND c67687_isshared AND (c67683_activitydate >= '1602226800000'::bigint) AND (c67683_activitydate < '1602918000000'::bigint) AND ((alternatives: SubPlan 6 or hashed SubPlan 7) OR (alternatives: SubPlan 8 or hashed SubPlan 9)))
  • Rows Removed by Filter: 0
19.          

SubPlan (for Index Scan)

20. 3.032 15.840 ↑ 1.0 1 264

Hash Join (cost=16.91..24.38 rows=1 width=0) (actual time=0.060..0.060 rows=1 loops=264)

  • Hash Cond: (t9123_userroledim_2.sid = t10977_userrolehierarchy_2.c61341_user_role_id)
21. 8.320 8.320 ↑ 1.4 35 260

Seq Scan on t9123_userroledim t9123_userroledim_2 (cost=0.00..7.28 rows=50 width=4) (actual time=0.004..0.032 rows=35 loops=260)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c54405_portaltype IS NULL) OR (c54405_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
  • Rows Removed by Filter: 63
22. 1.848 4.488 ↑ 1.0 1 264

Hash (cost=16.89..16.89 rows=1 width=4) (actual time=0.017..0.017 rows=1 loops=264)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
23. 2.640 2.640 ↑ 1.0 1 264

Index Scan using idx_6301_t10977_userrolehierarchy_sid_c61342_ancestor_role_id_e on t10977_userrolehierarchy t10977_userrolehierarchy_2 (cost=0.28..16.89 rows=1 width=4) (actual time=0.008..0.010 rows=1 loops=264)

  • Index Cond: ((sid = t12298_meetingactivityaccountfact.c67678_activityownersfuserid) AND (c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
24. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=24.84..99.46 rows=478 width=4) (never executed)

  • Hash Cond: (t10977_userrolehierarchy_3.c61341_user_role_id = t9123_userroledim_3.sid)
25. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t10977_userrolehierarchy t10977_userrolehierarchy_3 (cost=16.94..90.40 rows=398 width=8) (never executed)

  • Recheck Cond: ((c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
26. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_6300_t10977_userrolehierarchy_c61342_ancestor_role_id_end_s (cost=0.00..16.84 rows=398 width=0) (never executed)

  • Index Cond: ((c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
27. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.28..7.28 rows=50 width=4) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Seq Scan on t9123_userroledim t9123_userroledim_3 (cost=0.00..7.28 rows=50 width=4) (never executed)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c54405_portaltype IS NULL) OR (c54405_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
29. 0.012 0.012 ↓ 0.0 0 4

Index Scan using t9120_userdim_sidendstampunique on t9120_userdim t9120_userdim_2 (cost=0.28..8.30 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=4)

  • Index Cond: ((sid = t12298_meetingactivityaccountfact.c67678_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c54370_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c54396_usertype = 'Standard'::text))
30. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t9120_userdim t9120_userdim_3 (cost=4.99..53.08 rows=69 width=4) (never executed)

  • Recheck Cond: ((c54370_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND (c54396_usertype = 'Standard'::text))
31. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_4430_t9120_userdim_c54370_userroleid_end_stamp_start_stamp_ (cost=0.00..4.98 rows=70 width=0) (never executed)

  • Index Cond: ((c54370_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
32. 42,690.520 42,694.695 ↓ 0.0 0 36,585

Index Scan using idx_8128_t12247_emailactivityaccountfact_c66673_activitydate_st on t12247_emailactivityaccountfact t12247_emailactivityaccountfact_1 (cost=0.42..41.13 rows=1 width=0) (actual time=1.167..1.167 rows=0 loops=36,585)

  • Index Cond: ((c66673_activitydate >= '1602226800000'::bigint) AND (c66673_activitydate < '1602918000000'::bigint) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND c66624_isinternalinitiated AND (c66670_accountid = t12227_accountfact.sid) AND ((alternatives: SubPlan 11 or hashed SubPlan 12) OR (alternatives: SubPlan 13 or hashed SubPlan 14)))
  • Rows Removed by Filter: 2,141
33.          

SubPlan (for Index Scan)

34. 1.128 4.175 ↑ 1.0 1 167

Hash Join (cost=16.91..24.38 rows=1 width=0) (actual time=0.025..0.025 rows=1 loops=167)

  • Hash Cond: (t9123_userroledim_4.sid = t10977_userrolehierarchy_4.c61341_user_role_id)
35. 1.210 1.210 ↑ 4.5 11 110

Seq Scan on t9123_userroledim t9123_userroledim_4 (cost=0.00..7.28 rows=50 width=4) (actual time=0.004..0.011 rows=11 loops=110)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c54405_portaltype IS NULL) OR (c54405_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
  • Rows Removed by Filter: 16
36. 0.668 1.837 ↑ 1.0 1 167

Hash (cost=16.89..16.89 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=167)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
37. 1.169 1.169 ↑ 1.0 1 167

Index Scan using idx_6301_t10977_userrolehierarchy_sid_c61342_ancestor_role_id_e on t10977_userrolehierarchy t10977_userrolehierarchy_4 (cost=0.28..16.89 rows=1 width=4) (actual time=0.005..0.007 rows=1 loops=167)

  • Index Cond: ((sid = t12247_emailactivityaccountfact_1.c66665_activityownersfuserid) AND (c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
38. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=24.84..99.46 rows=478 width=4) (never executed)

  • Hash Cond: (t10977_userrolehierarchy_5.c61341_user_role_id = t9123_userroledim_5.sid)
39. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t10977_userrolehierarchy t10977_userrolehierarchy_5 (cost=16.94..90.40 rows=398 width=8) (never executed)

  • Recheck Cond: ((c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
40. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_6300_t10977_userrolehierarchy_c61342_ancestor_role_id_end_s (cost=0.00..16.84 rows=398 width=0) (never executed)

  • Index Cond: ((c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
41. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.28..7.28 rows=50 width=4) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Seq Scan on t9123_userroledim t9123_userroledim_5 (cost=0.00..7.28 rows=50 width=4) (never executed)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c54405_portaltype IS NULL) OR (c54405_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
43. 0.000 0.000 ↓ 0.0 0 58

Index Scan using t9120_userdim_sidendstampunique on t9120_userdim t9120_userdim_4 (cost=0.28..8.30 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=58)

  • Index Cond: ((sid = t12247_emailactivityaccountfact_1.c66665_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c54370_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c54396_usertype = 'Standard'::text))
44. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t9120_userdim t9120_userdim_5 (cost=4.99..53.08 rows=69 width=4) (never executed)

  • Recheck Cond: ((c54370_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND (c54396_usertype = 'Standard'::text))
45. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_4430_t9120_userdim_c54370_userroleid_end_stamp_start_stamp_ (cost=0.00..4.98 rows=70 width=0) (never executed)

  • Index Cond: ((c54370_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
46. 2,954.556 2,954.556 ↓ 0.0 0 36,476

Index Scan using idx_8112_t12246_fileactivityaccountfact_c66659_activitydate_sta on t12246_fileactivityaccountfact (cost=0.28..40.99 rows=1 width=0) (actual time=0.081..0.081 rows=0 loops=36,476)

  • Index Cond: ((c66659_activitydate >= '1602226800000'::bigint) AND (c66659_activitydate < '1602918000000'::bigint) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (NOT c66617_isinternalinitiated) AND (c66656_accountid = t12227_accountfact.sid) AND ((alternatives: SubPlan 16 or hashed SubPlan 17) OR (alternatives: SubPlan 18 or hashed SubPlan 19)))
  • Rows Removed by Filter: 142
47.          

SubPlan (for Index Scan)

48. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=16.91..24.38 rows=1 width=0) (never executed)

  • Hash Cond: (t9123_userroledim_6.sid = t10977_userrolehierarchy_6.c61341_user_role_id)
49. 0.000 0.000 ↓ 0.0 0

Seq Scan on t9123_userroledim t9123_userroledim_6 (cost=0.00..7.28 rows=50 width=4) (never executed)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c54405_portaltype IS NULL) OR (c54405_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
50. 0.000 0.000 ↓ 0.0 0

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

51. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_6301_t10977_userrolehierarchy_sid_c61342_ancestor_role_id_e on t10977_userrolehierarchy t10977_userrolehierarchy_6 (cost=0.28..16.89 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t12246_fileactivityaccountfact.c66669_activityownersfuserid) AND (c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
52. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=24.84..99.46 rows=478 width=4) (never executed)

  • Hash Cond: (t10977_userrolehierarchy_7.c61341_user_role_id = t9123_userroledim_7.sid)
53. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t10977_userrolehierarchy t10977_userrolehierarchy_7 (cost=16.94..90.40 rows=398 width=8) (never executed)

  • Recheck Cond: ((c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
54. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_6300_t10977_userrolehierarchy_c61342_ancestor_role_id_end_s (cost=0.00..16.84 rows=398 width=0) (never executed)

  • Index Cond: ((c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
55. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.28..7.28 rows=50 width=4) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Seq Scan on t9123_userroledim t9123_userroledim_7 (cost=0.00..7.28 rows=50 width=4) (never executed)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c54405_portaltype IS NULL) OR (c54405_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
57. 0.000 0.000 ↓ 0.0 0

Index Scan using t9120_userdim_sidendstampunique on t9120_userdim t9120_userdim_6 (cost=0.28..8.30 rows=1 width=0) (never executed)

  • Index Cond: ((sid = t12246_fileactivityaccountfact.c66669_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c54370_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c54396_usertype = 'Standard'::text))
58. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t9120_userdim t9120_userdim_7 (cost=4.99..53.08 rows=69 width=4) (never executed)

  • Recheck Cond: ((c54370_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND (c54396_usertype = 'Standard'::text))
59. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_4430_t9120_userdim_c54370_userroleid_end_stamp_start_stamp_ (cost=0.00..4.98 rows=70 width=0) (never executed)

  • Index Cond: ((c54370_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
60. 2,881.604 2,881.604 ↓ 0.0 0 36,476

Index Scan using idx_8112_t12246_fileactivityaccountfact_c66659_activitydate_sta on t12246_fileactivityaccountfact t12246_fileactivityaccountfact_1 (cost=0.28..40.99 rows=1 width=0) (actual time=0.079..0.079 rows=0 loops=36,476)

  • Index Cond: ((c66659_activitydate >= '1602226800000'::bigint) AND (c66659_activitydate < '1602918000000'::bigint) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND c66617_isinternalinitiated AND (c66656_accountid = t12227_accountfact.sid) AND ((alternatives: SubPlan 21 or hashed SubPlan 22) OR (alternatives: SubPlan 23 or hashed SubPlan 24)))
  • Rows Removed by Filter: 142
61.          

SubPlan (for Index Scan)

62. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=16.91..24.38 rows=1 width=0) (never executed)

  • Hash Cond: (t9123_userroledim_8.sid = t10977_userrolehierarchy_8.c61341_user_role_id)
63. 0.000 0.000 ↓ 0.0 0

Seq Scan on t9123_userroledim t9123_userroledim_8 (cost=0.00..7.28 rows=50 width=4) (never executed)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c54405_portaltype IS NULL) OR (c54405_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
64. 0.000 0.000 ↓ 0.0 0

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

65. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_6301_t10977_userrolehierarchy_sid_c61342_ancestor_role_id_e on t10977_userrolehierarchy t10977_userrolehierarchy_8 (cost=0.28..16.89 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t12246_fileactivityaccountfact_1.c66669_activityownersfuserid) AND (c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
66. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=24.84..99.46 rows=478 width=4) (never executed)

  • Hash Cond: (t10977_userrolehierarchy_9.c61341_user_role_id = t9123_userroledim_9.sid)
67. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t10977_userrolehierarchy t10977_userrolehierarchy_9 (cost=16.94..90.40 rows=398 width=8) (never executed)

  • Recheck Cond: ((c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
68. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_6300_t10977_userrolehierarchy_c61342_ancestor_role_id_end_s (cost=0.00..16.84 rows=398 width=0) (never executed)

  • Index Cond: ((c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
69. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.28..7.28 rows=50 width=4) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Seq Scan on t9123_userroledim t9123_userroledim_9 (cost=0.00..7.28 rows=50 width=4) (never executed)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c54405_portaltype IS NULL) OR (c54405_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
71. 0.000 0.000 ↓ 0.0 0

Index Scan using t9120_userdim_sidendstampunique on t9120_userdim t9120_userdim_8 (cost=0.28..8.30 rows=1 width=0) (never executed)

  • Index Cond: ((sid = t12246_fileactivityaccountfact_1.c66669_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c54370_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c54396_usertype = 'Standard'::text))
72. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t9120_userdim t9120_userdim_9 (cost=4.99..53.08 rows=69 width=4) (never executed)

  • Recheck Cond: ((c54370_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND (c54396_usertype = 'Standard'::text))
73. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_4430_t9120_userdim_c54370_userroleid_end_stamp_start_stamp_ (cost=0.00..4.98 rows=70 width=0) (never executed)

  • Index Cond: ((c54370_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
74. 83.283 109.428 ↓ 0.0 0 36,476

Index Scan using t12298_meetingactivityaccountfact_2476_ptimestamp on t12298_meetingactivityaccountfact t12298_meetingactivityaccountfact_1 (cost=0.28..77.69 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=36,476)

  • Index Cond: (c67681_accountid = t12227_accountfact.sid)
  • Filter: ((NOT deleted) AND c67687_isshared AND (c67683_activitydate >= '1602918000000'::bigint) AND (c67683_activitydate < '1605513600000'::bigint) AND ((alternatives: SubPlan 26 or hashed SubPlan 27) OR (alternatives: SubPlan 28 or hashed SubPlan 29)))
  • Rows Removed by Filter: 0
75.          

SubPlan (for Index Scan)

76. 4.980 26.145 ↑ 1.0 1 415

Hash Join (cost=16.91..24.38 rows=1 width=0) (actual time=0.063..0.063 rows=1 loops=415)

  • Hash Cond: (t9123_userroledim_10.sid = t10977_userrolehierarchy_10.c61341_user_role_id)
77. 13.695 13.695 ↑ 1.6 31 415

Seq Scan on t9123_userroledim t9123_userroledim_10 (cost=0.00..7.28 rows=50 width=4) (actual time=0.005..0.033 rows=31 loops=415)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c54405_portaltype IS NULL) OR (c54405_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
  • Rows Removed by Filter: 53
78. 2.905 7.470 ↑ 1.0 1 415

Hash (cost=16.89..16.89 rows=1 width=4) (actual time=0.018..0.018 rows=1 loops=415)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
79. 4.565 4.565 ↑ 1.0 1 415

Index Scan using idx_6301_t10977_userrolehierarchy_sid_c61342_ancestor_role_id_e on t10977_userrolehierarchy t10977_userrolehierarchy_10 (cost=0.28..16.89 rows=1 width=4) (actual time=0.008..0.011 rows=1 loops=415)

  • Index Cond: ((sid = t12298_meetingactivityaccountfact_1.c67678_activityownersfuserid) AND (c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
80. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=24.84..99.46 rows=478 width=4) (never executed)

  • Hash Cond: (t10977_userrolehierarchy_11.c61341_user_role_id = t9123_userroledim_11.sid)
81. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t10977_userrolehierarchy t10977_userrolehierarchy_11 (cost=16.94..90.40 rows=398 width=8) (never executed)

  • Recheck Cond: ((c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
82. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_6300_t10977_userrolehierarchy_c61342_ancestor_role_id_end_s (cost=0.00..16.84 rows=398 width=0) (never executed)

  • Index Cond: ((c61342_ancestor_role_id = ANY ('{661,5,13}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
83. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.28..7.28 rows=50 width=4) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Seq Scan on t9123_userroledim t9123_userroledim_11 (cost=0.00..7.28 rows=50 width=4) (never executed)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c54405_portaltype IS NULL) OR (c54405_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
85. 0.000 0.000 ↓ 0.0 0

Index Scan using t9120_userdim_sidendstampunique on t9120_userdim t9120_userdim_10 (cost=0.28..8.30 rows=1 width=0) (never executed)

  • Index Cond: ((sid = t12298_meetingactivityaccountfact_1.c67678_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c54370_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c54396_usertype = 'Standard'::text))
86. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t9120_userdim t9120_userdim_11 (cost=4.99..53.08 rows=69 width=4) (never executed)

  • Recheck Cond: ((c54370_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND (c54396_usertype = 'Standard'::text))
87. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_4430_t9120_userdim_c54370_userroleid_end_stamp_start_stamp_ (cost=0.00..4.98 rows=70 width=0) (never executed)

  • Index Cond: ((c54370_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
Planning time : 10.620 ms
Execution time : 91,916.778 ms