explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P3if

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 0.434 ↓ 0.0 0 1

"hash right join (cost=1.03..3.36 rows=1 width=96) (actual time=0.433..0.434 rows=0 loops=1)

  • hash cond: (t2.Ссылка = t1.Программа)
2. 0.000 0.000 ↓ 0.0 0

seq scan on Справочник.Программы t2 (cost=0.00..2.28 rows=28 width=64) (never executed)

3. 0.000 0.414 ↓ 0.0 0 1

hash (cost=1.02..1.02 rows=1 width=96) (actual time=0.414..0.414 rows=0 loops=1)

  • buckets: 1024 batches: 1 memory usage: 8kb
4. 0.414 0.414 ↓ 0.0 0 1

seq scan on Справочник.Объекты t1 (cost=0.00..1.02 rows=1 width=96) (actual time=0.414..0.414 rows=0 loops=1)

  • filter: (Дорога = '\\xb98600155d00ee3411e95b9847366a34'::bytea)
  • rows removed by filter: 2
Planning time : 3.298 ms
Execution time : 0.503 ms