explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y9ue

Settings
# exclusive inclusive rows x rows loops node
1. 0.062 2,947.228 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.67..125,614.78 rows=2 width=100) (actual time=2,286.378..2,947.228 rows=1 loops=1)

  • -> Index Scan using mokuroku_juchu_universe_index on mokuroku_juchu_universe ju (cost=0.56..0.68 rows=1 width=17) (actual time=
2. 1.827 2,947.166 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.11..125,612.90 rows=2 width=77) (actual time=2,286.317..2,947.166 rows=1 loops=1)

  • -> Index Scan using mokuroku_juchu_mokuroku_index on mokuroku_juchu_mokuroku jm (cost=0.55..2.77 rows=1 width=18) (actual
  • Index Cond: ((jm.cna)::text = (code)::text)
3. 2,945.339 2,945.339 ↑ 2.0 1 1

Nested Loop (cost=0.56..125,607.31 rows=2 width=68) (actual time=2,284.490..2,945.339 rows=1 loops=1)

  • -> Seq Scan on amazon_trade_item (cost=0.00..125605.12 rows=2 width=42) (actual time=2282.221..2943.065 rows=1 loop
  • Index Cond: ((shinaban1)::text = (atoo.proc_get_hinban_del_amazon(amazon_trade_item.sku)))
4. 0.000 0.000 ↓ 0.0

Index Only Scan using amazon_trade_main_trade_code_index on amazon_trade_main (cost=0.56..1.68 rows=1 width=28) (actual rows= loops=)

  • Index Cond: (trade_code = '249-5302858-3476631'::text)
  • Heap Fetches: 0
  • Filter: ((discount_price_conf > 0) AND (fk_trade_code = '249-5302858-3476631'::text))
  • Rows Removed by Filter: 4962807