explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x19C : Optimization for: 111; plan #vrJv

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 11.377 11.377 ↓ 1.1 29,071 1

Index Scan using es001c_pkey on es001c (cost=0.42..11,071.35 rows=25,447 width=133) (actual time=0.030..11.377 rows=29,071 loops=1)

  • Index Cond: (procod = ANY ('{BR02B,BR02B,BR02C,BR04B,BR04C,BR05B,BR05C,BT05B,BT05M,BT06B,BT06M,BA16N,BA30N,BA50N,BR12B,BR12C,BR24B,BR24C,BR25B,BR25C,BR25N,BR35B,BR35C,BR35N,BR50B,BR50C,BR50N,BT15B,BT15M,BT50B,BT50M,BT20B,BT20M,BT45B,BT45M}'::bpchar[]))
Planning time : 0.446 ms
Execution time : 12.576 ms