explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nsud

Settings
# exclusive inclusive rows x rows loops node
1. 7.607 1,708.625 ↑ 341.0 1 1

Gather (cost=1,000.00..379,782.48 rows=341 width=72) (actual time=556.553..1,708.625 rows=1 loops=1)

  • Output: id, message_id, system_id, statistic_type, error_type, start_time, end_time, work_millis
  • Workers Planned: 2
  • Workers Launched: 2
2. 1,701.018 1,701.018 ↓ 0.0 0 3

Parallel Seq Scan on public.stat_message (cost=0.00..378,748.38 rows=142 width=72) (actual time=1,318.222..1,701.018 rows=0 loops=3)

  • Output: id, message_id, system_id, statistic_type, error_type, start_time, end_time, work_millis
  • Filter: (stat_message.message_id = '11710699'::bigint)
  • Rows Removed by Filter: 7101467
  • Worker 0: actual time=1699.176..1699.176 rows=0 loops=1
  • Worker 1: actual time=1699.349..1699.349 rows=0 loops=1
Planning time : 0.141 ms
Execution time : 1,708.657 ms