explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7WIi

Settings
# exclusive inclusive rows x rows loops node
1. 2,327.943 131,115.210 ↓ 19.9 1,678,041 1

Gather (cost=1,000.00..1,099,937.29 rows=84,216 width=445) (actual time=92.279..131,115.210 rows=1,678,041 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 128,787.267 128,787.267 ↓ 15.9 335,608 5 / 5

Parallel Seq Scan on daily_revenue_summary drs (cost=0.00..1,090,515.69 rows=21,054 width=445) (actual time=70.023..128,787.267 rows=335,608 loops=5)

  • Filter: (date_trunc('month'::text, (revenue_date)::timestamp with time zone) = '2020-01-01 00:00:00+05:30'::timestamp with time zone)
  • Rows Removed by Filter: 3027763
Planning time : 0.131 ms
Execution time : 131,355.740 ms