explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gJLq

Settings
# exclusive inclusive rows x rows loops node
1. 103.249 31,472.501 ↓ 0.0 0 1

Gather (cost=1,000.00..146,869.82 rows=1 width=404) (actual time=31,458.327..31,472.501 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 31,369.252 31,369.252 ↓ 0.0 0 3

Parallel Seq Scan on tblcalldetails (cost=0.00..145,869.72 rows=1 width=404) (actual time=31,369.247..31,369.252 rows=0 loops=3)

  • Filter: ((calldetails_lcustomid1 = 248631) AND ((calldetails_tdate)::date = '2019-04-01'::date))
  • Rows Removed by Filter: 939532