explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QQFO

Settings
# exclusive inclusive rows x rows loops node
1. 9.647 137.668 ↑ 133.0 1 1

Gather (cost=1,000.00..47,284.94 rows=133 width=27) (actual time=94.385..137.668 rows=1 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 128.021 128.021 ↓ 0.0 0 2

Parallel Seq Scan on ""MDS_WSPID_CW"" (cost=0.00..46,271.64 rows=78 width=27) (actual time=110.151..128.021 rows=0 loops=2)

  • Filter: ((""SPID"")::text ~~ '3200675551%'::text)
  • Rows Removed by Filter: 665340
Planning time : 0.079 ms
Execution time : 137.693 ms