explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2WYh

Settings
# exclusive inclusive rows x rows loops node
1. 8.099 71,307.903 ↓ 4.6 23,525 1

Gather (cost=1,000.00..1,781,227.07 rows=5,130 width=167) (actual time=123.796..71,307.903 rows=23,525 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 71,299.804 71,299.804 ↓ 3.7 7,842 3 / 3

Parallel Seq Scan on instrument (cost=0.00..1,779,714.07 rows=2,138 width=167) (actual time=74.679..71,299.804 rows=7,842 loops=3)

  • Filter: (upper((local_code)::text) ~~ 'IBM%'::text)
  • Rows Removed by Filter: 19,155,949
Planning time : 0.162 ms
Execution time : 71,309.885 ms