explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e82l

Settings
# exclusive inclusive rows x rows loops node
1. 0.069 38.941 ↑ 1.0 1 1

Sort (cost=6,094.11..6,094.11 rows=1 width=12) (actual time=38.941..38.941 rows=1 loops=1)

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

Index Scan using test_rim on stock_quant (cost=0.42..6,094.10 rows=1 width=12) (actual time=5.497..38.872 rows=1 loops=1)

  • Index Cond: ((location_id = 12) AND (lot_id = 45393) AND (product_id = 1))