explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1vTg

Settings
# exclusive inclusive rows x rows loops node
1. 102.352 1,234.151 ↑ 3.0 1 1

Gather Merge (cost=218,721.66..218,722.01 rows=3 width=114) (actual time=1,184.143..1,234.151 rows=1 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
  • Functions: 36
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 13.843 ms, Inlining 0.000 ms, Optimization 7.045 ms, Emission 74.320 ms, Total 95.208 ms
2. 0.073 1,131.799 ↓ 0.0 0 4 / 4

Sort (cost=217,721.62..217,721.62 rows=1 width=114) (actual time=1,131.799..1,131.799 rows=0 loops=4)

  • Sort Key: product_product.default_code, product_product.name_template, product_product.id
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
  • Worker 2: Sort Method: quicksort Memory: 25kB
3. 0.000 1,131.726 ↓ 0.0 0 4 / 4

Nested Loop (cost=0.42..217,721.61 rows=1 width=114) (actual time=851.058..1,131.726 rows=0 loops=4)

4. 115.887 115.887 ↑ 1.3 204,410 4 / 4

Parallel Seq Scan on product_product (cost=0.00..26,186.58 rows=263,758 width=133) (actual time=20.763..115.887 rows=204,410 loops=4)

  • Filter: active
  • Rows Removed by Filter: 3
5. 1,022.048 1,022.048 ↓ 0.0 0 817,638 / 4

Index Scan using product_template_pkey on product_template product_product__product_tmpl_id (cost=0.42..0.72 rows=1 width=98) (actual time=0.005..0.005 rows=0 loops=817,638)

  • Index Cond: (id = product_product.product_tmpl_id)
  • Filter: (available_in_pos AND (((product_product.barcode)::text = '6261149011591'::text) OR ((product_product.barcode)::text = '06261149011591'::text) OR ((product_product.default_code)::text = '6261149011591'::text) OR ((name)::text = '6261149011591'::text)))
  • Rows Removed by Filter: 1
Planning time : 1.063 ms
Execution time : 1,239.173 ms