explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2nl2

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 18,889.591 ↑ 1.0 15,193,039 1

Gather Merge (cost=2,452,381.24..4,287,506.18 rows=15,326,600 width=26) (actual time=11,551.018..18,889.591 rows=15,193,039 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 11,502.785 59,640.020 ↑ 1.3 3,038,608 5

Sort (cost=2,447,381.18..2,456,960.31 rows=3,831,650 width=26) (actual time=11,459.796..11,928.004 rows=3,038,608 loops=5)

  • Sort Key: stock_picking.state, stock_picking.user_done, stock_picking__location_id.parent_left
  • Sort Method: external merge Disk: 58872kB
3. 4,180.515 48,137.235 ↑ 1.3 3,038,608 5

Hash Left Join (cost=19.81..1,974,703.53 rows=3,831,650 width=26) (actual time=0.493..9,627.447 rows=3,038,608 loops=5)

  • Hash Cond: (stock_picking.location_id = stock_picking__location_id.id)
4. 43,955.505 43,955.505 ↑ 1.3 3,038,608 5

Parallel Seq Scan on stock_picking (cost=0.00..1,964,621.30 rows=3,831,650 width=30) (actual time=0.077..8,791.101 rows=3,038,608 loops=5)

  • Filter: (((company_id IS NULL) OR (company_id = 1)) AND ((type)::text = 'internal'::text) AND (((name)::text = '9'::text) OR ((origin)::t
  • Rows Removed by Filter: 8127964
5. 1.215 1.215 ↑ 1.0 347 5

Hash (cost=15.47..15.47 rows=347 width=8) (actual time=0.243..0.243 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.022..0.182 rows=347 loops=5
Planning time : 6.560 ms
Execution time : 19,659.560 ms