explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BrIa

Settings
# exclusive inclusive rows x rows loops node
1. 0.499 2,941.487 ↑ 9,634.9 198 1

Sort (cost=738,213.50..742,982.77 rows=1,907,708 width=60) (actual time=2,941.476..2,941.487 rows=198 loops=1)

  • Output: stock_move_move_rel.move_orig_id, stock_move_move_rel.move_dest_id, stock_move__picking_id.priority, stock_move__picking_id.date, stock_move__picking_id.id, stock_move.sequence, stock_move.id
  • Sort Key: stock_move__picking_id.priority DESC, stock_move__picking_id.date, stock_move__picking_id.id DESC, stock_move.sequence, stock_move_move_rel.move_dest_id
  • Sort Method: quicksort Memory: 40kB
  • Buffers: shared hit=1163 read=182801, temp read=17043 written=16979
2. 19.014 2,940.988 ↑ 9,634.9 198 1

Hash Left Join (cost=314,154.74..467,481.54 rows=1,907,708 width=60) (actual time=2,940.771..2,940.988 rows=198 loops=1)

  • Output: stock_move_move_rel.move_orig_id, stock_move_move_rel.move_dest_id, stock_move__picking_id.priority, stock_move__picking_id.date, stock_move__picking_id.id, stock_move.sequence, stock_move.id
  • Inner Unique: true
  • Hash Cond: (stock_move.picking_id = stock_move__picking_id.id)
  • Buffers: shared hit=1154 read=182801, temp read=17043 written=16979
3. 512.150 2,744.479 ↑ 9,634.9 198 1

Hash Join (cost=297,152.35..420,525.36 rows=1,907,708 width=20) (actual time=2,234.869..2,744.479 rows=198 loops=1)

  • Output: stock_move_move_rel.move_orig_id, stock_move_move_rel.move_dest_id, stock_move.sequence, stock_move.id, stock_move.picking_id
  • Inner Unique: true
  • Hash Cond: (stock_move_move_rel.move_dest_id = stock_move.id)
  • Buffers: shared hit=926 read=175245, temp read=16335 written=16273
4. 0.356 0.356 ↑ 9,634.9 198 1

Index Scan using stock_move_move_rel_move_orig_id_idx on public.stock_move_move_rel (cost=0.43..81,781.70 rows=1,907,708 width=8) (actual time=0.020..0.356 rows=198 loops=1)

  • Output: stock_move_move_rel.move_orig_id, stock_move_move_rel.move_dest_id
  • Index Cond: (stock_move_move_rel.move_orig_id = ANY ('{4616453,4616459,4616462,4616465,4616468,4616471,4616474,4616477,4616480,4616483,4616486,4616489,4616492,4616495,4616498,4616501,4616507,4616510,4616513,4616516,4616519,4616522,4616525,4616528,4616531,4616534,4616540,4616543,4616546,4616549,4616552,4616555,4616558,4616561,4616564,4616567,4616570,4616573,4616576,4616579,4616582,4616585,4616588,4616591,4616594,4616597,4616600,4616603,4616606,4616609,4616612,4616615,4616618,4616621,4616624,4616627,4616630,4616633,4616636,4616639,4616642,4616645,4616648,4616651,4616654,4616657,4616663,4616666,4616669,4616672,4616675,4616678,4616681,4616684,4616687,4616690,4616693,4616696,4616699,4616702,4616705,4616708,4616711,4616714,4616717,4616720,4616723,4616726,4616729,4616732,4616735,4616738,4616741,4616744,4616747,4616750,4616753,4616756,4616759,4616762,4616765,4616768,4616771,4616774,4616777,4616780,4616783,4616786,4616789,4616792,4616795,4616798,4616801,4616804,4616807,4616810,4616813,4616816,4616819,4616822,4616825,4616828,4616831,4616834,4616837,4616840,4616843,4616846,4616852,4616855,4616858,4616861,4616864,4616867,4616870,4616873,4616876,4616879,4616882,4616885,4616888,4616891,4616894,4616897,4616900,4616903,4616906,4616909,4616912,4616915,4616918,4616921,4616924,4616927,4616930,4616933,4616936,4616939,4616942,4616945,4616948,4616951,4616954,4616957,4616960,4616963,4616966,4616969,4616972,4616975,4616978,4616981,4616984,4616987,4616990,4616993,4616996,4616999,4617002,4617005,4617008,4617011,4617014,4617017,4617020,4617023,4617026,4617029,4617032,4617035,4617038,4617041,4617044,4617047,4617050,4617053,4617056,4617065}'::integer[]))
  • Buffers: shared hit=600
5. 734.195 2,231.973 ↑ 1.0 4,429,714 1

Hash (cost=219,971.41..219,971.41 rows=4,440,041 width=12) (actual time=2,231.973..2,231.973 rows=4,429,714 loops=1)

  • Output: stock_move.sequence, stock_move.id, stock_move.picking_id
  • Buckets: 524288 Batches: 32 Memory Usage: 9912kB
  • Buffers: shared hit=326 read=175245, temp written=16211
6. 1,497.778 1,497.778 ↑ 1.0 4,429,714 1

Seq Scan on public.stock_move (cost=0.00..219,971.41 rows=4,440,041 width=12) (actual time=0.063..1,497.778 rows=4,429,714 loops=1)

  • Output: stock_move.sequence, stock_move.id, stock_move.picking_id
  • Buffers: shared hit=326 read=175245
7. 80.746 177.495 ↑ 1.0 288,509 1

Hash (cost=10,729.95..10,729.95 rows=294,595 width=44) (actual time=177.495..177.495 rows=288,509 loops=1)

  • Output: stock_move__picking_id.priority, stock_move__picking_id.date, stock_move__picking_id.id
  • Buckets: 262144 Batches: 2 Memory Usage: 9376kB
  • Buffers: shared hit=228 read=7556, temp written=704
8. 96.749 96.749 ↑ 1.0 288,509 1

Seq Scan on public.stock_picking stock_move__picking_id (cost=0.00..10,729.95 rows=294,595 width=44) (actual time=0.059..96.749 rows=288,509 loops=1)

  • Output: stock_move__picking_id.priority, stock_move__picking_id.date, stock_move__picking_id.id
  • Buffers: shared hit=228 read=7556
Planning time : 2.300 ms
Execution time : 2,941.621 ms