explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EPJv

Settings
# exclusive inclusive rows x rows loops node
1. 3,036.113 3,036.113 ↓ 149.9 15,888 1

Index Scan using daily_revenue_summary_unq on daily_revenue_summary (cost=0.69..1,003,578.38 rows=106 width=471) (actual time=2,586.809..3,036.113 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: 45328
Planning time : 1.018 ms
Execution time : 3,036.829 ms