explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jFtQ

Settings
# exclusive inclusive rows x rows loops node
1. 101.083 1,207.665 ↓ 0.0 0 1

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

  • Workers Planned: 3
  • Workers Launched: 3
  • Functions: 36
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 14.450 ms, Inlining 0.000 ms, Optimization 6.961 ms, Emission 72.784 ms, Total 94.194 ms
2. 0.084 1,106.582 ↓ 0.0 0 4 / 4

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

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

4. 116.894 116.894 ↑ 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.282..116.894 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 = '8852018101031'::text) OR ((product_product.barcode)::text = '08852018101031'::text) OR ((product_product.default_code)::text = '8852018101031'::text) OR ((name)::text = '8852018101031'::text)))
  • Rows Removed by Filter: 1
Planning time : 1.239 ms
Execution time : 1,211.954 ms