explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y845

Settings
# exclusive inclusive rows x rows loops node
1. 43.024 176,614.089 ↓ 15,888.0 15,888 1

Nested Loop (cost=0.70..1,476.98 rows=1 width=580) (actual time=153,276.530..176,614.089 rows=15,888 loops=1)

2. 90.375 90.375 ↓ 707.4 16,270 1

Index Scan using daily_currency_rate_temp_currency_symbol_server_summary_sta_idx on daily_currency_rate_temp cc (cost=0.29..164.02 rows=23 width=180) (actual time=0.098..90.375 rows=16,270 loops=1)

  • Index Cond: (summary_start_date = date_trunc('MONTH'::text, ('2020-02-01'::date)::timestamp with time zone))
3. 176,480.690 176,480.690 ↑ 1.0 1 16,270

Index Scan using brand_country_game_revenue_summary_unq on platform_fee_calculation_temp pfct (cost=0.42..57.08 rows=1 width=548) (actual time=10.818..10.847 rows=1 loops=16,270)

  • Index Cond: ((revenue_date = cc.summary) AND ((server)::text = (cc.server)::text))
  • Filter: ((NOT isbasecurrencybased) AND ((cc.currency_symbol)::text = (currency_from)::text) AND (upper((currency_from)::text) <> 'BASE'::text))
  • Rows Removed by Filter: 193
Planning time : 1.892 ms
Execution time : 176,626.753 ms