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,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,10752}'::text[]))
Planning time : 0.684 ms
Execution time : 1.709 ms