explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6gb

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.035 ↓ 6.0 6 1

Sort (cost=0.67..0.67 rows=1 width=20) (actual time=0.034..0.035 rows=6 loops=1)

  • Sort Key: create_date DESC, min_exsd, id DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.022 0.022 ↓ 6.0 6 1

Index Scan using refill_list_warehouse_id_idx on refill_list (cost=0.14..0.66 rows=1 width=20) (actual time=0.012..0.022 rows=6 loops=1)

  • Index Cond: (warehouse_id = 89)
  • Filter: ((user_id IS NULL) AND ((shipping_plan)::text = '1'::text))
  • Rows Removed by Filter: 5
Planning time : 0.421 ms
Execution time : 0.062 ms