explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZEi3

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

Index Scan using randomauditentity_blurid_idx on randomauditentity (cost=0.43..39.54 rows=1 width=91) (actual time=0.031..0.044 rows=1 loops=1)

  • Index Cond: ((blurid)::text = '3905766'::text)
  • Filter: (((type)::text = 'INTEGER'::text) AND ((processid)::text = 'PROCESS_TEST'::text) AND ((capacityfilter)::text = '[1-2000000]'::text))
  • Rows Removed by Filter: 11