explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vryp

Settings
# exclusive inclusive rows x rows loops node
1. 79.236 4,342.377 ↑ 1.0 486,556 1

Gather (cost=1,000.00..1,005,897.62 rows=487,835 width=16) (actual time=3,979.528..4,342.377 rows=486,556 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 4,263.141 4,263.141 ↑ 1.3 162,185 3 / 3

Parallel Seq Scan on "EVENT_ASSOCIATION" ea (cost=0.00..956,114.12 rows=203,265 width=16) (actual time=3,975.180..4,263.141 rows=162,185 loops=3)

  • Filter: (("DATE_TIME_LAST_MODIFIED" >= (date_trunc('Mon'::text, (CURRENT_DATE)::timestamp with time zone) - '1 mon'::interval)) AND ("DATE_TIME_LAST_MODIFIED" <= ((date_trunc('Mon'::text, (CURRENT_DATE)::timestamp with time zone))::date - 1)))
  • Rows Removed by Filter: 7,982,594
Planning time : 0.588 ms
Execution time : 4,360.639 ms