explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gEsv

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 9,197.456 ↑ 1.0 80 1

Limit (cost=2,464,005.39..2,464,014.97 rows=80 width=30) (actual time=9,154.378..9,197.456 rows=80 loops=1)

2. 0.000 9,197.436 ↑ 191,811.9 80 1

Gather Merge (cost=2,464,005.39..4,301,327.70 rows=15,344,952 width=30) (actual time=9,154.373..9,197.436 rows=80 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 8,209.175 45,442.790 ↑ 4,912.0 781 5

Sort (cost=2,459,005.33..2,468,595.93 rows=3,836,238 width=30) (actual time=9,088.201..9,088.558 rows=781 loops=5)

  • Sort Key: stock_picking__location_id.parent_left, stock_picking.user_done, stock_picking__stock_journal_id.id, stock_picking.state
  • Sort Method: external merge Disk: 74080kB
4. 3,596.460 37,233.615 ↑ 1.3 3,038,608 5

Hash Left Join (cost=22.25..1,985,727.28 rows=3,836,238 width=30) (actual time=0.503..7,446.723 rows=3,038,608 loops=5)

  • Hash Cond: (stock_picking.stock_journal_id = stock_picking__stock_journal_id.id)
5. 33,635.795 33,636.955 ↑ 1.3 3,038,608 5

Hash Left Join (cost=19.81..1,974,987.87 rows=3,836,238 width=30) (actual time=0.443..6,727.391 rows=3,038,608 loops=5)

  • Hash Cond: (stock_picking.location_id = stock_picking__location_id.id)
  • -> Parallel Seq Scan on stock_picking (cost=0.00..1964893.58 rows=3836238 width=30) (actual time=0.063..5897.399 rows=3038608 loo
  • Filter: (((company_id IS NULL) OR (company_id = 1)) AND ((type)::text = 'internal'::text) AND (((name)::text = '9'::text) OR
  • Rows Removed by Filter: 8127964
6. 1.160 1.160 ↑ 1.0 347 5

Hash (cost=15.47..15.47 rows=347 width=8) (actual time=0.232..0.232 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.026..0.174 rows
7. 0.200 0.200 ↑ 1.0 64 5

Hash (cost=1.64..1.64 rows=64 width=4) (actual time=0.040..0.040 rows=64 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • -> Seq Scan on stock_journal stock_picking__stock_journal_id (cost=0.00..1.64 rows=64 width=4) (actual time=0.018..0.023 rows=64
Planning time : 74.509 ms
Execution time : 9,222.066 ms