explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 28Df

Settings
# exclusive inclusive rows x rows loops node
1. 1,543.299 11,839.232 ↑ 1.0 14,712,257 1

Gather (cost=1,000.00..2,058,189.23 rows=14,866,164 width=78) (actual time=1.385..11,839.232 rows=14,712,257 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
2. 10,295.933 10,295.933 ↑ 1.2 1,839,032 8 / 8

Parallel Seq Scan on cosp cb (cost=0.00..2,057,189.23 rows=2,123,738 width=78) (actual time=1.002..10,295.933 rows=1,839,032 loops=8)

  • Filter: (((mandt)::text = '400'::text) AND (hvr_is_deleted = 0) AND ((wrttp)::text = '01'::text))
  • Rows Removed by Filter: 1,789,829
Planning time : 24.833 ms
Execution time : 12,524.874 ms