explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5DhT

Settings
# exclusive inclusive rows x rows loops node
1. 2,087.248 262,240.216 ↓ 19.9 1,678,041 1

Gather (cost=1,000.00..1,120,991.20 rows=84,216 width=445) (actual time=191.349..262,240.216 rows=1,678,041 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 260,152.968 260,152.968 ↓ 15.9 335,608 5 / 5

Parallel Seq Scan on daily_revenue_summary drs (cost=0.00..1,111,569.60 rows=21,054 width=445) (actual time=165.477..260,152.968 rows=335,608 loops=5)

  • Filter: (date_trunc('month'::text, (revenue_date)::timestamp with time zone) = date_trunc('month'::text, ('2020-01-01'::date)::timestamp with time zone))
  • Rows Removed by Filter: 3027763
Planning time : 0.107 ms
Execution time : 262,473.804 ms