explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uSrU

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=21.38..21.43 rows=5 width=20) (never executed)

2. 0.000 0.000 ↓ 0.0

Sort (cost=21.38..21.4 rows=5 width=20) (never executed)

  • Sort Key: slrcard_1.id, slrcard.stabnum, (round(slrstatisticrep.getmoneychargegroup('1'::numeric, (to_date('01.07.2020'::text, 'dd.mm.yyyy'::text))::timestamp without time zone, (to_date('01.07.2020'::text, 'dd.mm.yyyy'::text))::timestamp without time zone, NULL::numeric, NULL::numeric, slrcard_1.id, 'ТАРИФНЫЙ_ЗАРАБОТОК'::character varying, NULL::character varying, ('-1'::numeric(15,0))::cmn.tid), 1))
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..21.33 rows=5 width=20) (never executed)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..18.43 rows=5 width=29) (never executed)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..16.45 rows=5 width=38) (never executed)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..14.87 rows=5 width=38) (never executed)

7. 0.000 0.000 ↓ 0.0

Limit (cost=0..2.27 rows=5 width=9) (never executed)

8. 0.000 0.000 ↓ 0.0

Seq Scan on slrcard slrcard_1 (cost=0..1,876.55 rows=4,133 width=9) (never executed)

  • Filter: (slrcard_1.ddismissed IS NULL)
9. 0.000 0.000 ↓ 0.0

Index Scan using usr_slrcard_04 on slrcard slrcard (cost=0.28..2.5 rows=1 width=38) (never executed)

  • Index Cond: (slrcard.id = slrcard_1.id)
10. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_slrkadr on slrkadr slrkadr (cost=0.28..0.31 rows=1 width=9) (never executed)

  • Index Cond: (slrkadr.id = slrcard.idkadr)
11. 0.000 0.000 ↓ 0.0

Index Scan using xif451slrcardeduc on slrcardeduc slrcardeduc (cost=0.29..0.39 rows=1 width=9) (never executed)

  • Index Cond: (slrcardeduc.idkadr = slrcard.idkadr)
  • Filter: ((slrcardeduc.ldefault)::text = 'Y'::text)
12. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_slrstaffpos on slrstaffpos slrstaffpos (cost=0.28..0.31 rows=1 width=9) (never executed)

  • Index Cond: (slrstaffpos.id = slrcard.idstaffpos)