explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jo1m

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 72.557 ↑ 1.0 1 1

Nested Loop (cost=1,000.28..75,638.62 rows=1 width=62) (actual time=0.500..72.557 rows=1 loops=1)

2. 0.023 0.023 ↑ 1.0 1 1

Index Scan using item_rating_review_pkey on item_rating_review rr (cost=0.29..8.30 rows=1 width=49) (actual time=0.021..0.023 rows=1 loops=1)

  • Index Cond: ((rating_review_id)::text = 'ppr5007190221'::text)
3. 2.710 73.586 ↑ 1.0 1 1

Gather (cost=1,000.00..75,630.31 rows=1 width=26) (actual time=0.476..73.586 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 70.876 70.876 ↓ 0.0 0 3

Parallel Seq Scan on product_presentation pp (cost=0.00..74,630.21 rows=1 width=26) (actual time=46.868..70.876 rows=0 loops=3)

  • Filter: ((rating_review_id)::text = 'ppr5007190221'::text)
  • Rows Removed by Filter: 272429