explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MkNJ

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

Sort (cost=95,372.92..95,373.42 rows=201 width=701) (actual rows= loops=)

  • Sort Key: create_ts
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on audit_messages am (cost=7,875.55..95,365.23 rows=201 width=701) (actual rows= loops=)

  • Recheck Cond: ((message)::text ~* '8_сложная алгебра_малышева'::text)
  • Filter: ((create_ts >= '2020-09-09 00:00:00'::timestamp without time zone) AND (create_ts >= '2020-09-15 00:00:00'::timestamp without time zone) AND ((action)::text <> 'READ'::text))
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on gi_audit_message_on_message (cost=0.00..7,875.50 rows=22,334 width=0) (actual rows= loops=)

  • Index Cond: ((message)::text ~* '8_сложная алгебра_малышева'::text)