explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yakM

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.386 ↓ 0.0 0 1

GroupAggregate (cost=2,840.46..3,086.79 rows=238 width=4) (actual time=0.386..0.386 rows=0 loops=1)

  • Group Key: pd.id
  • Filter: bool_and(((COALESCE(extract_custom_prices(pd.custom_prices, jsonb_array_to_text_array((paths.root_level_paths_deadline_by_nns_id -> (p.ninushi_id)::text)), paths.nested_paths_deadline, 0), pd.unit_price) = '0'::double precision) AND (COALESCE(extract_custom_prices(pd.custom_prices, jsonb_array_to_text_array((paths.root_level_paths_deadline_by_nns_id -> (p.ninushi_id)::text)), paths.nested_paths_deadline, 0), pd.unit_price) IS NOT NULL)))
2.          

CTE paths

3. 0.000 0.000 ↓ 0.0 0

Function Scan on get_custom_values_path paths_1 (cost=0.25..25.25 rows=1,000 width=212) (never executed)

4. 0.007 0.385 ↓ 0.0 0 1

Sort (cost=2,815.21..2,815.80 rows=238 width=618) (actual time=0.385..0.385 rows=0 loops=1)

  • Sort Key: pd.id
  • Sort Method: quicksort Memory: 25kB
5. 0.000 0.378 ↓ 0.0 0 1

Hash Join (cost=36.00..2,805.81 rows=238 width=618) (actual time=0.378..0.378 rows=0 loops=1)

  • Hash Cond: (((unnest('{20001163}'::integer[])) = paths.market_uid) AND ((20001163) = paths.uid_child_of_market))
6. 0.001 0.378 ↓ 0.0 0 1

ProjectSet (cost=1.00..250.93 rows=9,500 width=562) (actual time=0.378..0.378 rows=0 loops=1)

7. 0.001 0.377 ↓ 0.0 0 1

Nested Loop (cost=1.00..202.72 rows=95 width=554) (actual time=0.377..0.377 rows=0 loops=1)

8. 0.001 0.376 ↓ 0.0 0 1

Nested Loop (cost=0.57..26.40 rows=5 width=8) (actual time=0.376..0.376 rows=0 loops=1)

9. 0.375 0.375 ↓ 0.0 0 1

Index Scan using proposal_pkey on proposal p (cost=0.29..8.30 rows=1 width=8) (actual time=0.375..0.375 rows=0 loops=1)

  • Index Cond: (id = 12700)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using proposal_panel_proposal_id_idx on proposal_panel pp (cost=0.29..18.05 rows=5 width=8) (never executed)

  • Index Cond: (proposal_id = 12700)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using proposal_detail_proposal_panel_id_idx on proposal_detail pd (cost=0.42..34.82 rows=44 width=554) (never executed)

  • Index Cond: (proposal_panel_id = pp.id)
12. 0.000 0.000 ↓ 0.0 0

Hash (cost=20.00..20.00 rows=1,000 width=72) (never executed)

13. 0.000 0.000 ↓ 0.0 0

CTE Scan on paths (cost=0.00..20.00 rows=1,000 width=72) (never executed)

Planning time : 9.692 ms
Execution time : 0.517 ms