explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UoYc

Settings
# exclusive inclusive rows x rows loops node
1. 0.215 39.155 ↓ 0.0 0 1

Limit (cost=5,452.49..5,452.49 rows=1 width=22) (actual time=39.155..39.155 rows=0 loops=1)

2. 13.367 38.940 ↑ 1.0 9,735 1

Sort (cost=5,427.38..5,452.49 rows=10,043 width=22) (actual time=38.553..38.940 rows=9,735 loops=1)

  • Sort Key: stock_move__picking_id.priority DESC, stock_move__picking_id.date, stock_move__picking_id.id DESC, stock_move.sequence, stock_move.id
  • Sort Method: quicksort Memory: 1145kB
3. 2.312 25.573 ↑ 1.0 9,735 1

Hash Left Join (cost=477.63..4,759.83 rows=10,043 width=22) (actual time=5.457..25.573 rows=9,735 loops=1)

  • Hash Cond: (stock_move.picking_id = stock_move__picking_id.id)
4. 17.844 17.844 ↑ 1.0 9,735 1

Seq Scan on stock_move (cost=0.00..4,255.82 rows=10,043 width=12) (actual time=0.022..17.844 rows=9,735 loops=1)

  • Filter: (((state)::text <> ALL ('{done,cancel}'::text[])) OR (state IS NULL))
  • Rows Removed by Filter: 62171
5. 2.355 5.417 ↑ 1.0 9,228 1

Hash (cost=362.28..362.28 rows=9,228 width=14) (actual time=5.417..5.417 rows=9,228 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 597kB
6. 3.062 3.062 ↑ 1.0 9,228 1

Seq Scan on stock_picking stock_move__picking_id (cost=0.00..362.28 rows=9,228 width=14) (actual time=0.008..3.062 rows=9,228 loops=1)

Planning time : 0.638 ms
Execution time : 39.206 ms