explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fqA

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 7,395.474 31,979.238 ↓ 0.0 0 1

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

2. 147.359 24,583.764 ↓ 356.7 356,683 1

Nested Loop (cost=0.67..2,474.25 rows=1,000 width=617) (actual time=22,936.630..24,583.764 rows=356,683 loops=1)

3. 23,009.673 23,009.673 ↓ 356.7 356,683 1

Function Scan on get_bonuses_test (cost=0.25..10.25 rows=1,000 width=216) (actual time=22,936.606..23,009.673 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_bonuses_test.link_sku)