explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LyPE

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 3,809.452 ↑ 1.0 40 1

Limit (cost=197,638,406.34..197,638,406.44 rows=40 width=40) (actual time=3,809.447..3,809.452 rows=40 loops=1)

2. 0.430 3,809.448 ↑ 1,582.0 40 1

Sort (cost=197,638,406.34..197,638,564.54 rows=63,278 width=40) (actual time=3,809.446..3,809.448 rows=40 loops=1)

  • Sort Key: t2268_accountdim.c8860_name
  • Sort Method: top-N heapsort Memory: 30kB
3. 0.482 3,809.018 ↑ 148.2 427 1

Nested Loop (cost=144,107,975.27..197,636,406.15 rows=63,278 width=40) (actual time=3,285.635..3,809.018 rows=427 loops=1)

4. 1.157 3,806.401 ↑ 103.3 427 1

Merge Anti Join (cost=144,107,974.85..197,415,218.81 rows=44,124 width=4) (actual time=3,285.613..3,806.401 rows=427 loops=1)

  • Merge Cond: (t1401_accountfact.sid = t2608_emailactivityaccountfact_copy_sentha.c9638_accountid)
5. 61.980 337.199 ↑ 12.0 3,772 1

Index Scan using idx_933_t1401_accountfact_sid_end_stamp_start_stamp_null on t1401_accountfact (cost=0.42..53,288,167.19 rows=45,175 width=4) (actual time=105.933..337.199 rows=3,772 loops=1)

  • Index Cond: ((end_stamp > '1593173652000'::bigint) AND (start_stamp <= '1593173652000'::bigint))
  • Filter: ((NOT deleted) AND ((alternatives: SubPlan 5 or hashed SubPlan 10) OR (alternatives: SubPlan 15 or hashed SubPlan 20) OR (alternatives: SubPlan 25 or hashed SubPlan 30)))
  • Rows Removed by Filter: 55,820
6.          

SubPlan (for Index Scan)

7. 0.000 0.000 ↓ 0.0 0

Subquery Scan on account_activity_count_meeting_current (cost=0.42..1,686.58 rows=31 width=0) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Unique (cost=0.42..1,686.27 rows=31 width=4) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_1992_t2273_meetingactivityaccountfact_c9010_accountid_end_s on t2273_meetingactivityaccountfact (cost=0.42..1,686.27 rows=31 width=4) (never executed)

  • Index Cond: ((c9010_accountid = t1401_accountfact.sid) AND (end_stamp > '1593173652000'::bigint) AND (start_stamp <= '1593173652000'::bigint))
  • Filter: ((NOT deleted) AND c8998_isshared AND (c8986_activitydate >= '1561532400000'::bigint) AND (c8986_activitydate < '1593241200000'::bigint) AND ((alternatives: SubPlan 1 or hashed SubPlan 2) OR (alternatives: SubPlan 3 or hashed SubPlan 4)))
10.          

SubPlan (for Index Scan)

11. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.32..15.78 rows=1 width=0) (never executed)

  • Hash Cond: (t859_userroledim.sid = t786_userrolehierarchy.c4812_user_role_id)
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on t859_userroledim (cost=0.00..7.35 rows=29 width=4) (never executed)

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

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

14. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_37_t786_userrolehierarchy_sid_c4815_ancestor_role_id_end_st on t786_userrolehierarchy (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t2273_meetingactivityaccountfact.c9004_activityownersfuserid) AND (c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
15. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=23.72..97.23 rows=246 width=4) (never executed)

  • Hash Cond: (t786_userrolehierarchy_1.c4812_user_role_id = t859_userroledim_1.sid)
16. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t786_userrolehierarchy t786_userrolehierarchy_1 (cost=16.01..88.47 rows=364 width=8) (never executed)

  • Recheck Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
17. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_35_t786_userrolehierarchy_c4815_ancestor_role_id_end_stamp_ (cost=0.00..15.92 rows=364 width=0) (never executed)

  • Index Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
18. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.35..7.35 rows=29 width=4) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on t859_userroledim t859_userroledim_1 (cost=0.00..7.35 rows=29 width=4) (never executed)

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

