explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SAqg : Optimization for: 123; plan #eQWkS

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 31.690 139.150 ↑ 398.0 27 1

Seq Scan on "СписокОтзываСертификатов" crl (cost=0.00..233,317.11 rows=10,746 width=141) (actual time=121.457..139.150 rows=27 loops=1)

  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 21465
  • Buffers: shared hit=2237
2.          

SubPlan (for Seq Scan)

3. 105.912 107.460 ↓ 0.0 0 21,492

Result (cost=0.72..20.79 rows=1 width=41) (actual time=0.005..0.005 rows=0 loops=21,492)

  • One-Time Filter: (upper(crl."Издатель") ~~ '%TENSOR%'::text)
  • Buffers: shared hit=335
4. 0.188 1.548 ↑ 1.0 1 43

Nested Loop (cost=0.72..20.79 rows=1 width=41) (actual time=0.036..0.036 rows=1 loops=43)

  • Buffers: shared hit=335
5. 0.688 0.688 ↑ 1.0 1 43

Index Scan using "iKornevoySertifikat-inKornevoySertifikat_IdKlyuchaSubekta" on "КорневойСертификат" root_ (cost=0.28..12.31 rows=1 width=45) (actual time=0.015..0.016 rows=1 loops=43)

  • Index Cond: (("ИдКлючаСубъекта")::text = crl."ИдКлючаЦС")
  • Filter: "Доверенный
  • Rows Removed by Filter: 0
  • Buffers: shared hit=143
6. 0.672 0.672 ↑ 1.0 1 48

Index Scan using "pСертификат" on "Сертификат" cert (cost=0.43..8.46 rows=1 width=4) (actual time=0.014..0.014 rows=1 loops=48)

  • Index Cond: ("@Сертификат" = root_."@Сертификат")
  • Filter: (("ДействителенС" <= (now())::timestamp without time zone) AND ("ДействителенПо" >= (now())::timestamp without time zone))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=192