explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hihg

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 0.378 ↓ 0.0 26 1

Nested Loop (cost=0..0 rows=0 width=0) (actual time=0.035..0.378 rows=26 loops=1)

2. 0.262 0.262 ↓ 0.0 27 1

Index Scan using "S_CallTransfers_TimeStart_idx" on S_CallTransfers S_CallTransfers (cost=0..0 rows=0 width=0) (actual time=0.027..0.262 rows=27 loops=1)

  • Index Cond: (("TimeStart" >= '2020-02-02 12:00:00'::timestamp without time zone) AND ("TimeStart" <= '2020-02-02 15:00:00'::timestamp without time zone))
  • Filter: ((CASE ("OperatorIDUser" IS NOT NULL) WHEN TRUE THEN "OperatorIDUser" ELSE NULL::bigint END IS NOT NULL) AND ("TransferResult" <> 6) AND ("substring"(("OperatorNumber")::text, 1, 1) <> 'z'::text) AND (("TransferResult" <> 1) OR (round(((("DurationWait" * 24::double precision) * 60::double precision) * 60::double precision)) >= 2::double precision)))
3. 0.081 0.081 ↓ 0.0 1 27

Index Scan using "S_Seances_pkey" on S_Seances S_Seances (cost=0..0 rows=0 width=0) (actual time=0.003..0.003 rows=1 loops=27)

  • Index Cond: ("S_Seances"."ID" = "S_CallTransfers"."IDSeance")
  • Filter: ("S_Seances"."SeanceType" = 1)
Total runtime : 0.44 ms