explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pSVC

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 0.134 ↓ 0.0 0 1

Sort (cost=24.49..24.50 rows=1 width=36) (actual time=0.134..0.134 rows=0 loops=1)

  • Sort Key: stock_move_line__result_package_id.name DESC, stock_move_line.id
  • Sort Method: quicksort Memory: 25kB
2. 0.003 0.078 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.43..24.48 rows=1 width=36) (actual time=0.077..0.078 rows=0 loops=1)

3. 0.075 0.075 ↓ 0.0 0 1

Index Scan using stock_move_line_move_id_index on stock_move_line (cost=0.28..8.30 rows=1 width=8) (actual time=0.075..0.075 rows=0 loops=1)

  • Index Cond: (move_id = 6,664)
4. 0.000 0.000 ↓ 0.0 0

Index Scan using stock_quant_package_pkey on stock_quant_package stock_move_line__result_package_id (cost=0.15..8.17 rows=1 width=36) (never executed)

  • Index Cond: (stock_move_line.result_package_id = id)
Planning time : 1.517 ms
Execution time : 0.281 ms