explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QxAc

Settings
# exclusive inclusive rows x rows loops node
1. 2.967 593.081 ↓ 0.0 0 1

Update on platform_fee_calculation_temp (cost=0.55..49,978.21 rows=1 width=2,491) (actual time=593.081..593.081 rows=0 loops=1)

2. 590.114 590.114 ↓ 86.0 86 1

Index Scan using brand_country_game_revenue_summary_unq on platform_fee_calculation_temp (cost=0.55..49,978.21 rows=1 width=2,491) (actual time=152.001..590.114 rows=86 loops=1)

  • Index Cond: (((hub)::text = 'Malta'::text) AND ((server)::text = 'DENMARK'::text) AND (ggr_group = '1128'::numeric) AND ((serial_number)::text = '111053531'::text) AND (platform_id = '1105'::numeric) AND (brand_id = '3531'::numeric))
  • Filter: (date_trunc('MONTH'::text, (revenue_date)::timestamp with time zone) = '2020-01-01 00:00:00+05:30'::timestamp with time zone)
Planning time : 1.437 ms
Execution time : 593.395 ms