explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2nnJ

Settings
# exclusive inclusive rows x rows loops node
1. 472.153 2,089.768 ↑ 30.2 40 1

GroupAggregate (cost=935,246.69..943,993.12 rows=1,208 width=12) (actual time=1,450.992..2,089.768 rows=40 loops=1)

  • Group Key: t2608_emailactivityaccountfact_copy_sentha.c9638_accountid
2. 586.889 1,617.615 ↓ 1.7 1,936,087 1

Sort (cost=935,246.69..938,158.14 rows=1,164,579 width=8) (actual time=1,432.331..1,617.615 rows=1,936,087 loops=1)

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

Gather (cost=165,298.64..801,982.34 rows=1,164,579 width=8) (actual time=281.112..1,030.726 rows=1,936,087 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 686.695 776.062 ↓ 1.3 645,362 3 / 3

Parallel Bitmap Heap Scan on t2608_emailactivityaccountfact_copy_sentha (cost=164,298.64..684,524.44 rows=485,241 width=8) (actual time=208.302..776.062 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))
  • Rows Removed by Index Recheck: 261,385
  • Filter: ((NOT deleted) AND (NOT c9660_isinternalinitiated) AND c9657_isshared AND (c9653_activitydate >= '1561532400000'::bigint) AND (c9653_activitydate < '1593241200000'::bigint))
  • Rows Removed by Filter: 796,426
  • Heap Blocks: exact=9,056 lossy=12,045
5. 89.367 89.367 ↓ 1.2 4,325,366 1 / 3

Bitmap Index Scan on idx_2185_t2608_emailactivityaccountfact_copy_sentha_c9638_accou (cost=0.00..164,007.50 rows=3,492,233 width=0) (actual time=268.100..268.100 rows=4,325,366 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.439 ms
Execution time : 2,098.987 ms