explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kk57

Settings
# exclusive inclusive rows x rows loops node
1. 468.602 2,113.768 ↑ 30.2 40 1

GroupAggregate (cost=718,004.33..726,750.75 rows=1,208 width=12) (actual time=1,478.120..2,113.768 rows=40 loops=1)

  • Group Key: t2608_emailactivityaccountfact_copy_sentha.c9638_accountid
2. 584.919 1,645.166 ↓ 1.7 1,936,087 1

Sort (cost=718,004.33..720,915.78 rows=1,164,579 width=8) (actual time=1,459.540..1,645.166 rows=1,936,087 loops=1)

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

Bitmap Heap Scan on t2608_emailactivityaccountfact_copy_sentha (cost=84,850.44..584,739.97 rows=1,164,579 width=8) (actual time=187.526..1,060.247 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 (c9653_activitydate >= '1561532400000'::bigint) AND (c9653_activitydate < '1593241200000'::bigint) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint) AND c9657_isshared AND (NOT deleted))
  • Rows Removed by Index Recheck: 508,134
  • Filter: (NOT c9660_isinternalinitiated)
  • Rows Removed by Filter: 153,477
  • Heap Blocks: exact=39,932 lossy=33,447
4. 180.744 180.744 ↓ 1.7 1,936,087 1

Bitmap Index Scan on "idx_accounid_isin_date_emd_Start_sentha1" (cost=0.00..84,559.30 rows=1,164,579 width=0) (actual time=180.744..180.744 rows=1,936,087 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 (c9653_activitydate >= '1561532400000'::bigint) AND (c9653_activitydate < '1593241200000'::bigint) AND (end_stamp > '1593172558000'::bigint) AND (start_stamp <= '1593172558000'::bigint))
Planning time : 0.636 ms
Execution time : 2,120.208 ms