explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FZWk

Settings
# exclusive inclusive rows x rows loops node
1. 2,129.786 2,129.786 ↓ 578.0 578 1

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 time=83.282..2,129.786 rows=578 loops=1)

  • 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)
Planning time : 0.346 ms
Execution time : 2,129.906 ms