explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CTcf

Settings
# exclusive inclusive rows x rows loops node
1. 0.065 2,707.326 ↓ 46.0 322 1

Unique (cost=648,615.03..648,615.11 rows=7 width=64) (actual time=2,707.231..2,707.326 rows=322 loops=1)

2. 0.000 2,707.261 ↓ 46.0 322 1

Sort (cost=648,615.03..648,615.04 rows=7 width=64) (actual time=2,707.230..2,707.261 rows=322 loops=1)

  • Sort Key: "DO"."HEADER001", "DO"."DETAIL", "DOD"."DEMANDORIGIN", "DOD"."SUBKEY
  • Sort Method: quicksort Memory: 70kB
3. 27.100 2,722.685 ↓ 46.0 322 1

Gather (cost=594,906.20..648,614.93 rows=7 width=64) (actual time=2,664.885..2,722.685 rows=322 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 0.273 2,695.585 ↓ 32.0 64 5

Nested Loop (cost=593,906.20..647,614.23 rows=2 width=64) (actual time=2,660.089..2,695.585 rows=64 loops=5)

5. 0.163 2,695.312 ↓ 32.0 64 5

Nested Loop (cost=593,905.77..647,609.26 rows=2 width=80) (actual time=2,660.057..2,695.312 rows=64 loops=5)

6. 0.316 2,695.149 ↓ 32.0 64 5

Nested Loop Left Join (cost=593,905.63..647,608.95 rows=2 width=80) (actual time=2,660.026..2,695.149 rows=64 loops=5)

7. 1.158 2,694.833 ↓ 32.0 64 5

Nested Loop (cost=593,905.20..647,607.84 rows=2 width=96) (actual time=2,659.972..2,694.833 rows=64 loops=5)

8. 1.003 2,693.675 ↓ 32.0 64 5

Nested Loop (cost=593,904.77..647,606.84 rows=2 width=112) (actual time=2,659.917..2,693.675 rows=64 loops=5)

9. 2.535 2,692.672 ↓ 32.0 64 5

Nested Loop (cost=593,904.34..647,604.20 rows=2 width=96) (actual time=2,659.854..2,692.672 rows=64 loops=5)

10. 37.300 2,690.099 ↑ 109.8 66 5

Parallel Bitmap Heap Scan on "DEMANDORIGINDETAIL" "DOD" (cost=593,903.78..629,978.10 rows=7,249 width=64) (actual time=2,653.095..2,690.099 rows=66 loops=5)

  • Recheck Cond: ("STATUS" = ANY ('{1,2,3}'::integer[]))
  • Filter: (("RESERVEDQUANTITYI0IXAMOUNT" > "RESERVEDONHANDQUANTITYI001") OR ("RESERVEDQUANTITYI1IXAMOUNT" > "RESERVEDONHANDQUANTITYI002") OR ("RESERVEDQUANTITYI2IXAMOUNT" > "RESERVEDONHANDQUANTITYI003") OR ("RESERVEDQUANTITYI3IXAMOUNT" > "RESERVEDONHANDQUANTITYI004") OR ("OPENQUANTITYI0IXAMOUNT" > '0'::numeric) OR ("OPENQUANTITYI1IXAMOUNT" > '0'::numeric) OR ("OPENQUANTITYI2IXAMOUNT" > '0'::numeric) OR ("OPENQUANTITYI3IXAMOUNT" > '0'::numeric))
  • Rows Removed by Filter: 6289
  • Heap Blocks: exact=3994
11. 2,652.799 2,652.799 ↓ 1.6 57,395 1

Bitmap Index Scan on "DEMANDORIGINDETAIL_001" (cost=0.00..593,896.53 rows=36,133 width=0) (actual time=2,652.799..2,652.799 rows=57,395 loops=1)

  • Index Cond: ("STATUS" = ANY ('{1,2,3}'::integer[]))
12. 0.038 0.038 ↑ 1.0 1 330

Index Scan using "DEMANDORIGIN_pkey" on "DEMANDORIGIN" "DO" (cost=0.56..2.43 rows=1 width=48) (actual time=0.038..0.038 rows=1 loops=330)

  • Index Cond: ("GUID" = "DOD"."DEMANDORIGIN")
  • Filter: (("RESERVATIONCREATIONMODE" = ANY ('{4,5}'::integer[])) AND ("STATUS" = ANY ('{1,2,3}'::integer[])) AND ("ORDERTYPE" <> ALL ('{0,70,90}'::integer[])) AND (("ORDERTYPE" = '40'::smallint) OR ("ORDERTYPE" = '60'::smallint) OR ("ORDERTYPE" = '150'::smallint) OR ("ORDERTYPE" = '260'::smallint)))
  • Rows Removed by Filter: 0