explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qtVO

Settings
# exclusive inclusive rows x rows loops node
1. 104.107 1,207.761 ↓ 0.0 0 1

Gather Merge (cost=218,721.66..218,722.01 rows=3 width=114) (actual time=1,156.738..1,207.761 rows=0 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
  • Functions: 36
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 15.155 ms, Inlining 0.000 ms, Optimization 7.422 ms, Emission 71.494 ms, Total 94.071 ms
2. 0.087 1,103.654 ↓ 0.0 0 4 / 4

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

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

4. 118.609 118.609 ↑ 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.111..118.609 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 = '6261149074404'::text) OR ((product_product.barcode)::text = '06261149074404'::text) OR ((product_product.default_code)::text = '6261149074404'::text) OR ((name)::text = '6261149074404'::text)))
  • Rows Removed by Filter: 1
Planning time : 1.253 ms
Execution time : 1,212.269 ms