explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QkJh : Optimization for: plan #fqA

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 22,507.644 832,247.989 ↓ 0.0 0 1

Update on view_actual_honda (cost=0.67..2,474.25 rows=1,000 width=617) (actual time=832,247.989..832,247.989 rows=0 loops=1)

2. 161.651 809,740.345 ↓ 356.7 356,683 1

Nested Loop (cost=0.67..2,474.25 rows=1,000 width=617) (actual time=808,082.150..809,740.345 rows=356,683 loops=1)

3. 808,151.962 808,151.962 ↓ 356.7 356,683 1

Function Scan on get_all_site_bonuses (cost=0.25..10.25 rows=1,000 width=216) (actual time=808,082.125..808,151.962 rows=356,683 loops=1)

4. 1,426.732 1,426.732 ↑ 1.0 1 356,683

Index Scan using view_new_honda_pkey on view_actual_honda (cost=0.42..2.46 rows=1 width=433) (actual time=0.004..0.004 rows=1 loops=356,683)

  • Index Cond: (link_sku = get_all_site_bonuses.link_sku)
Planning time : 15.596 ms
Execution time : 832,263.853 ms