explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hC9A

Settings
# exclusive inclusive rows x rows loops node
1. 0.043 6,669.839 ↓ 3.0 6 1

Sort (cost=7,866.52..7,866.53 rows=2 width=20) (actual time=6,665.312..6,669.839 rows=6 loops=1)

  • Sort Key: create_date DESC, min_exsd, id DESC
  • Sort Method: quicksort Memory: 25kB
2. 10.201 6,669.796 ↓ 3.0 6 1

Gather (cost=10.43..7,866.51 rows=2 width=20) (actual time=6,664.641..6,669.796 rows=6 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 6,659.595 6,659.595 ↑ 1.0 1 5 / 5

Parallel Index Scan using refill_list_shipping_plan_idx on refill_list (cost=0.43..7,856.49 rows=1 width=20) (actual time=5,333.112..6,659.595 rows=1 loops=5)

  • Index Cond: ((shipping_plan)::text = '1'::text)
  • Filter: ((user_id IS NULL) AND (warehouse_id = 89) AND ((state)::text = 'waiting'::text))
  • Rows Removed by Filter: 78,089
Planning time : 20.847 ms
Execution time : 6,669.888 ms