explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NLep

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

Limit (cost=163.28..163.33 rows=1 width=582) (actual time=0.440..0.440 rows=0 loops=1)

2. 0.001 0.440 ↓ 0.0 0 1

Unique (cost=163.28..163.33 rows=1 width=582) (actual time=0.440..0.440 rows=0 loops=1)

3. 0.021 0.439 ↓ 0.0 0 1

Sort (cost=163.28..163.29 rows=1 width=582) (actual time=0.439..0.439 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. 0.077 0.418 ↓ 0.0 0 1

Bitmap Heap Scan on attempt attempt0_ (cost=4.96..163.27 rows=1 width=582) (actual time=0.418..0.418 rows=0 loops=1)

  • Recheck Cond: (creation_date > '2020-01-01 00:00:00'::timestamp without time zone)
  • Filter: (lower((wm_assignment_id)::text) ~~ '123'::text)
  • Rows Removed by Filter: 91
  • Heap Blocks: exact=27
5. 0.341 0.341 ↑ 1.0 91 1

Bitmap Index Scan on assignment_id_creationdate_asc (cost=0.00..4.96 rows=91 width=0) (actual time=0.341..0.341 rows=91 loops=1)

  • Index Cond: (creation_date > '2020-01-01 00:00:00'::timestamp without time zone)
Planning time : 0.682 ms
Execution time : 0.482 ms