explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZkKf

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 1,885.865 ↑ 1.0 1 1

Limit (cost=0.42..1,235.75 rows=1 width=1,078) (actual time=1,885.842..1,885.865 rows=1 loops=1)

2. 1,885.834 1,885.834 ↑ 216.0 1 1

Index Scan Backward using core_order_created_97da59_idx on core_order (cost=0.42..266,831.91 rows=216 width=1,078) (actual time=1,885.823..1,885.834 rows=1 loops=1)

  • Filter: (((woo_id)::text ~~* '%Jarkko Miettinen%'::text) OR ((email)::text ~~* '%Jarkko Miettinen%'::text) OR ((phone)::text ~~* '%Jarkko Miettinen%'::text) OR (btrim(((btrim((s_first_name)::text) || ' '::text) || btrim((s_last_name)::text))) ~~* '%Jarkko Miettinen%'::text) OR (btrim(((btrim((b_first_name)::text) || ' '::text) || btrim((b_last_name)::text))) ~~* '%Jarkko Miettinen%'::text))
  • Rows Removed by Filter: 275,057
Planning time : 2.169 ms
Execution time : 1,885.954 ms