explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hBSV : asdfasd

Settings
# exclusive inclusive rows x rows loops node
1. 149.670 149.670 ↓ 0.0 0 1

Limit (cost=0.29..359.98 rows=10 width=1,574) (actual time=149.670..149.670 rows=0 loops=1)

  • Filter: ((((data #>> '{Rawlog,AccountName}'::text[]) ~~* '%buttslol%'::text) AND ((data #>> '{Rawlog,LogonGuid}'::text[]) ~~* '%jimbo%'::text) AND ((data #>> '{Rawlog,AuthenticationPackageName}'::text[]) ~~* '%abcde%'::text)) OR ((data #>> '{Rawlog,HoneytokenType}'::text[]) ~~* '%asdf%'::text) OR (((data #>> '{Rawlog,IpAddress}'::text[]) ~~* 'haha'::text) AND ((data #>> '{Rawlog,MandatoryLabel}'::text[]) ~~* 'wut'::text)))