explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bqk7

Settings
# exclusive inclusive rows x rows loops node
1. 47.212 181,828.645 ↓ 15,888.0 15,888 1

Nested Loop (cost=0.70..1,476.98 rows=1 width=580) (actual time=154,707.239..181,828.645 rows=15,888 loops=1)

2. 94.343 94.343 ↓ 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.163..94.343 rows=16,270 loops=1)

  • Index Cond: (summary_start_date = date_trunc('MONTH'::text, ('2020-02-10'::date)::timestamp with time zone))
3. 181,687.090 181,687.090 ↑ 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=11.138..11.167 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 : 2.254 ms
Execution time : 181,829.442 ms