explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LCmL : без нового индекса

Settings
# exclusive inclusive rows x rows loops node
1. 4.504 4.504 ↓ 470.0 470 1

Index Scan using _accrged637_byperiod_trnrn on _accrged637 t12 (cost=0.06..3.07 rows=1 width=92) (actual time=0.064..4.504 rows=470 loops=1)

  • Index Cond: ((t12._period > '2019-04-12 23:59:59'::timestamp without time zone) AND (t12._period < '2019-05-01 00:00:00'::timestamp without time zone) AND (t12._kindrref = '\\200\\226\\310\\357\\267\\312\\036YB|\\210\\271\\363\\336O\\024'::bytea) AND (t12._correspond = '1'::numeric))
  • Filter: ((t12._value_type = '\\010'::bytea) AND (t12._value_rtref = '\\000\\000\\000\\026'::bytea) AND (t12._value_rrref = '\\332\\222\\000\\014)&\\343I\\021\\345 \\220l\\267\\032H'::bytea))
  • Buffers: shared hit=231