explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pJq2

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 461.975 ↑ 4,864.4 13 1

Sort (cost=13,176,583.19..13,176,741.29 rows=63,237 width=32) (actual time=461.974..461.975 rows=13 loops=1)

  • Sort Key: (CASE WHEN (cte0.c2 IS NOT NULL) THEN cte0.c2 WHEN (cte1.c2 IS NOT NULL) THEN cte1.c2 WHEN (cte2.c2 IS NOT NULL) THEN cte2.c2 ELSE NULL::integer END) NULLS FIRST, (CASE WHEN (cte0.c3 IS NOT NULL) THEN cte0.c3 WHEN (cte1.c3 IS NOT NULL) THEN cte1.c3 WHEN (cte2.c3 IS NOT NULL) THEN cte2.c3 ELSE NULL::integer END) NULLS FIRST
  • Sort Method: quicksort Memory: 26kB
2.          

CTE email_received

3. 2.379 99.173 ↑ 3,635.4 13 1

GroupAggregate (cost=6,550,857.03..6,553,469.54 rows=47,260 width=16) (actual time=96.715..99.173 rows=13 loops=1)

  • Group Key: ((date_part('month'::text, timezone('US/Pacific'::text, to_timestamp(((t1816_emailactivityaccountfact.c8036_activitydate / 1000))::double precision))))::integer), ((date_part('year'::text, timezone('US/Pacific'::text, to_timestamp(((t1816_emailactivityaccountfact.c8036_activitydate / 1000))::double precision))))::integer)
4. 2.388 96.794 ↑ 9.2 7,822 1

Sort (cost=6,550,857.03..6,551,037.55 rows=72,211 width=12) (actual time=96.220..96.794 rows=7,822 loops=1)

  • Sort Key: ((date_part('month'::text, timezone('US/Pacific'::text, to_timestamp(((t1816_emailactivityaccountfact.c8036_activitydate / 1000))::double precision))))::integer), ((date_part('year'::text, timezone('US/Pacific'::text, to_timestamp(((t1816_emailactivityaccountfact.c8036_activitydate / 1000))::double precision))))::integer)
  • Sort Method: quicksort Memory: 559kB
5. 83.191 94.406 ↑ 9.2 7,822 1

Bitmap Heap Scan on t1816_emailactivityaccountfact (cost=4,892.34..6,545,029.62 rows=72,211 width=12) (actual time=12.176..94.406 rows=7,822 loops=1)

  • Recheck Cond: ((c8021_accountid = 123) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (NOT c8043_isinternalinitiated) AND c8040_isshared AND (c8036_activitydate >= '1561639914655'::bigint) AND (c8036_activitydate < '1593175914655'::bigint) AND ((alternatives: SubPlan 1 or hashed SubPlan 2) OR (alternatives: SubPlan 3 or hashed SubPlan 4)))
  • Rows Removed by Filter: 249,125
  • Heap Blocks: exact=6,365
6. 10.800 10.800 ↑ 1.0 256,947 1

Bitmap Index Scan on t1816_emailactivityaccountfact_983_ptimestamp (cost=0.00..4,874.29 rows=263,714 width=0) (actual time=10.800..10.800 rows=256,947 loops=1)

  • Index Cond: (c8021_accountid = 123)
7.          

SubPlan (for Bitmap Heap Scan)

8. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..15.35 rows=1 width=0) (never executed)

  • Join Filter: (t786_userrolehierarchy.c4812_user_role_id = t859_userroledim.sid)
9. 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 = t1816_emailactivityaccountfact.c8045_activityownersfuserid) AND (c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on t859_userroledim (cost=0.00..6.82 rows=18 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))
11. 0.112 0.334 ↓ 2.3 354 1

Hash Join (cost=23.05..95.54 rows=152 width=4) (actual time=0.119..0.334 rows=354 loops=1)

  • Hash Cond: (t786_userrolehierarchy_1.c4812_user_role_id = t859_userroledim_1.sid)
12. 0.132 0.171 ↑ 1.0 354 1

Bitmap Heap Scan on t786_userrolehierarchy t786_userrolehierarchy_1 (cost=16.00..87.45 rows=363 width=8) (actual time=0.053..0.171 rows=354 loops=1)

  • Recheck Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=61
13. 0.039 0.039 ↑ 1.0 354 1

Bitmap Index Scan on idx_35_t786_userrolehierarchy_c4815_ancestor_role_id_end_stamp_ (cost=0.00..15.91 rows=363 width=0) (actual time=0.039..0.039 rows=354 loops=1)

  • Index Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
14. 0.008 0.051 ↓ 2.4 44 1

