explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qGNH

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 15,501.262 ↑ 1.0 80 1

Limit (cost=2,438,550.46..2,438,560.04 rows=80 width=13) (actual time=15,458.377..15,501.262 rows=80 loops=1)

2. 0.000 15,501.242 ↑ 191,811.9 80 1

Gather Merge (cost=2,438,550.46..4,275,872.77 rows=15,344,952 width=13) (actual time=15,458.374..15,501.242 rows=80 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 6,853.355 76,803.230 ↑ 4,572.4 839 5

Sort (cost=2,433,550.40..2,443,141.00 rows=3,836,238 width=13) (actual time=15,360.480..15,360.646 rows=839 loops=5)

  • Sort Key: stock_picking__stock_journal_id.id, stock_picking.state
  • Sort Method: external merge Disk: 68816kB
4. 3,818.865 69,949.875 ↑ 1.3 3,038,608 5

Hash Left Join (cost=2.44..1,975,632.99 rows=3,836,238 width=13) (actual time=1.689..13,989.975 rows=3,038,608 loops=5)

  • Hash Cond: (stock_picking.stock_journal_id = stock_picking__stock_journal_id.id)
5. 66,130.680 66,130.680 ↑ 1.3 3,038,608 5

Parallel Seq Scan on stock_picking (cost=0.00..1,964,893.58 rows=3,836,238 width=17) (actual time=0.370..13,226.136 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. 0.330 0.330 ↑ 1.0 64 5

Hash (cost=1.64..1.64 rows=64 width=4) (actual time=0.066..0.066 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.035..0.041 rows=64
Planning time : 10.856 ms
Execution time : 15,527.551 ms