explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iDWVQ

Settings
# exclusive inclusive rows x rows loops node
1. 566.780 5,916.376 ↑ 1.4 107 1

Gather Merge (cost=662,961.99..662,980.19 rows=152 width=34) (actual time=5,355.390..5,916.376 rows=107 loops=1)

  • Workers Planned: 4
  • Workers Launched: 3
2. 0.085 5,349.596 ↑ 1.4 27 4 / 4

Sort (cost=661,961.93..661,962.03 rows=38 width=34) (actual time=5,349.593..5,349.596 rows=27 loops=4)

  • Sort Key: stock_move_line__product_id.default_code, stock_move_line__product_id__product_tmpl_id.name, stock_move_line__product_id.id, stock_move_line.id
  • Sort Method: quicksort Memory: 28kB
3. 0.035 5,349.511 ↑ 1.4 27 4 / 4

Nested Loop Left Join (cost=0.57..661,960.94 rows=38 width=34) (actual time=5,287.401..5,349.511 rows=27 loops=4)

4. 0.047 5,349.316 ↑ 1.4 27 4 / 4

Nested Loop Left Join (cost=0.29..661,947.78 rows=38 width=16) (actual time=5,287.371..5,349.316 rows=27 loops=4)

5. 5,349.082 5,349.082 ↑ 1.4 27 4 / 4

Parallel Seq Scan on stock_move_line (cost=0.00..661,902.35 rows=38 width=8) (actual time=5,287.322..5,349.082 rows=27 loops=4)

  • Filter: (move_id = ANY ('{14135306,14133773,14136336,14133783,14135834,14134816,14134310,14135853,14133806,14135356,14136380,14133824,14134849,14135878,14134349,14133845,14135894,14135899,14135908,14133865,14135407,14133872,14136432,14135925,14134910,14134406,14135956,14135447,14133913,14136476,14135971,14134954,14136493,14135479,14135992,14134459,14135997,14136509,14136003,14136516,14136525,14136014,14135507,14136531,14134999,14136536,14136538,14136542,14136545,14133989,14135526,14136550,14136552,14136556,14136559,14136561,14136563,14136567,14135544,14136569,14136571,14136573,14136575,14136577,14136580,14134533,14136070,14136582,14136584,14136586,14136588,14136590,14136592,14135063,14135576,14135582,14134047,14135586,14135596,14134264,14135610,14136126,14134089,14134602,14135632,14136155,14134114,14135142,14135800,14136168,14134635,14135667,14134142,14134665,14136211,14134164,14135708,14135203,14134183,14134705,14135742,14134209,14135767,14135257,14136285,14134773,14136312}'::integer[]))
  • Rows Removed by Filter: 2,963,590
6. 0.187 0.187 ↑ 1.0 1 107 / 4

Index Scan using product_product_pkey on product_product stock_move_line__product_id (cost=0.29..1.20 rows=1 width=12) (actual time=0.007..0.007 rows=1 loops=107)

  • Index Cond: (stock_move_line.product_id = id)
7. 0.161 0.161 ↑ 1.0 1 107 / 4

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.006..0.006 rows=1 loops=107)

  • Index Cond: (stock_move_line__product_id.product_tmpl_id = id)
Planning time : 0.862 ms
Execution time : 5,916.497 ms