explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BpMh

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 53.455 ↑ 1.0 1 1

Unique (cost=8.46..8.47 rows=1 width=9) (actual time=53.454..53.455 rows=1 loops=1)

2. 0.030 53.454 ↑ 1.0 1 1

Sort (cost=8.46..8.47 rows=1 width=9) (actual time=53.453..53.454 rows=1 loops=1)

  • Sort Key: parent_item_id
  • Sort Method: quicksort Memory: 25kB
3. 53.424 53.424 ↑ 1.0 1 1

Index Scan using idx_itemrelation_itemrelationtype on item_relation (cost=0.43..8.45 rows=1 width=9) (actual time=0.035..53.424 rows=1 loops=1)

  • Index Cond: ((item_relation_type)::text = 'ENSEMBLE_PP'::text)
  • Filter: ((child_item_id)::text = 'ppr5007800682'::text)
  • Rows Removed by Filter: 34189
Planning time : 0.265 ms