explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TPPr

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

Index Scan using _accrged637_suka on _accrged637 t12 (cost=0.06..3.07 rows=1 width=92) (actual time=0.237..7.737 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) AND (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=27 read=177