explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ahgw

Settings
# exclusive inclusive rows x rows loops node
1. 14.357 14.357 ↓ 207.3 2,280 1

Index Scan using revenue_parameters_pkey2 on revenue_parameters (cost=0.42..3,364.44 rows=11 width=2,681) (actual time=0.087..14.357 rows=2,280 loops=1)

  • Index Cond: (date_month = date_trunc('MONTH'::text, ('2020-02-01'::date)::timestamp with time zone))
  • Filter: (upper((product_type)::text) = 'SLOTS'::text)
  • Rows Removed by Filter: 5
Planning time : 0.325 ms
Execution time : 14.624 ms