explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FjWe

Settings
# exclusive inclusive rows x rows loops node
1. 10.229 66,881.140 ↓ 4.6 23,525 1

Gather (cost=1,000.00..1,721,340.23 rows=5,130 width=167) (actual time=25.613..66,881.140 rows=23,525 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 66,870.911 66,870.911 ↓ 3.7 7,842 3 / 3

Parallel Seq Scan on instrument (cost=0.00..1,719,827.23 rows=2,138 width=167) (actual time=46.375..66,870.911 rows=7,842 loops=3)

  • Filter: ((local_code)::text ~~ 'IBM%'::text)
  • Rows Removed by Filter: 19,155,949
Planning time : 0.131 ms
Execution time : 66,883.327 ms