explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6LJp : IRIS 100

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

Index Scan using idx_venue_iris on venue (cost=0.28..231.23 rows=315 width=251) (actual time=0.857..1.620 rows=315 loops=1)

  • Index Cond: ((iris)::text = ANY ('{900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,94
Planning time : 0.684 ms
Execution time : 1.709 ms