explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Lr6

Settings
# exclusive inclusive rows x rows loops node
1. 102.319 1,137.827 ↑ 3.0 1 1

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

  • Workers Planned: 3
  • Workers Launched: 3
  • Functions: 36
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 15.797 ms, Inlining 0.000 ms, Optimization 7.896 ms, Emission 92.895 ms, Total 116.589 ms
2. 0.085 1,035.508 ↓ 0.0 0 4 / 4

Sort (cost=217,721.62..217,721.62 rows=1 width=114) (actual time=1,035.508..1,035.508 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. 105.287 1,035.423 ↓ 0.0 0 4 / 4

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

4. 112.498 112.498 ↑ 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=25.715..112.498 rows=204,410 loops=4)

  • Filter: active
  • Rows Removed by Filter: 3
5. 817.638 817.638 ↓ 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.004..0.004 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.055 ms
Execution time : 1,142.382 ms