explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T3Iw

Settings
# exclusive inclusive rows x rows loops node
1. 466.786 2,049.819 ↑ 30.2 40 1

GroupAggregate (cost=912,646.65..921,393.07 rows=1,208 width=12) (actual time=1,418.983..2,049.819 rows=40 loops=1)

  • Group Key: t2608_emailactivityaccountfact_copy_sentha.c9638_accountid
2. 580.379 1,583.033 ↓ 1.7 1,936,087 1

Sort (cost=912,646.65..915,558.10 rows=1,164,579 width=8) (actual time=1,400.566..1,583.033 rows=1,936,087 loops=1)

  • Sort Key: t2608_emailactivityaccountfact_copy_sentha.c9638_accountid
  • Sort Method: external merge Disk: 34,160kB
3. 255.752 1,002.654 ↓ 1.7 1,936,087 1

Gather (cost=151,338.64..779,382.30 rows=1,164,579 width=8) (actual time=266.464..1,002.654 rows=1,936,087 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 661.880 746.902 ↓ 1.3 645,362 3 / 3

Parallel Bitmap Heap Scan on t2608_emailactivityaccountfact_copy_sentha (cost=150,338.64..661,924.40 rows=485,241 width=8) (actual time=193.516..746.902 rows=645,362 loops=3)

  • Recheck Cond: ((c9638_accountid = ANY ('{8543,81,648,124,2591,8165,431,91,1068,9391,21442,1361,700,1168,963,9249,117,19596,73031,932,23938,335,22279,540,705,481,9080,578,77,2553,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))
  • Rows Removed by Index Recheck: 269,544
  • Filter: ((NOT c9660_isinternalinitiated) AND (c9653_activitydate >= '1561532400000'::bigint) AND (c9653_activitydate < '1593241200000'::bigint))
  • Rows Removed by Filter: 681,627
  • Heap Blocks: exact=8,063 lossy=11,884
5. 85.022 85.022 ↓ 1.2 3,980,969 1 / 3

Bitmap Index Scan on idx_accountid_partial_sentha1 (cost=0.00..150,047.50 rows=3,196,003 width=0) (actual time=255.065..255.065 rows=3,980,969 loops=1)

  • Index Cond: ((c9638_accountid = ANY ('{8543,81,648,124,2591,8165,431,91,1068,9391,21442,1361,700,1168,963,9249,117,19596,73031,932,23938,335,22279,540,705,481,9080,578,77,2553,9074,58181,2392,18329,6790,21215,1719,1521,1872,11255}'::integer[])) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint))
Planning time : 0.484 ms
Execution time : 2,059.146 ms