explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n4yn

Settings
# exclusive inclusive rows x rows loops node
1. 14.150 1,619.241 ↓ 15,888.0 15,888 1

Nested Loop (cost=0.28..36,598.35 rows=1 width=580) (actual time=127.942..1,619.241 rows=15,888 loops=1)

2. 159.283 159.283 ↓ 92.9 15,888 1

Seq Scan on platform_fee_calculation_temp pfct (cost=0.00..36,283.56 rows=171 width=548) (actual time=127.896..159.283 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. 1,445.808 1,445.808 ↑ 1.0 1 15,888

Index Scan using daily_currency_rate_temp_summary_currency_id_server_idx on daily_currency_rate_temp cc (cost=0.28..1.83 rows=1 width=180) (actual time=0.005..0.091 rows=1 loops=15,888)

  • Index Cond: ((summary = pfct.revenue_date) AND ((server)::text = (pfct.server)::text))
  • Filter: ((pfct.currency_from)::text = (currency_symbol)::text)
  • Rows Removed by Filter: 198
Planning time : 0.489 ms
Execution time : 1,619.971 ms