explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kKpM

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Index Scan using brand_country_game_revenue_summary_unq on platform_fee_calculation_temp (cost=0.55..161,530.51 rows=1 width=2,420) (actual rows= loops=)

  • Index Cond: (((hub)::text = 'Malta'::text) AND ((server)::text = 'DENMARK'::text) AND (ggr_group = '88'::numeric) AND ((serial_number)::text = '112683111'::text) AND (platform_id = '1268'::numeric) AND (brand_id = '3111'::numeric))
  • Filter: (date_trunc('MONTH'::text, (revenue_date)::timestamp with time zone) = '2019-12-01 00:00:00+05:30'::timestamp with time zone)