explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QnAH

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 26,353.179 ↑ 1.0 1 1

Limit (cost=1,000.00..93,001.26 rows=1 width=444) (actual time=26,353.179..26,353.179 rows=1 loops=1)

2. 11,667.691 47,506.867 ↑ 1.0 1 1

Gather (cost=1,000.00..93,001.26 rows=1 width=444) (actual time=26,353.177..47,506.867 rows=1 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 35,839.176 35,839.176 ↓ 0.0 0 2 / 2

Parallel Seq Scan on messages (cost=0.00..92,001.16 rows=1 width=444) (actual time=35,839.176..35,839.176 rows=0 loops=2)

  • Filter: ((chat_id IS NOT NULL) AND (chat_id = 335,934) AND ((message_id)::text = 'false_5522997272264@c.us_17D8204CF68F40E9AACB995C637627C8'::text))
  • Rows Removed by Filter: 606,826
Planning time : 0.088 ms
Execution time : 47,506.903 ms