explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FDZU

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 0.107 ↑ 1.0 1 1

Sort (cost=24.50..24.50 rows=1 width=36) (actual time=0.107..0.107 rows=1 loops=1)

  • Sort Key: stock_move_line__result_package_id.name DESC, stock_move_line.id
  • Sort Method: quicksort Memory: 25kB
2. 0.009 0.072 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.43..24.49 rows=1 width=36) (actual time=0.070..0.072 rows=1 loops=1)

3. 0.052 0.052 ↑ 1.0 1 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.051..0.052 rows=1 loops=1)

  • Index Cond: (move_id = 15863)
4. 0.011 0.011 ↓ 0.0 0 1

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) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (stock_move_line.result_package_id = id)
Planning time : 0.788 ms
Execution time : 0.187 ms