explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xpj6k : asdfasd

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

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

2. 145.717 145.717 ↓ 0.0 0 1

Index Scan Backward using mt_dcev2_idx_server_time_stamp on mt_doc_postgresevents_datacollectioneventv2 (cost=0.29..3,561.25 rows=99 width=1,574) (actual time=145.717..145.717 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)))
  • Rows Removed by Filter: 12378