explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zMG4

Settings
# exclusive inclusive rows x rows loops node
1. 237.296 1,802.327 ↓ 0.0 0 1

Gather (cost=1,000.00..1,043,413.65 rows=1 width=32) (actual time=1,574.001..1,802.327 rows=0 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
2. 1,565.031 1,565.031 ↓ 0.0 0 8

Parallel Seq Scan on "DEMANDORIGINDETAIL" "DOD" (cost=0.00..1,042,413.55 rows=1 width=32) (actual time=1,565.031..1,565.031 rows=0 loops=8)

  • Filter: (("STATUS" <= '3'::smallint) AND ("OWNER" = '00a0567d-4523-2710-92b9-da18d3c50000'::uuid) AND ("WAREHOUSE" = '00a0988a-f578-2710-b92f-0a00806d0000'::uuid) AND ("ITEM" = '00000536-d55a-2b10-8895-7f0001010000'::uuid) AND ("IDENTIFIER" = '00000000-0000-0000-0000-000000000000'::uuid))
  • Rows Removed by Filter: 2311066
Planning time : 1.175 ms
Execution time : 1,802.474 ms