explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kV4n

Settings
# exclusive inclusive rows x rows loops node
1. 0.079 0.435 ↑ 1.1 12 1

Bitmap Heap Scan on hashes (cost=57.63..108.20 rows=13 width=49) (actual time=0.374..0.435 rows=12 loops=1)

  • Recheck Cond: ((hash)::text = ANY ('{20f6959d7feeae77e997a4d6a2b022a79880c8ed,2af253150e1845d342d402741790931b39115113,668080fee64f01d3a6813ccbf565fdc0226ce74f,7be5561d183a71d0c3aaa51eee38e0597247fd1e,cc0d41ea66c232b7f6d14960a79bf4b12d19403f,7edb5d34342f4f2bd7ab4106a4f5000879ad66b1,f8f987527c2f8407a51aa7b50ead025e32a03aa0,fdffee3a8b202cb2014dc7a3e74f66ecbbec7484,47fe5cb382da21dc53787d84bba0fac21ff57823,a9eaa5b7e6700717923a7f58ae05b11ffb55c211,84111189f48ecb7bf5d1e38ace7cb633f43460fa,4c44a8b5452c93b190895f40dfb188ddc145069f,74a0d9e8eb12c9e996fb73c69e59edeb2c651e4d}'::text[]))
  • Heap Blocks: exact=7
2. 0.356 0.356 ↑ 1.0 13 1

Bitmap Index Scan on hashes_hash_id_index (cost=0.00..57.62 rows=13 width=0) (actual time=0.356..0.356 rows=13 loops=1)

  • Index Cond: ((hash)::text = ANY ('{20f6959d7feeae77e997a4d6a2b022a79880c8ed,2af253150e1845d342d402741790931b39115113,668080fee64f01d3a6813ccbf565fdc0226ce74f,7be5561d183a71d0c3aaa51eee38e0597247fd1e,cc0d41ea66c232b7f6d14960a79bf4b12d19403f,7edb5d34342f4f2bd7ab4106a4f5000879ad66b1,f8f987527c2f8407a51aa7b50ead025e32a03aa0,fdffee3a8b202cb2014dc7a3e74f66ecbbec7484,47fe5cb382da21dc53787d84bba0fac21ff57823,a9eaa5b7e6700717923a7f58ae05b11ffb55c211,84111189f48ecb7bf5d1e38ace7cb633f43460fa,4c44a8b5452c93b190895f40dfb188ddc145069f,74a0d9e8eb12c9e996fb73c69e59edeb2c651e4d}'::text[]))