explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wxh2

Settings
# exclusive inclusive rows x rows loops node
1. 40,629.171 57,058.376 ↓ 0.0 0 1

Update on daily_revenue_summary drs (cost=0.56..1,276,415.20 rows=1 width=576) (actual time=57,058.376..57,058.376 rows=0 loops=1)

2. 674.008 16,429.205 ↓ 1,088,587.0 1,088,587 1

Nested Loop (cost=0.56..1,276,415.20 rows=1 width=576) (actual time=311.704..16,429.205 rows=1,088,587 loops=1)

3. 1,603.566 1,603.566 ↓ 2.2 1,088,587 1

Seq Scan on promo_deduction_temp pdt (cost=0.00..125,881.60 rows=484,160 width=682) (actual time=311.606..1,603.566 rows=1,088,587 loops=1)

4. 14,151.631 14,151.631 ↑ 1.0 1 1,088,587

Index Scan using daily_revenue_summary_unq on daily_revenue_summary drs (cost=0.56..2.38 rows=1 width=402) (actual time=0.013..0.013 rows=1 loops=1,088,587)

  • Index Cond: ((revenue_date = pdt.revenue_date) AND ((hub)::text = (pdt.hub)::text) AND ((server)::text = (pdt.server)::text) AND (ggr_group = pdt.ggr_group) AND ((serial_number)::text = (pdt.serial_number)::text) AND (platform_id = pdt.platform_id) AND (brand_id = pdt.brand_id) AND ((country_id)::text = (pdt.country_id)::text) AND (currency_id = pdt.currency_id) AND (game_id = pdt.game_id))
Planning time : 1.490 ms
Execution time : 57,058.614 ms