explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6es

Settings
# exclusive inclusive rows x rows loops node
1. 0.098 1,758.119 ↑ 120.8 40 1

HashAggregate (cost=1,785,077.22..1,785,125.54 rows=4,832 width=12) (actual time=1,758.091..1,758.119 rows=40 loops=1)

  • Group Key: (count(DISTINCT t2608_emailactivityaccountfact_copy_sentha.c9655_activitychecksum)), t2608_emailactivityaccountfact_copy_sentha.c9638_accountid
2. 0.015 1,758.021 ↑ 120.8 40 1

Append (cost=544,101.36..1,785,053.06 rows=4,832 width=12) (actual time=267.978..1,758.021 rows=40 loops=1)

3. 83.213 386.227 ↑ 120.8 10 1

GroupAggregate (cost=544,101.36..547,827.37 rows=1,208 width=12) (actual time=267.977..386.227 rows=10 loops=1)

  • Group Key: t2608_emailactivityaccountfact_copy_sentha.c9638_accountid
4. 121.672 303.014 ↑ 1.2 424,126 1

Sort (cost=544,101.36..545,339.34 rows=495,190 width=8) (actual time=264.406..303.014 rows=424,126 loops=1)

  • Sort Key: t2608_emailactivityaccountfact_copy_sentha.c9638_accountid
  • Sort Method: external merge Disk: 7,512kB
5. 149.726 181.342 ↑ 1.2 424,126 1

Bitmap Heap Scan on t2608_emailactivityaccountfact_copy_sentha (cost=31,343.87..490,489.77 rows=495,190 width=8) (actual time=36.124..181.342 rows=424,126 loops=1)

  • Recheck Cond: ((c9638_accountid = ANY ('{8543,81,648,124,2591,8165,431,91,1068,9391}'::integer[])) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint) AND c9657_isshared AND (NOT deleted))
  • Filter: ((NOT c9660_isinternalinitiated) AND (c9653_activitydate >= '1561532400000'::bigint) AND (c9653_activitydate < '1593241200000'::bigint))
  • Rows Removed by Filter: 48,564
  • Heap Blocks: exact=30,532
6. 31.616 31.616 ↑ 1.2 472,690 1

Bitmap Index Scan on idx_accountid_partial_sentha1 (cost=0.00..31,220.07 rows=577,291 width=0) (actual time=31.615..31.616 rows=472,690 loops=1)

  • Index Cond: ((c9638_accountid = ANY ('{8543,81,648,124,2591,8165,431,91,1068,9391}'::integer[])) AND (c9660_isinternalinitiated = false) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint))
7. 58.997 254.901 ↑ 120.8 10 1

GroupAggregate (cost=313,564.15..314,496.82 rows=1,208 width=12) (actual time=170.787..254.901 rows=10 loops=1)

  • Group Key: t2608_emailactivityaccountfact_copy_sentha_1.c9638_accountid
8. 94.293 195.904 ↓ 2.1 263,808 1

Sort (cost=313,564.15..313,871.01 rows=122,745 width=8) (actual time=169.364..195.904 rows=263,808 loops=1)

  • Sort Key: t2608_emailactivityaccountfact_copy_sentha_1.c9638_accountid
  • Sort Method: external merge Disk: 4,672kB
9. 84.125 101.611 ↓ 2.1 263,808 1

Bitmap Heap Scan on t2608_emailactivityaccountfact_copy_sentha t2608_emailactivityaccountfact_copy_sentha_1 (cost=7,869.01..303,188.94 rows=122,745 width=8) (actual time=19.491..101.611 rows=263,808 loops=1)

  • Recheck Cond: ((c9638_accountid = ANY ('{21442,1361,700,1168,963,9249,117,19596,73031,932}'::integer[])) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint) AND c9657_isshared AND (NOT deleted))
  • Filter: ((NOT c9660_isinternalinitiated) AND (c9653_activitydate >= '1561532400000'::bigint) AND (c9653_activitydate < '1593241200000'::bigint))
  • Rows Removed by Filter: 15,839
  • Heap Blocks: exact=14,638
10. 17.486 17.486 ↓ 2.0 279,647 1

