explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QfbY

Settings
# exclusive inclusive rows x rows loops node
1. 9.213 283.476 ↓ 15,888.0 15,888 1

Nested Loop (cost=0.28..36,582.73 rows=1 width=580) (actual time=167.319..283.476 rows=15,888 loops=1)

2. 194.823 194.823 ↓ 92.9 15,888 1

Seq Scan on platform_fee_calculation_temp (cost=0.00..36,283.56 rows=171 width=548) (actual time=167.250..194.823 rows=15,888 loops=1)

  • Filter: ((NOT isbasecurrencybased) AND (upper((currency_from)::text) <> 'BASE'::text) AND (date_trunc('MONTH'::text, (revenue_date)::timestamp with time zone) = date_trunc('MONTH'::text, ('2020-02-10'::date)::timestamp with time zone)))
3. 79.440 79.440 ↑ 1.0 1 15,888

Index Scan using daily_currency_rate_temp_currency_symbol_server_summary_sta_idx on daily_currency_rate_temp cc (cost=0.28..1.74 rows=1 width=180) (actual time=0.004..0.005 rows=1 loops=15,888)

  • Index Cond: (((currency_symbol)::text = (platform_fee_calculation_temp.currency_from)::text) AND ((server)::text = (platform_fee_calculation_temp.server)::text))
  • Filter: (platform_fee_calculation_temp.revenue_date = summary)
  • Rows Removed by Filter: 9
Planning time : 1.188 ms
Execution time : 297.160 ms