explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Brci

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 20,179.235 ↑ 1.0 80 1

Limit (cost=2,463,107.82..2,463,117.40 rows=80 width=30) (actual time=20,127.461..20,179.235 rows=80 loops=1)

2. 0.000 20,179.215 ↑ 191,582.5 80 1

Gather Merge (cost=2,463,107.82..4,298,232.76 rows=15,326,600 width=30) (actual time=20,127.458..20,179.215 rows=80 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 11,583.580 100,426.180 ↑ 4,736.3 809 5

Sort (cost=2,458,107.76..2,467,686.88 rows=3,831,650 width=30) (actual time=20,084.939..20,085.236 rows=809 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: 70016kB
4. 4,802.415 88,842.600 ↑ 1.3 3,038,608 5

Hash Left Join (cost=22.25..1,985,430.10 rows=3,831,650 width=30) (actual time=1.695..17,768.520 rows=3,038,608 loops=5)

  • Hash Cond: (stock_picking.stock_journal_id = stock_picking__stock_journal_id.id)
5. 84,035.340 84,039.920 ↑ 1.3 3,038,608 5

Hash Left Join (cost=19.81..1,974,703.53 rows=3,831,650 width=30) (actual time=1.613..16,807.984 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..1964621.30 rows=3831650 width=30) (actual time=0.486..15728.571 rows=3038608 lo
  • 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. 4.580 4.580 ↑ 1.0 347 5

Hash (cost=15.47..15.47 rows=347 width=8) (actual time=0.916..0.916 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.374..0.815 rows
7. 0.265 0.265 ↑ 1.0 64 5

Hash (cost=1.64..1.64 rows=64 width=4) (actual time=0.053..0.053 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.025..0.035 rows=64
Planning time : 109.472 ms
Execution time : 20,209.152 ms