Hash (cost=6.82..6.82 rows=18 width=4) (actual time=0.051..0.051 rows=44 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
15. 0.043 0.043 ↓ 2.4 44 1

Seq Scan on t859_userroledim t859_userroledim_1 (cost=0.00..6.82 rows=18 width=4) (actual time=0.007..0.043 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
16. 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 = t1816_emailactivityaccountfact.c8045_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c4570_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
17. 0.051 0.081 ↑ 2.3 29 1

Bitmap Heap Scan on t773_userdim t773_userdim_1 (cost=4.98..53.05 rows=67 width=4) (actual time=0.041..0.081 rows=29 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=24
18. 0.030 0.030 ↑ 1.8 38 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.030..0.030 rows=38 loops=1)

  • Index Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
19.          

CTE email_sent

20. 23.947 358.580 ↑ 4,117.2 13 1

GroupAggregate (cost=6,552,940.27..6,555,978.40 rows=53,523 width=16) (actual time=330.885..358.580 rows=13 loops=1)

  • Group Key: ((date_part('month'::text, timezone('US/Pacific'::text, to_timestamp(((t1816_emailactivityaccountfact_1.c8036_activitydate / 1000))::double precision))))::integer), ((date_part('year'::text, timezone('US/Pacific'::text, to_timestamp(((t1816_emailactivityaccountfact_1.c8036_activitydate / 1000))::double precision))))::integer)
21. 78.730 334.633 ↑ 1.1 84,359 1

Sort (cost=6,552,940.27..6,553,164.57 rows=89,721 width=12) (actual time=323.914..334.633 rows=84,359 loops=1)

  • Sort Key: ((date_part('month'::text, timezone('US/Pacific'::text, to_timestamp(((t1816_emailactivityaccountfact_1.c8036_activitydate / 1000))::double precision))))::integer), ((date_part('year'::text, timezone('US/Pacific'::text, to_timestamp(((t1816_emailactivityaccountfact_1.c8036_activitydate / 1000))::double precision))))::integer)
  • Sort Method: external merge Disk: 1,824kB
22. 245.607 255.903 ↑ 1.1 84,359 1

Bitmap Heap Scan on t1816_emailactivityaccountfact t1816_emailactivityaccountfact_1 (cost=4,896.72..6,545,559.30 rows=89,721 width=12) (actual time=11.459..255.903 rows=84,359 loops=1)

  • Recheck Cond: ((c8021_accountid = 123) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND c8043_isinternalinitiated AND c8040_isshared AND (c8036_activitydate >= '1561639914655'::bigint) AND (c8036_activitydate < '1593175914655'::bigint) AND ((alternatives: SubPlan 6 or hashed SubPlan 7) OR (alternatives: SubPlan 8 or hashed SubPlan 9)))
  • Rows Removed by Filter: 172,588
  • Heap Blocks: exact=6,365
23. 9.727 9.727 ↑ 1.0 256,947 1

Bitmap Index Scan on t1816_emailactivityaccountfact_983_ptimestamp (cost=0.00..4,874.29 rows=263,714 width=0) (actual time=9.727..9.727 rows=256,947 loops=1)

  • Index Cond: (c8021_accountid = 123)
24.          

SubPlan (for Bitmap Heap Scan)

25. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..15.35 rows=1 width=0) (never executed)

  • Join Filter: (t786_userrolehierarchy_2.c4812_user_role_id = t859_userroledim_2.sid)
26. 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 = t1816_emailactivityaccountfact_1.c8045_activityownersfuserid) AND (c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
27. 0.000 0.000 ↓ 0.0 0

Seq Scan on t859_userroledim t859_userroledim_2 (cost=0.00..6.82 rows=18 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))
28. 0.141 0.476 ↓ 2.3 354 1

Hash Join (cost=23.05..95.54 rows=152 width=4) (actual time=0.171..0.476 rows=354 loops=1)

  • Hash Cond: (t786_userrolehierarchy_3.c4812_user_role_id = t859_userroledim_3.sid)
29. 0.198 0.251 ↑ 1.0 354 1

Bitmap Heap Scan on t786_userrolehierarchy t786_userrolehierarchy_3 (cost=16.00..87.45 rows=363 width=8) (actual time=0.071..0.251 rows=354 loops=1)

  • Recheck Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=61
30. 0.053 0.053 ↑ 1.0 354 1

Bitmap Index Scan on idx_35_t786_userrolehierarchy_c4815_ancestor_role_id_end_stamp_ (cost=0.00..15.91 rows=363 width=0) (actual time=0.053..0.053 rows=354 loops=1)

  • Index Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
31. 0.010 0.084 ↓ 2.4 44 1

