explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yJ60

Settings
# exclusive inclusive rows x rows loops node
1. 2.133 33,539.436 ↑ 4.7 1,050 1

Gather Merge (cost=925,114.30..925,706.75 rows=4,948 width=44) (actual time=33,538.978..33,539.436 rows=1,050 loops=1)

  • Workers Planned: 4
  • Workers Launched: 0
2. 1.433 33,537.303 ↑ 1.2 1,050 1

Sort (cost=924,114.25..924,117.34 rows=1,237 width=44) (actual time=33,537.219..33,537.303 rows=1,050 loops=1)

  • Sort Key: stock_move_line__product_id.default_code, (COALESCE(stock_move_line__product_id__product_tmpl_id__name.value, (stock_move_line__product_id__product_tmpl_id.name)::text)), stock_move_line__product_id.id, stock_move_line.id
  • Sort Method: quicksort Memory: 131kB
3. 0.700 33,535.870 ↑ 1.2 1,050 1

Hash Left Join (cost=353.77..924,050.71 rows=1,237 width=44) (actual time=5,980.128..33,535.870 rows=1,050 loops=1)

  • Hash Cond: (stock_move_line__product_id__product_tmpl_id.id = stock_move_line__product_id__product_tmpl_id__name.res_id)
4. 1.655 33,535.145 ↑ 1.2 1,050 1

Nested Loop Left Join (cost=351.93..924,045.62 rows=1,237 width=38) (actual time=5,980.086..33,535.145 rows=1,050 loops=1)

5. 1.417 33,528.240 ↑ 1.2 1,050 1

Hash Left Join (cost=351.64..923,617.31 rows=1,237 width=16) (actual time=5,980.057..33,528.240 rows=1,050 loops=1)

  • Hash Cond: (stock_move_line.product_id = stock_move_line__product_id.id)
6. 33,522.813 33,522.813 ↑ 1.2 1,050 1

Parallel Seq Scan on stock_move_line (cost=0.00..923,262.42 rows=1,237 width=8) (actual time=5,975.954..33,522.813 rows=1,050 loops=1)

  • Filter: (picking_id = ANY ('{2706750,2738283,3246542,3374643,3387943,3388068,3473869,3526084,3568324,3578808,3597529,3598941,3608442,3608522,3608785,3610180,3618648,3618655,3619227,3619572,3619684,3627869,3646298,3646323,3646337,3646381,3647781,3647806,3647859,3647956,3647979,3648600,3648633,3648789,3648790,3648834,3649025,3650055,3665158,3665270,3665289,3665302,3665304,3665317,3665607,3665614,3666141,3666651,3681758,3681780,3681799,3681845,3681854,3681908,3681925,3681929,3681934,3681947,3681962,3682023,3682033,3682041,3682049,3682061,3682074,3682083,3682087,3682094,3682310,3682957,3682966,3683396,3683451,3708495,3708538,3709158,3709167,3709283,3709286,3709288,3709491,3709510,3709524,3709531,3709584,3709600,3709603,3709614,3710502,3712167,3712173,3712182,3712184,3712187,3712375,3712385,3712397,3712403,3712409,3712441,3712463,3712512,3712514,3712551,3712563,3733182,3897873,3911219,3911273,3911559,3911702,3911724,3911745,3941992,3942127,3942562,3943002,3943003,3943007,4064881,4122296,4126411,4140250,4140820,4163850,4174974,4175137,4175139,4187453,4212217,4215226,4217951,4242328,4263477,4263601,4263617,4263761,4263818,4263855,4263869,4287737,4287747,4288037,4289052,4289113,4289131,4289174,4289572,4289650,4463106,4463358,4490735,4490899,4491127,4491135,4491144,4491576,4491705,4491727,4548216,4560966,4560974,4602311,4602316,4614904,4614911,4629844,4646283,4660849,4660863,4731603,4749026,4801201,4801208,4801210,4837892,5030966}'::integer[]))
  • Rows Removed by Filter: 11,852,723
7. 1.710 4.010 ↓ 1.0 10,389 1

Hash (cost=221.84..221.84 rows=10,384 width=12) (actual time=4.010..4.010 rows=10,389 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 575kB
8. 2.300 2.300 ↓ 1.0 10,389 1

Seq Scan on product_product stock_move_line__product_id (cost=0.00..221.84 rows=10,384 width=12) (actual time=0.011..2.300 rows=10,389 loops=1)

9. 5.250 5.250 ↑ 1.0 1 1,050

Index Scan using product_template_pkey on product_template stock_move_line__product_id__product_tmpl_id (cost=0.29..0.35 rows=1 width=26) (actual time=0.005..0.005 rows=1 loops=1,050)

  • Index Cond: (stock_move_line__product_id.product_tmpl_id = id)
10. 0.000 0.025 ↓ 0.0 0 1

Hash (cost=1.83..1.83 rows=1 width=26) (actual time=0.025..0.025 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
11. 0.001 0.025 ↓ 0.0 0 1

Subquery Scan on stock_move_line__product_id__product_tmpl_id__name (cost=1.82..1.83 rows=1 width=26) (actual time=0.024..0.025 rows=0 loops=1)

12. 0.001 0.024 ↓ 0.0 0 1

Unique (cost=1.82..1.82 rows=1 width=30) (actual time=0.024..0.024 rows=0 loops=1)

13. 0.008 0.023 ↓ 0.0 0 1

Sort (cost=1.82..1.82 rows=1 width=30) (actual time=0.023..0.023 rows=0 loops=1)

  • Sort Key: ir_translation.res_id, ir_translation.id DESC
  • Sort Method: quicksort Memory: 25kB
14. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on ir_translation (cost=0.00..1.81 rows=1 width=30) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: ((value <> ''::text) AND ((name)::text = 'product.template,name'::text) AND ((lang)::text = 'en_US'::text))
  • Rows Removed by Filter: 46
Planning time : 3.963 ms
Execution time : 33,539.817 ms