Index Scan using idx_14_t773_userdim_sid_end_stamp_start_stamp_null on t773_userdim (cost=0.28..8.30 rows=1 width=0) (never executed)

  • Index Cond: ((sid = t2273_meetingactivityaccountfact.c9004_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c4570_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
21. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t773_userdim t773_userdim_1 (cost=4.98..53.05 rows=68 width=4) (never executed)

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

Bitmap Index Scan on idx_15_t773_userdim_c4570_userroleid_end_stamp_start_stamp_null (cost=0.00..4.97 rows=69 width=0) (never executed)

  • Index Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
23. 3.875 99.664 ↓ 1.1 1,861 1

Unique (cost=1,731,261.89..1,731,527.63 rows=1,710 width=4) (actual time=90.544..99.664 rows=1,861 loops=1)

24. 37.728 95.789 ↓ 1.3 67,811 1

Sort (cost=1,731,261.89..1,731,394.76 rows=53,149 width=4) (actual time=90.543..95.789 rows=67,811 loops=1)

  • Sort Key: t2273_meetingactivityaccountfact_1.c9010_accountid
  • Sort Method: external merge Disk: 936kB
25. 57.736 58.061 ↓ 1.3 67,811 1

Index Scan using "idx_activitydate_issharedp_del_P_sentha" on t2273_meetingactivityaccountfact t2273_meetingactivityaccountfact_1 (cost=0.42..1,727,090.29 rows=53,149 width=4) (actual time=0.348..58.061 rows=67,811 loops=1)

  • Index Cond: ((c8986_activitydate >= '1561532400000'::bigint) AND (c8986_activitydate < '1593241200000'::bigint) AND (end_stamp > '1593173652000'::bigint) AND (start_stamp <= '1593173652000'::bigint))
  • Filter: ((alternatives: SubPlan 6 or hashed SubPlan 7) OR (alternatives: SubPlan 8 or hashed SubPlan 9))
  • Rows Removed by Filter: 6,979
26.          

SubPlan (for Index Scan)

27. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.32..15.78 rows=1 width=0) (never executed)

  • Hash Cond: (t859_userroledim_2.sid = t786_userrolehierarchy_2.c4812_user_role_id)
28. 0.000 0.000 ↓ 0.0 0

Seq Scan on t859_userroledim t859_userroledim_2 (cost=0.00..7.35 rows=29 width=4) (never executed)

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

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

30. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_37_t786_userrolehierarchy_sid_c4815_ancestor_role_id_end_st on t786_userrolehierarchy t786_userrolehierarchy_2 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t2273_meetingactivityaccountfact_1.c9004_activityownersfuserid) AND (c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
31. 0.086 0.272 ↓ 1.5 359 1

Hash Join (cost=23.72..97.23 rows=246 width=4) (actual time=0.097..0.272 rows=359 loops=1)

  • Hash Cond: (t786_userrolehierarchy_3.c4812_user_role_id = t859_userroledim_3.sid)
32. 0.110 0.144 ↑ 1.0 359 1

Bitmap Heap Scan on t786_userrolehierarchy t786_userrolehierarchy_3 (cost=16.01..88.47 rows=364 width=8) (actual time=0.046..0.144 rows=359 loops=1)

  • Recheck Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=62
33. 0.034 0.034 ↑ 1.0 359 1

Bitmap Index Scan on idx_35_t786_userrolehierarchy_c4815_ancestor_role_id_end_stamp_ (cost=0.00..15.92 rows=364 width=0) (actual time=0.034..0.034 rows=359 loops=1)

  • Index Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
34. 0.007 0.042 ↓ 1.5 44 1

Hash (cost=7.35..7.35 rows=29 width=4) (actual time=0.042..0.042 rows=44 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
35. 0.035 0.035 ↓ 1.5 44 1

Seq Scan on t859_userroledim t859_userroledim_3 (cost=0.00..7.35 rows=29 width=4) (actual time=0.004..0.035 rows=44 loops=1)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c4994_portaltype IS NULL) OR (c4994_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
  • Rows Removed by Filter: 84
36. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_14_t773_userdim_sid_end_stamp_start_stamp_null on t773_userdim t773_userdim_2 (cost=0.28..8.30 rows=1 width=0) (never executed)

  • Index Cond: ((sid = t2273_meetingactivityaccountfact_1.c9004_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c4570_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
37. 0.037 0.053 ↑ 2.5 27 1

Bitmap Heap Scan on t773_userdim t773_userdim_3 (cost=4.98..53.05 rows=68 width=4) (actual time=0.024..0.053 rows=27 loops=1)

  • Recheck Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
  • Rows Removed by Filter: 9
  • Heap Blocks: exact=23
38. 0.016 0.016 ↑ 1.9 36 1

Bitmap Index Scan on idx_15_t773_userdim_c4570_userroleid_end_stamp_start_stamp_null (cost=0.00..4.97 rows=69 width=0) (actual time=0.016..0.016 rows=36 loops=1)

  • Index Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
39. 0.000 170.395 ↓ 0.0 0 34,079

Subquery Scan on emailsentsubquery (cost=0.56..259,654.37 rows=1,030 width=0) (actual time=0.005..0.005 rows=0 loops=34,079)

40. 34.079 170.395 ↓ 0.0 0 34,079

Unique (cost=0.56..259,644.07 rows=1,030 width=4) (actual time=0.005..0.005 rows=0 loops=34,079)

41. 135.986 136.316 ↓ 0.0 0 34,079

Index Scan using idx_2185_t2608_emailactivityaccountfact_copy_sentha_c9638_accou on t2608_emailactivityaccountfact_copy_sentha t2608_emailactivityaccountfact_copy_sentha_1 (cost=0.56..259,644.07 rows=2,316 width=4) (actual time=0.004..0.004 rows=0 loops=34,079)

  • Index Cond: ((c9638_accountid = t1401_accountfact.sid) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint))
  • Filter: ((NOT deleted) AND (NOT c9660_isinternalinitiated) AND c9657_isshared AND (c9653_activitydate >= '1561532400000'::bigint) AND (c9653_activitydate < '1593241200000'::bigint) AND ((alternatives: SubPlan 11 or hashed SubPlan 12) OR (alternatives: SubPlan 13 or hashed SubPlan 14)))
  • Rows Removed by Filter: 3
42.          

SubPlan (for Index Scan)

43. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.32..15.78 rows=1 width=0) (never executed)

  • Hash Cond: (t859_userroledim_4.sid = t786_userrolehierarchy_4.c4812_user_role_id)
44. 0.000 0.000 ↓ 0.0 0

Seq Scan on t859_userroledim t859_userroledim_4 (cost=0.00..7.35 rows=29 width=4) (never executed)

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

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

46. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_37_t786_userrolehierarchy_sid_c4815_ancestor_role_id_end_st on t786_userrolehierarchy t786_userrolehierarchy_4 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t2608_emailactivityaccountfact_copy_sentha_1.c9662_activityownersfuserid) AND (c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
47. 0.092 0.278 ↓ 1.5 359 1

Hash Join (cost=23.72..97.23 rows=246 width=4) (actual time=0.099..0.278 rows=359 loops=1)

  • Hash Cond: (t786_userrolehierarchy_5.c4812_user_role_id = t859_userroledim_5.sid)
48. 0.111 0.142 ↑ 1.0 359 1

Bitmap Heap Scan on t786_userrolehierarchy t786_userrolehierarchy_5 (cost=16.01..88.47 rows=364 width=8) (actual time=0.045..0.142 rows=359 loops=1)

  • Recheck Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=62
49. 0.031 0.031 ↑ 1.0 359 1

Bitmap Index Scan on idx_35_t786_userrolehierarchy_c4815_ancestor_role_id_end_stamp_ (cost=0.00..15.92 rows=364 width=0) (actual time=0.031..0.031 rows=359 loops=1)

  • Index Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
50. 0.007 0.044 ↓ 1.5 44 1

Hash (cost=7.35..7.35 rows=29 width=4) (actual time=0.044..0.044 rows=44 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
51. 0.037 0.037 ↓ 1.5 44 1

Seq Scan on t859_userroledim t859_userroledim_5 (cost=0.00..7.35 rows=29 width=4) (actual time=0.006..0.037 rows=44 loops=1)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c4994_portaltype IS NULL) OR (c4994_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
  • Rows Removed by Filter: 84
52. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_14_t773_userdim_sid_end_stamp_start_stamp_null on t773_userdim t773_userdim_4 (cost=0.28..8.30 rows=1 width=0) (never executed)

  • Index Cond: ((sid = t2608_emailactivityaccountfact_copy_sentha_1.c9662_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c4570_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
53. 0.039 0.052 ↑ 2.5 27 1

Bitmap Heap Scan on t773_userdim t773_userdim_5 (cost=4.98..53.05 rows=68 width=4) (actual time=0.022..0.052 rows=27 loops=1)

  • Recheck Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
  • Rows Removed by Filter: 9
  • Heap Blocks: exact=23
54. 0.013 0.013 ↑ 1.9 36 1

Bitmap Index Scan on idx_15_t773_userdim_c4570_userroleid_end_stamp_start_stamp_null (cost=0.00..4.97 rows=69 width=0) (actual time=0.013..0.013 rows=36 loops=1)

  • Index Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
55. 0.000 0.000 ↓ 0.0 0

Unique (cost=106,778,929.94..106,792,916.61 rows=1,208 width=4) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Sort (cost=106,778,929.94..106,785,923.28 rows=2,797,335 width=4) (never executed)

  • Sort Key: t2608_emailactivityaccountfact_copy_sentha_2.c9638_accountid
57. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_isinternal_sentha1 on t2608_emailactivityaccountfact_copy_sentha t2608_emailactivityaccountfact_copy_sentha_2 (cost=0.56..106,402,900.60 rows=2,797,335 width=4) (never executed)

  • Index Cond: ((c9660_isinternalinitiated = false) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint))
  • Filter: ((NOT c9660_isinternalinitiated) AND (c9653_activitydate >= '1561532400000'::bigint) AND (c9653_activitydate < '1593241200000'::bigint) AND ((alternatives: SubPlan 16 or hashed SubPlan 17) OR (alternatives: SubPlan 18 or hashed SubPlan 19)))
58.          

SubPlan (for Index Scan)

59. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.32..15.78 rows=1 width=0) (never executed)

  • Hash Cond: (t859_userroledim_6.sid = t786_userrolehierarchy_6.c4812_user_role_id)
60. 0.000 0.000 ↓ 0.0 0

Seq Scan on t859_userroledim t859_userroledim_6 (cost=0.00..7.35 rows=29 width=4) (never executed)

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

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

62. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_37_t786_userrolehierarchy_sid_c4815_ancestor_role_id_end_st on t786_userrolehierarchy t786_userrolehierarchy_6 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t2608_emailactivityaccountfact_copy_sentha_2.c9662_activityownersfuserid) AND (c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
63. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=23.72..97.23 rows=246 width=4) (never executed)

  • Hash Cond: (t786_userrolehierarchy_7.c4812_user_role_id = t859_userroledim_7.sid)
64. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t786_userrolehierarchy t786_userrolehierarchy_7 (cost=16.01..88.47 rows=364 width=8) (never executed)

  • Recheck Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
65. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_35_t786_userrolehierarchy_c4815_ancestor_role_id_end_stamp_ (cost=0.00..15.92 rows=364 width=0) (never executed)

  • Index Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
66. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.35..7.35 rows=29 width=4) (never executed)

67. 0.000 0.000 ↓ 0.0 0

Seq Scan on t859_userroledim t859_userroledim_7 (cost=0.00..7.35 rows=29 width=4) (never executed)

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

Index Scan using idx_14_t773_userdim_sid_end_stamp_start_stamp_null on t773_userdim t773_userdim_6 (cost=0.28..8.30 rows=1 width=0) (never executed)

  • Index Cond: ((sid = t2608_emailactivityaccountfact_copy_sentha_2.c9662_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c4570_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
69. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t773_userdim t773_userdim_7 (cost=4.98..53.05 rows=68 width=4) (never executed)

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

Bitmap Index Scan on idx_15_t773_userdim_c4570_userroleid_end_stamp_start_stamp_null (cost=0.00..4.97 rows=69 width=0) (never executed)

  • Index Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
71. 0.000 0.000 ↓ 0.0 0

Subquery Scan on account_activity_count_meeting_current_1 (cost=5.67..1,669.60 rows=3 width=0) (never executed)

72. 0.000 0.000 ↓ 0.0 0

Unique (cost=5.67..1,669.57 rows=3 width=4) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t2273_meetingactivityaccountfact t2273_meetingactivityaccountfact_2 (cost=5.67..1,669.57 rows=3 width=4) (never executed)

  • Recheck Cond: ((c9010_accountid = t1401_accountfact.sid) AND (end_stamp > '1593173652000'::bigint) AND (start_stamp <= '1593173652000'::bigint))
  • Filter: ((NOT deleted) AND c8998_isshared AND (c8986_activitydate >= '1593241200000'::bigint) AND (c8986_activitydate < '1595833200000'::bigint) AND ((alternatives: SubPlan 21 or hashed SubPlan 22) OR (alternatives: SubPlan 23 or hashed SubPlan 24)))
74. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_1992_t2273_meetingactivityaccountfact_c9010_accountid_end_s (cost=0.00..5.67 rows=60 width=0) (never executed)

  • Index Cond: ((c9010_accountid = t1401_accountfact.sid) AND (end_stamp > '1593173652000'::bigint) AND (start_stamp <= '1593173652000'::bigint))
75.          

SubPlan (for Bitmap Heap Scan)

76. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.32..15.78 rows=1 width=0) (never executed)

  • Hash Cond: (t859_userroledim_8.sid = t786_userrolehierarchy_8.c4812_user_role_id)
77. 0.000 0.000 ↓ 0.0 0

Seq Scan on t859_userroledim t859_userroledim_8 (cost=0.00..7.35 rows=29 width=4) (never executed)

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

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

79. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_37_t786_userrolehierarchy_sid_c4815_ancestor_role_id_end_st on t786_userrolehierarchy t786_userrolehierarchy_8 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t2273_meetingactivityaccountfact_2.c9004_activityownersfuserid) AND (c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
80. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=23.72..97.23 rows=246 width=4) (never executed)

  • Hash Cond: (t786_userrolehierarchy_9.c4812_user_role_id = t859_userroledim_9.sid)
81. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t786_userrolehierarchy t786_userrolehierarchy_9 (cost=16.01..88.47 rows=364 width=8) (never executed)

  • Recheck Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
82. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_35_t786_userrolehierarchy_c4815_ancestor_role_id_end_stamp_ (cost=0.00..15.92 rows=364 width=0) (never executed)

  • Index Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
83. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.35..7.35 rows=29 width=4) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Seq Scan on t859_userroledim t859_userroledim_9 (cost=0.00..7.35 rows=29 width=4) (never executed)

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

