explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vePm

Settings
# exclusive inclusive rows x rows loops node
1. 82,445.457 82,445.457 ↓ 149.9 15,888 1

Index Scan using daily_revenue_summary_unq on daily_revenue_summary (cost=0.69..1,003,029.38 rows=106 width=471) (actual time=63,706.732..82,445.457 rows=15,888 loops=1)

  • Index Cond: (ggr_group = '217'::numeric)
  • Filter: (date_trunc('MONTH'::text, (revenue_date)::timestamp with time zone) = date_trunc('MONTH'::text, ('2020-02-01'::date)::timestamp with time zone))
  • Rows Removed by Filter: 45,328
Planning time : 3.542 ms
Execution time : 82,448.264 ms