explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gRj

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 71.051 ↑ 1.0 1 1

Sort (cost=15,943.23..15,943.24 rows=1 width=12) (actual time=71.051..71.051 rows=1 loops=1)

  • Sort Key: in_date NULLS FIRST, id
  • Sort Method: quicksort Memory: 25kB
2. 9.239 73.943 ↑ 1.0 1 1

Gather (cost=1,000.00..15,943.22 rows=1 width=12) (actual time=70.925..73.943 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 64.704 64.704 ↓ 0.0 0 3

Parallel Seq Scan on stock_quant (cost=0.00..14,943.12 rows=1 width=12) (actual time=64.104..64.704 rows=0 loops=3)

  • Filter: ((owner_id IS NULL) AND (package_id IS NULL) AND (location_id = 12) AND (lot_id = 41023) AND (product_id = 1))
  • Rows Removed by Filter: 226669
Planning time : 0.310 ms
Execution time : 74.046 ms