Index Scan using idx_14_t773_userdim_sid_end_stamp_start_stamp_null on t773_userdim t773_userdim_8 (cost=0.28..8.30 rows=1 width=0) (never executed)

  • Index Cond: ((sid = t2273_meetingactivityaccountfact_2.c9004_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c4570_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
86. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t773_userdim t773_userdim_9 (cost=4.98..53.05 rows=68 width=4) (never executed)

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

Bitmap Index Scan on idx_15_t773_userdim_c4570_userroleid_end_stamp_start_stamp_null (cost=0.00..4.97 rows=69 width=0) (never executed)

  • Index Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
88. 0.307 5.160 ↑ 3.2 519 1

Unique (cost=195,437.70..195,467.37 rows=1,660 width=4) (actual time=4.628..5.160 rows=519 loops=1)

89. 1.036 4.853 ↑ 1.3 4,596 1

Sort (cost=195,437.70..195,452.54 rows=5,935 width=4) (actual time=4.628..4.853 rows=4,596 loops=1)

  • Sort Key: t2273_meetingactivityaccountfact_3.c9010_accountid
  • Sort Method: quicksort Memory: 408kB
90. 2.694 3.817 ↑ 1.3 4,596 1

Bitmap Heap Scan on t2273_meetingactivityaccountfact t2273_meetingactivityaccountfact_3 (cost=491.86..195,065.72 rows=5,935 width=4) (actual time=1.248..3.817 rows=4,596 loops=1)

  • Recheck Cond: ((c8986_activitydate >= '1593241200000'::bigint) AND (c8986_activitydate < '1595833200000'::bigint) AND (end_stamp > '1593173652000'::bigint) AND (start_stamp <= '1593173652000'::bigint) AND c8998_isshared AND (NOT deleted))
  • Filter: ((alternatives: SubPlan 26 or hashed SubPlan 27) OR (alternatives: SubPlan 28 or hashed SubPlan 29))
  • Rows Removed by Filter: 170
  • Heap Blocks: exact=1,124
91. 0.825 0.825 ↑ 1.7 4,766 1

Bitmap Index Scan on "idx_activitydate_issharedp_del_P_sentha" (cost=0.00..490.38 rows=7,914 width=0) (actual time=0.825..0.825 rows=4,766 loops=1)

  • Index Cond: ((c8986_activitydate >= '1593241200000'::bigint) AND (c8986_activitydate < '1595833200000'::bigint) AND (end_stamp > '1593173652000'::bigint) AND (start_stamp <= '1593173652000'::bigint))
92.          

SubPlan (for Bitmap Heap Scan)

93. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.32..15.78 rows=1 width=0) (never executed)

  • Hash Cond: (t859_userroledim_10.sid = t786_userrolehierarchy_10.c4812_user_role_id)
94. 0.000 0.000 ↓ 0.0 0

Seq Scan on t859_userroledim t859_userroledim_10 (cost=0.00..7.35 rows=29 width=4) (never executed)

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

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

96. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_37_t786_userrolehierarchy_sid_c4815_ancestor_role_id_end_st on t786_userrolehierarchy t786_userrolehierarchy_10 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t2273_meetingactivityaccountfact_3.c9004_activityownersfuserid) AND (c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
97. 0.083 0.247 ↓ 1.5 359 1

Hash Join (cost=23.72..97.23 rows=246 width=4) (actual time=0.086..0.247 rows=359 loops=1)

  • Hash Cond: (t786_userrolehierarchy_11.c4812_user_role_id = t859_userroledim_11.sid)
98. 0.096 0.123 ↑ 1.0 359 1

Bitmap Heap Scan on t786_userrolehierarchy t786_userrolehierarchy_11 (cost=16.01..88.47 rows=364 width=8) (actual time=0.038..0.123 rows=359 loops=1)

  • Recheck Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=62
99. 0.027 0.027 ↑ 1.0 359 1

Bitmap Index Scan on idx_35_t786_userrolehierarchy_c4815_ancestor_role_id_end_stamp_ (cost=0.00..15.92 rows=364 width=0) (actual time=0.027..0.027 rows=359 loops=1)

  • Index Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
100. 0.006 0.041 ↓ 1.5 44 1

Hash (cost=7.35..7.35 rows=29 width=4) (actual time=0.041..0.041 rows=44 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
101. 0.035 0.035 ↓ 1.5 44 1

Seq Scan on t859_userroledim t859_userroledim_11 (cost=0.00..7.35 rows=29 width=4) (actual time=0.005..0.035 rows=44 loops=1)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c4994_portaltype IS NULL) OR (c4994_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
  • Rows Removed by Filter: 84
102. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_14_t773_userdim_sid_end_stamp_start_stamp_null on t773_userdim t773_userdim_10 (cost=0.28..8.30 rows=1 width=0) (never executed)

  • Index Cond: ((sid = t2273_meetingactivityaccountfact_3.c9004_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c4570_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
103. 0.034 0.051 ↑ 2.5 27 1

Bitmap Heap Scan on t773_userdim t773_userdim_11 (cost=4.98..53.05 rows=68 width=4) (actual time=0.025..0.051 rows=27 loops=1)

  • Recheck Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
  • Rows Removed by Filter: 9
  • Heap Blocks: exact=23
104. 0.017 0.017 ↑ 1.9 36 1

Bitmap Index Scan on idx_15_t773_userdim_c4570_userroleid_end_stamp_start_stamp_null (cost=0.00..4.97 rows=69 width=0) (actual time=0.017..0.017 rows=36 loops=1)

  • Index Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
105. 115.625 3,468.045 ↓ 4.8 5,838 1

Unique (cost=144,107,974.43..144,126,913.07 rows=1,208 width=4) (actual time=3,169.204..3,468.045 rows=5,838 loops=1)

106. 629.089 3,352.420 ↑ 1.9 2,047,378 1

Sort (cost=144,107,974.43..144,117,443.75 rows=3,787,729 width=4) (actual time=3,169.203..3,352.420 rows=2,047,378 loops=1)

  • Sort Key: t2608_emailactivityaccountfact_copy_sentha.c9638_accountid
  • Sort Method: external merge Disk: 28,144kB
107. 2,723.055 2,723.331 ↑ 1.9 2,047,385 1

Index Scan using idx_isinternal_sentha1 on t2608_emailactivityaccountfact_copy_sentha (cost=0.56..143,590,538.08 rows=3,787,729 width=4) (actual time=0.320..2,723.331 rows=2,047,385 loops=1)

  • Index Cond: ((c9660_isinternalinitiated = true) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint))
  • Filter: (c9660_isinternalinitiated AND (c9653_activitydate >= '1561532400000'::bigint) AND (c9653_activitydate < '1593241200000'::bigint) AND ((alternatives: SubPlan 31 or hashed SubPlan 32) OR (alternatives: SubPlan 33 or hashed SubPlan 34)))
  • Rows Removed by Filter: 3,341,649
108.          

SubPlan (for Index Scan)

109. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.32..15.78 rows=1 width=0) (never executed)

  • Hash Cond: (t859_userroledim_12.sid = t786_userrolehierarchy_12.c4812_user_role_id)
110. 0.000 0.000 ↓ 0.0 0

Seq Scan on t859_userroledim t859_userroledim_12 (cost=0.00..7.35 rows=29 width=4) (never executed)

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

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

112. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_37_t786_userrolehierarchy_sid_c4815_ancestor_role_id_end_st on t786_userrolehierarchy t786_userrolehierarchy_12 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t2608_emailactivityaccountfact_copy_sentha.c9662_activityownersfuserid) AND (c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
113. 0.081 0.235 ↓ 1.5 359 1

Hash Join (cost=23.72..97.23 rows=246 width=4) (actual time=0.084..0.235 rows=359 loops=1)

  • Hash Cond: (t786_userrolehierarchy_13.c4812_user_role_id = t859_userroledim_13.sid)
114. 0.088 0.114 ↑ 1.0 359 1

Bitmap Heap Scan on t786_userrolehierarchy t786_userrolehierarchy_13 (cost=16.01..88.47 rows=364 width=8) (actual time=0.036..0.114 rows=359 loops=1)

  • Recheck Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=62
115. 0.026 0.026 ↑ 1.0 359 1

Bitmap Index Scan on idx_35_t786_userrolehierarchy_c4815_ancestor_role_id_end_stamp_ (cost=0.00..15.92 rows=364 width=0) (actual time=0.026..0.026 rows=359 loops=1)

  • Index Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
116. 0.007 0.040 ↓ 1.5 44 1

Hash (cost=7.35..7.35 rows=29 width=4) (actual time=0.040..0.040 rows=44 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
117. 0.033 0.033 ↓ 1.5 44 1

Seq Scan on t859_userroledim t859_userroledim_13 (cost=0.00..7.35 rows=29 width=4) (actual time=0.004..0.033 rows=44 loops=1)

  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND ((c4994_portaltype IS NULL) OR (c4994_portaltype = 'None'::text)) AND (end_stamp = '32503680000000'::bigint))
  • Rows Removed by Filter: 84
118. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_14_t773_userdim_sid_end_stamp_start_stamp_null on t773_userdim t773_userdim_12 (cost=0.28..8.30 rows=1 width=0) (never executed)

  • Index Cond: ((sid = t2608_emailactivityaccountfact_copy_sentha.c9662_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c4570_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
119. 0.029 0.041 ↑ 2.5 27 1

Bitmap Heap Scan on t773_userdim t773_userdim_13 (cost=4.98..53.05 rows=68 width=4) (actual time=0.019..0.041 rows=27 loops=1)

  • Recheck Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
  • Rows Removed by Filter: 9
  • Heap Blocks: exact=23
120. 0.012 0.012 ↑ 1.9 36 1

Bitmap Index Scan on idx_15_t773_userdim_c4570_userroleid_end_stamp_start_stamp_null (cost=0.00..4.97 rows=69 width=0) (actual time=0.011..0.012 rows=36 loops=1)

  • Index Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
121. 2.135 2.135 ↑ 2.0 1 427

Index Scan using t2268_accountdim_sidendstampunique on t2268_accountdim (cost=0.42..4.99 rows=2 width=40) (actual time=0.004..0.005 rows=1 loops=427)

  • Index Cond: ((sid = t1401_accountfact.sid) AND (end_stamp > '1593173652000'::bigint))
  • Filter: ((NOT deleted) AND (start_stamp <= '1593173652000'::bigint))
  • Rows Removed by Filter: 1
Planning time : 11.918 ms
Execution time : 3,816.313 ms