Bitmap Index Scan on idx_accountid_partial_sentha1 (cost=0.00..7,838.32 rows=143,096 width=0) (actual time=17.486..17.486 rows=279,647 loops=1)

  • Index Cond: ((c9638_accountid = ANY ('{21442,1361,700,1168,963,9249,117,19596,73031,932}'::integer[])) AND (c9660_isinternalinitiated = false) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint))
11. 200.106 648.969 ↑ 120.8 10 1

GroupAggregate (cost=495,275.26..497,767.77 rows=1,208 width=12) (actual time=400.421..648.969 rows=10 loops=1)

  • Group Key: t2608_emailactivityaccountfact_copy_sentha_2.c9638_accountid
12. 176.147 448.863 ↓ 2.1 707,827 1

Sort (cost=495,275.26..496,102.07 rows=330,725 width=8) (actual time=382.702..448.863 rows=707,827 loops=1)

  • Sort Key: t2608_emailactivityaccountfact_copy_sentha_2.c9638_accountid
  • Sort Method: external merge Disk: 12,544kB
13. 223.279 272.716 ↓ 2.1 707,827 1

Bitmap Heap Scan on t2608_emailactivityaccountfact_copy_sentha t2608_emailactivityaccountfact_copy_sentha_2 (cost=21,069.06..460,433.59 rows=330,725 width=8) (actual time=53.880..272.716 rows=707,827 loops=1)

  • Recheck Cond: ((c9638_accountid = ANY ('{23938,335,22279,540,705,481,9080,578,77,2553}'::integer[])) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint) AND c9657_isshared AND (NOT deleted))
  • Filter: ((NOT c9660_isinternalinitiated) AND (c9653_activitydate >= '1561532400000'::bigint) AND (c9653_activitydate < '1593241200000'::bigint))
  • Rows Removed by Filter: 101,485
  • Heap Blocks: exact=30,189
14. 49.437 49.437 ↓ 2.1 809,312 1

Bitmap Index Scan on idx_accountid_partial_sentha1 (cost=0.00..20,986.38 rows=385,558 width=0) (actual time=49.437..49.437 rows=809,312 loops=1)

  • Index Cond: ((c9638_accountid = ANY ('{23938,335,22279,540,705,481,9080,578,77,2553}'::integer[])) AND (c9660_isinternalinitiated = false) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint))
15. 131.455 467.909 ↑ 120.8 10 1

GroupAggregate (cost=423,281.31..424,912.79 rows=1,208 width=12) (actual time=308.386..467.909 rows=10 loops=1)

  • Group Key: t2608_emailactivityaccountfact_copy_sentha_3.c9638_accountid
16. 138.510 336.454 ↓ 2.5 540,326 1

Sort (cost=423,281.31..423,821.11 rows=215,919 width=8) (actual time=286.088..336.454 rows=540,326 loops=1)

  • Sort Key: t2608_emailactivityaccountfact_copy_sentha_3.c9638_accountid
  • Sort Method: external merge Disk: 9,576kB
17. 160.253 197.944 ↓ 2.5 540,326 1

Bitmap Heap Scan on t2608_emailactivityaccountfact_copy_sentha t2608_emailactivityaccountfact_copy_sentha_3 (cost=13,798.35..401,196.75 rows=215,919 width=8) (actual time=40.223..197.944 rows=540,326 loops=1)

  • Recheck Cond: ((c9638_accountid = ANY ('{9074,58181,2392,18329,6790,21215,1719,1521,1872,11255}'::integer[])) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint) AND c9657_isshared AND (NOT deleted))
  • Filter: ((NOT c9660_isinternalinitiated) AND (c9653_activitydate >= '1561532400000'::bigint) AND (c9653_activitydate < '1593241200000'::bigint))
  • Rows Removed by Filter: 42,140
  • Heap Blocks: exact=18,435
18. 37.691 37.691 ↓ 2.3 582,466 1

Bitmap Index Scan on idx_accountid_partial_sentha1 (cost=0.00..13,744.38 rows=251,717 width=0) (actual time=37.691..37.691 rows=582,466 loops=1)

  • Index Cond: ((c9638_accountid = ANY ('{9074,58181,2392,18329,6790,21215,1719,1521,1872,11255}'::integer[])) AND (c9660_isinternalinitiated = false) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint))
Planning time : 1.427 ms
Execution time : 1,765.055 ms