explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IGMU

Settings
# exclusive inclusive rows x rows loops node
1. 4.624 1,881.338 ↑ 17.8 4 1

Gather (cost=1,000.00..619,527.42 rows=71 width=91) (actual time=0.237..1,881.338 rows=4 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,876.714 1,876.714 ↑ 30.0 1 3

Parallel Seq Scan on "OperationTaskLog" (cost=0.00..618,520.32 rows=30 width=91) (actual time=1,250.187..1,876.714 rows=1 loops=3)

  • Filter: (("LogActionId" <> 0) AND ("CustomerPhone" = '30669967'::text))
  • Rows Removed by Filter: 7638217
Planning time : 0.106 ms
Execution time : 1,881.364 ms