explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d1kc

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 13,819.872 ↑ 1.0 80 1

Limit (cost=2,652,274.29..2,652,283.87 rows=80 width=8) (actual time=13,769.908..13,819.872 rows=80 loops=1)

2. 0.000 13,819.855 ↑ 304,955.1 80 1

Gather Merge (cost=2,652,274.29..5,573,369.43 rows=24,396,408 width=8) (actual time=13,769.906..13,819.855 rows=80 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 7,409.580 68,471.455 ↑ 5,944.5 1,026 5

Sort (cost=2,647,274.23..2,662,521.99 rows=6,099,102 width=8) (actual time=13,694.116..13,694.291 rows=1,026 loops=5)

  • Sort Key: stock_picking__location_id.parent_left
  • Sort Method: external merge Disk: 67576kB
4. 4,625.065 61,061.875 ↑ 1.2 4,912,639 5

Hash Left Join (cost=19.81..1,911,059.15 rows=6,099,102 width=8) (actual time=1.202..12,212.375 rows=4,912,639 loops=5)

  • Hash Cond: (stock_picking.location_id = stock_picking__location_id.id)
5. 56,433.400 56,433.400 ↑ 1.2 4,912,639 5

Parallel Seq Scan on stock_picking (cost=0.00..1,895,022.29 rows=6,099,102 width=8) (actual time=0.269..11,286.680 rows=4,912,639 loops=5)

  • Filter: (((company_id IS NULL) OR (company_id = 1)) AND ((type)::text = 'internal'::text))
  • Rows Removed by Filter: 6253933
6. 3.410 3.410 ↑ 1.0 347 5

Hash (cost=15.47..15.47 rows=347 width=8) (actual time=0.682..0.682 rows=347 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
  • -> Seq Scan on stock_location stock_picking__location_id (cost=0.00..15.47 rows=347 width=8) (actual time=0.030..0.597 rows=347 l
Planning time : 6.041 ms
Execution time : 13,857.141 ms