Hash (cost=6.82..6.82 rows=18 width=4) (actual time=0.083..0.084 rows=44 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
32. 0.074 0.074 ↓ 2.4 44 1

Seq Scan on t859_userroledim t859_userroledim_3 (cost=0.00..6.82 rows=18 width=4) (actual time=0.015..0.074 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
33. 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 = t1816_emailactivityaccountfact_1.c8045_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c4570_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
34. 0.068 0.093 ↑ 2.3 29 1

Bitmap Heap Scan on t773_userdim t773_userdim_3 (cost=4.98..53.05 rows=67 width=4) (actual time=0.039..0.093 rows=29 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=24
35. 0.025 0.025 ↑ 1.8 38 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.025..0.025 rows=38 loops=1)

  • Index Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
36.          

CTE meeting

37. 0.375 4.103 ↑ 73.1 13 1

GroupAggregate (cost=45,089.43..45,137.74 rows=950 width=16) (actual time=3.718..4.103 rows=13 loops=1)

  • Group Key: ((date_part('month'::text, timezone('US/Pacific'::text, to_timestamp(((t1662_meetingactivityaccountfact.c7794_activitydate / 1000))::double precision))))::integer), ((date_part('year'::text, timezone('US/Pacific'::text, to_timestamp(((t1662_meetingactivityaccountfact.c7794_activitydate / 1000))::double precision))))::integer)
38. 0.460 3.728 ↓ 1.4 1,399 1

Sort (cost=45,089.43..45,092.01 rows=1,031 width=12) (actual time=3.651..3.728 rows=1,399 loops=1)

  • Sort Key: ((date_part('month'::text, timezone('US/Pacific'::text, to_timestamp(((t1662_meetingactivityaccountfact.c7794_activitydate / 1000))::double precision))))::integer), ((date_part('year'::text, timezone('US/Pacific'::text, to_timestamp(((t1662_meetingactivityaccountfact.c7794_activitydate / 1000))::double precision))))::integer)
  • Sort Method: quicksort Memory: 114kB
39. 2.794 3.268 ↓ 1.4 1,399 1

Bitmap Heap Scan on t1662_meetingactivityaccountfact (cost=38.16..45,037.83 rows=1,031 width=12) (actual time=0.588..3.268 rows=1,399 loops=1)

  • Recheck Cond: ((c7809_accountid = 123) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND c7805_isshared AND (c7794_activitydate >= '1561639914655'::bigint) AND (c7794_activitydate < '1593175914655'::bigint) AND ((alternatives: SubPlan 11 or hashed SubPlan 12) OR (alternatives: SubPlan 13 or hashed SubPlan 14)))
  • Rows Removed by Filter: 401
  • Heap Blocks: exact=60
40. 0.074 0.074 ↓ 1.0 1,800 1

Bitmap Index Scan on t1662_meetingactivityaccountfact_917_ptimestamp (cost=0.00..37.90 rows=1,798 width=0) (actual time=0.074..0.074 rows=1,800 loops=1)

  • Index Cond: (c7809_accountid = 123)
41.          

SubPlan (for Bitmap Heap Scan)

42. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..15.35 rows=1 width=0) (never executed)

  • Join Filter: (t786_userrolehierarchy_4.c4812_user_role_id = t859_userroledim_4.sid)
43. 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 = t1662_meetingactivityaccountfact.c7807_activityownersfuserid) AND (c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
44. 0.000 0.000 ↓ 0.0 0

Seq Scan on t859_userroledim t859_userroledim_4 (cost=0.00..6.82 rows=18 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.099 0.326 ↓ 2.3 354 1

Hash Join (cost=23.05..95.54 rows=152 width=4) (actual time=0.114..0.326 rows=354 loops=1)

  • Hash Cond: (t786_userrolehierarchy_5.c4812_user_role_id = t859_userroledim_5.sid)
46. 0.131 0.178 ↑ 1.0 354 1

Bitmap Heap Scan on t786_userrolehierarchy t786_userrolehierarchy_5 (cost=16.00..87.45 rows=363 width=8) (actual time=0.060..0.178 rows=354 loops=1)

  • Recheck Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=61
47. 0.047 0.047 ↑ 1.0 354 1

Bitmap Index Scan on idx_35_t786_userrolehierarchy_c4815_ancestor_role_id_end_stamp_ (cost=0.00..15.91 rows=363 width=0) (actual time=0.047..0.047 rows=354 loops=1)

  • Index Cond: ((c4815_ancestor_role_id = 12) AND (end_stamp = '32503680000000'::bigint))
48. 0.007 0.049 ↓ 2.4 44 1

Hash (cost=6.82..6.82 rows=18 width=4) (actual time=0.049..0.049 rows=44 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
49. 0.042 0.042 ↓ 2.4 44 1

Seq Scan on t859_userroledim t859_userroledim_5 (cost=0.00..6.82 rows=18 width=4) (actual time=0.005..0.042 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
50. 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 = t1662_meetingactivityaccountfact.c7807_activityownersfuserid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (c4570_userroleid IS NULL) AND (sid <> '-2'::integer) AND (c4581_usertype = 'Standard'::text))
51. 0.055 0.074 ↑ 2.3 29 1

Bitmap Heap Scan on t773_userdim t773_userdim_5 (cost=4.98..53.05 rows=67 width=4) (actual time=0.029..0.074 rows=29 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=24
52. 0.019 0.019 ↑ 1.8 38 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.019..0.019 rows=38 loops=1)

  • Index Cond: ((c4570_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
53. 0.014 461.960 ↑ 4,864.4 13 1

Merge Full Join (cost=16,458.42..16,954.84 rows=63,237 width=32) (actual time=461.948..461.960 rows=13 loops=1)

  • Merge Cond: ((cte2.c2 = (CASE WHEN (cte0.c2 IS NOT NULL) THEN cte0.c2 WHEN (cte1.c2 IS NOT NULL) THEN cte1.c2 ELSE NULL::integer END)) AND (cte2.c3 = (CASE WHEN (cte0.c3 IS NOT NULL) THEN cte0.c3 WHEN (cte1.c3 IS NOT NULL) THEN cte1.c3 ELSE NULL::integer END)))
54. 0.009 4.121 ↑ 73.1 13 1

Sort (cost=65.99..68.36 rows=950 width=16) (actual time=4.119..4.121 rows=13 loops=1)

  • Sort Key: cte2.c2, cte2.c3
  • Sort Method: quicksort Memory: 25kB
55. 4.112 4.112 ↑ 73.1 13 1

CTE Scan on meeting cte2 (cost=0.00..19.00 rows=950 width=16) (actual time=3.719..4.112 rows=13 loops=1)

56. 0.008 457.825 ↑ 4,864.4 13 1

Sort (cost=16,392.43..16,550.53 rows=63,237 width=32) (actual time=457.824..457.825 rows=13 loops=1)

  • Sort Key: (CASE WHEN (cte0.c2 IS NOT NULL) THEN cte0.c2 WHEN (cte1.c2 IS NOT NULL) THEN cte1.c2 ELSE NULL::integer END), (CASE WHEN (cte0.c3 IS NOT NULL) THEN cte0.c3 WHEN (cte1.c3 IS NOT NULL) THEN cte1.c3 ELSE NULL::integer END)
  • Sort Method: quicksort Memory: 26kB
57. 0.014 457.817 ↑ 4,864.4 13 1

Merge Full Join (cost=9,888.67..11,349.76 rows=63,237 width=32) (actual time=457.805..457.817 rows=13 loops=1)

  • Merge Cond: (((CASE WHEN (cte0.c2 IS NOT NULL) THEN cte0.c2 ELSE NULL::integer END) = cte1.c2) AND ((CASE WHEN (cte0.c3 IS NOT NULL) THEN cte0.c3 ELSE NULL::integer END) = cte1.c3))
58. 0.012 99.195 ↑ 3,635.4 13 1

Sort (cost=4,614.54..4,732.69 rows=47,260 width=16) (actual time=99.193..99.195 rows=13 loops=1)

  • Sort Key: (CASE WHEN (cte0.c2 IS NOT NULL) THEN cte0.c2 ELSE NULL::integer END), (CASE WHEN (cte0.c3 IS NOT NULL) THEN cte0.c3 ELSE NULL::integer END)
  • Sort Method: quicksort Memory: 26kB
59. 99.183 99.183 ↑ 3,635.4 13 1

CTE Scan on email_received cte0 (cost=0.00..945.20 rows=47,260 width=16) (actual time=96.717..99.183 rows=13 loops=1)

60. 0.011 358.608 ↑ 4,117.2 13 1

Sort (cost=5,274.12..5,407.93 rows=53,523 width=16) (actual time=358.607..358.608 rows=13 loops=1)

  • Sort Key: cte1.c2, cte1.c3
  • Sort Method: quicksort Memory: 25kB
61. 358.597 358.597 ↑ 4,117.2 13 1

CTE Scan on email_sent cte1 (cost=0.00..1,070.46 rows=53,523 width=16) (actual time=330.888..358.597 rows=13 loops=1)

Planning time : 6.227 ms
Execution time : 463.440 ms