explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eQWkS : 123

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.055 22.221 ↓ 4.3 26 1

Nested Loop (cost=555.18..1,016.95 rows=6 width=646) (actual time=19.768..22.221 rows=26 loops=1)

  • Buffers: shared hit=799 dirtied=19
2. 0.819 21.503 ↓ 1.4 51 1

Hash Join (cost=554.75..729.12 rows=37 width=650) (actual time=19.690..21.503 rows=51 loops=1)

  • Hash Cond: ((root_."ИдКлючаСубъекта")::text = crl."ИдКлючаЦС")
  • Buffers: shared hit=602 dirtied=19
3. 1.059 1.059 ↑ 1.0 4,554 1

Seq Scan on "КорневойСертификат" root_ (cost=0.00..139.85 rows=4,554 width=45) (actual time=0.012..1.059 rows=4,554 loops=1)

  • Filter: "Доверенный
  • Rows Removed by Filter: 931
  • Buffers: shared hit=85
4. 0.063 19.625 ↓ 1.6 44 1

Hash (cost=554.40..554.40 rows=28 width=646) (actual time=19.625..19.625 rows=44 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
  • Buffers: shared hit=514 dirtied=19
5. 19.562 19.562 ↓ 1.6 44 1

Seq Scan on "СписокОтзываСертификатов" crl (cost=0.00..554.40 rows=28 width=646) (actual time=0.243..19.562 rows=44 loops=1)

  • Filter: ("Издатель" ~~* '%tensor%'::text)
  • Rows Removed by Filter: 3189
  • Buffers: shared hit=514 dirtied=19
6. 0.663 0.663 ↑ 1.0 1 51

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

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