explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jrGO

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 19,277.437 ↑ 1.0 80 1

Limit (cost=2,660,589.32..2,660,598.90 rows=80 width=17) (actual time=19,216.427..19,277.437 rows=80 loops=1)

2. 0.000 19,277.417 ↑ 304,958.8 80 1

Gather Merge (cost=2,660,589.32..5,581,719.43 rows=24,396,700 width=17) (actual time=19,216.422..19,277.417 rows=80 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 6,934.785 95,952.215 ↑ 5,585.3 1,092 5

Sort (cost=2,655,589.27..2,670,837.20 rows=6,099,175 width=17) (actual time=19,190.308..19,190.443 rows=1,092 loops=5)

  • Sort Key: user_done
  • Sort Method: external merge Disk: 67088kB
4. 89,017.430 89,017.430 ↑ 1.2 4,912,639 5

Parallel Seq Scan on stock_picking (cost=0.00..1,894,943.77 rows=6,099,175 width=17) (actual time=0.350..17,803.486 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
Planning time : 75.939 ms
Execution time : 19,318.207 ms