explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WFta

Settings
# exclusive inclusive rows x rows loops node
1. 7.685 1,693.608 ↑ 341.0 1 1

Gather (cost=1,000.00..379,778.24 rows=341 width=72) (actual time=1,689.962..1,693.608 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,685.923 1,685.923 ↓ 0.0 0 3

Parallel Seq Scan on stat_message (cost=0.00..378,744.14 rows=142 width=72) (actual time=1,307.778..1,685.923 rows=0 loops=3)

  • Filter: (message_id = '11710699'::bigint)
  • Rows Removed by Filter: 7101349
Planning time : 0.097 ms
Execution time : 1,693.634 ms