explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pquY

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

Limit (cost=226.86..226.90 rows=1 width=582) (actual time=1.642..1.642 rows=0 loops=1)

2. 0.000 1.641 ↓ 0.0 0 1

Unique (cost=226.86..226.90 rows=1 width=582) (actual time=1.641..1.641 rows=0 loops=1)

3. 0.082 1.641 ↓ 0.0 0 1

Sort (cost=226.86..226.86 rows=1 width=582) (actual time=1.641..1.641 rows=0 loops=1)

  • Sort Key: creation_date DESC, id, log, action, action_condition, allowed, condition_met, event, external_system_ticket_id, incoming_value, initiation_ip, relay_id, rule_version_id, status, task_id, wm_assignment_id
  • Sort Method: quicksort Memory: 25kB
4. 1.559 1.559 ↓ 0.0 0 1

Seq Scan on attempt attempt0_ (cost=0.00..226.85 rows=1 width=582) (actual time=1.559..1.559 rows=0 loops=1)

  • Filter: ((creation_date > '2020-01-01 00:00:00'::timestamp without time zone) AND (lower((wm_assignment_id)::text) ~~ '123'::text))
  • Rows Removed by Filter: 2220
Planning time : 0.150 ms
Execution time : 1.697 ms