explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y6V5

Settings
# exclusive inclusive rows x rows loops node
1. 102.790 1,216.881 ↓ 0.0 0 1

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

  • Workers Planned: 3
  • Workers Launched: 3
  • Functions: 36
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 15.587 ms, Inlining 0.000 ms, Optimization 7.836 ms, Emission 70.161 ms, Total 93.583 ms
2. 0.078 1,114.091 ↓ 0.0 0 4 / 4

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

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

4. 113.945 113.945 ↑ 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=19.890..113.945 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 = 'مجسمه خمیری'::text) OR ((product_product.barcode)::text = '0مجسمه خمیری'::text) OR ((product_product.default_code)::text = 'مجسمه خمیری'::text) OR ((name)::text = 'مجسمه خمیری'::text)))
  • Rows Removed by Filter: 1
Planning time : 1.228 ms
Execution time : 1,221.783 ms