explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m2cx

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 7,491.337 ↑ 1.0 80 1

Limit (cost=2,398,685.59..2,398,695.17 rows=80 width=8) (actual time=7,447.756..7,491.337 rows=80 loops=1)

2. 0.000 7,491.320 ↑ 191,582.5 80 1

Gather Merge (cost=2,398,685.59..4,233,810.53 rows=15,326,600 width=8) (actual time=7,447.754..7,491.320 rows=80 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 4,751.805 36,925.160 ↑ 3,421.1 1,120 5

Sort (cost=2,393,685.53..2,403,264.66 rows=3,831,650 width=8) (actual time=7,384.881..7,385.032 rows=1,120 loops=5)

  • Sort Key: stock_picking__location_id.parent_left
  • Sort Method: external merge Disk: 44528kB
4. 2,712.285 32,173.355 ↑ 1.3 3,038,608 5

Hash Left Join (cost=19.81..1,974,703.53 rows=3,831,650 width=8) (actual time=0.451..6,434.671 rows=3,038,608 loops=5)

  • Hash Cond: (stock_picking.location_id = stock_picking__location_id.id)
5. 29,459.875 29,459.875 ↑ 1.3 3,038,608 5

Parallel Seq Scan on stock_picking (cost=0.00..1,964,621.30 rows=3,831,650 width=12) (actual time=0.066..5,891.975 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 ((orig
  • Rows Removed by Filter: 8127964
6. 1.195 1.195 ↑ 1.0 347 5

Hash (cost=15.47..15.47 rows=347 width=8) (actual time=0.239..0.239 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.019..0.177 rows=347 l
Planning time : 0.794 ms
Execution time : 7,516.973 ms