explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BiY2 : IRIS 1000

Settings
# exclusive inclusive rows x rows loops node
1. 4.099 4.099 ↑ 1.0 315 1

Index Scan using idx_venue_iris on venue (cost=0.28..490.41 rows=315 width=251) (actual time=1.826..4.099 rows=315 loops=1)

  • Index Cond: ((iris)::text = ANY ('{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,5
Planning time : 2.341 ms
Execution time : 4.153 ms