explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iGb3 : Optimization for: plan #QnAH

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.075 ↑ 1.0 1 1

Limit (cost=0.11..4.12 rows=1 width=444) (actual time=0.075..0.075 rows=1 loops=1)

2. 0.074 0.074 ↑ 1.0 1 1

Index Scan using messages_message_id_index on messages (cost=0.11..4.12 rows=1 width=444) (actual time=0.074..0.074 rows=1 loops=1)

  • Index Cond: ((message_id)::text = 'false_5522997272264@c.us_17D8204CF68F40E9AACB995C637627C8'::text)
  • Filter: ((chat_id IS NOT NULL) AND (chat_id = 335,934))
Planning time : 0.094 ms
Execution time : 0.096 ms