explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3WDE : Optimization for: Optimization for: plan #pGVZ; plan #ilWg

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 428.686 428.686 ↑ 2.8 1,370 1

Seq Scan on alerts (cost=0.00..171,592.16 rows=3,800 width=3,003) (actual time=150.136..428.686 rows=1,370 loops=1)

  • Filter: (((effectiveoncallgroup)::text = ANY ('{dba,DBA}'::text[])) AND (datereceived >= '2020-08-01 00:00:00'::timestamp without time zone) AND (datereceived <= '2020-08-30 23:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 679,275