explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xwam

Settings
# exclusive inclusive rows x rows loops node
1. 466.768 2,112.680 ↑ 30.2 40 1

GroupAggregate (cost=719,122.14..727,868.56 rows=1,208 width=12) (actual time=1,482.687..2,112.680 rows=40 loops=1)

  • Group Key: t2608_emailactivityaccountfact_copy_sentha.c9638_accountid
2. 586.707 1,645.912 ↓ 1.7 1,936,087 1

Sort (cost=719,122.14..722,033.59 rows=1,164,579 width=8) (actual time=1,464.258..1,645.912 rows=1,936,087 loops=1)

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

Bitmap Heap Scan on t2608_emailactivityaccountfact_copy_sentha (cost=72,452.44..585,857.78 rows=1,164,579 width=8) (actual time=143.274..1,059.205 rows=1,936,087 loops=1)

  • 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: 412,461
  • Filter: ((NOT c9660_isinternalinitiated) AND (c9653_activitydate >= '1561532400000'::bigint) AND (c9653_activitydate < '1593241200000'::bigint))
  • Rows Removed by Filter: 383,303
  • Heap Blocks: exact=41,807 lossy=33,419
4. 136.683 136.683 ↓ 1.6 2,144,115 1

Bitmap Index Scan on idx_accounid_isinternal_end_start_sentha1 (cost=0.00..72,161.30 rows=1,357,662 width=0) (actual time=136.683..136.683 rows=2,144,115 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 (c9660_isinternalinitiated = false) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint))
Planning time : 0.641 ms
Execution time : 2,119.114 ms