explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qEhn

Settings
# exclusive inclusive rows x rows loops node
1. 933.204 6,628.906 ↓ 5.0 5,997 1

GroupAggregate (cost=1,496,113.69..1,534,005.81 rows=1,208 width=12) (actual time=5,237.880..6,628.906 rows=5,997 loops=1)

  • Group Key: t2608_emailactivityaccountfact_copy_sentha.c9638_accountid
2. 1,638.861 5,695.702 ↑ 1.0 4,829,886 1

Sort (cost=1,496,113.69..1,508,740.37 rows=5,050,672 width=8) (actual time=5,237.755..5,695.702 rows=4,829,886 loops=1)

  • Sort Key: t2608_emailactivityaccountfact_copy_sentha.c9638_accountid
  • Sort Method: external merge Disk: 85,128kB
3. 4,056.841 4,056.841 ↑ 1.0 4,829,886 1

Seq Scan on t2608_emailactivityaccountfact_copy_sentha (cost=0.00..795,660.76 rows=5,050,672 width=8) (actual time=0.011..4,056.841 rows=4,829,886 loops=1)

  • Filter: ((NOT deleted) AND c9660_isinternalinitiated AND c9657_isshared AND (start_stamp <= '1593173652000'::bigint) AND (end_stamp > '1593173652000'::bigint) AND (c9653_activitydate >= '1561532400000'::bigint) AND (c9653_activitydate < '1593241200000'::bigint))
  • Rows Removed by Filter: 14,034,703
Planning time : 0.476 ms
Execution time : 6,643.442 ms