explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6oBh

Settings
# exclusive inclusive rows x rows loops node
1. 5.848 64,493.309 ↑ 442.2 13 1

Gather (cost=1,000.00..1,721,402.13 rows=5,749 width=167) (actual time=933.963..64,493.309 rows=13 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 64,487.461 64,487.461 ↑ 598.8 4 3 / 3

Parallel Seq Scan on instrument (cost=0.00..1,719,827.23 rows=2,395 width=167) (actual time=1,345.741..64,487.461 rows=4 loops=3)

  • Filter: ((name)::text ~~ 'IBMC%'::text)
  • Rows Removed by Filter: 19,163,786
Planning time : 0.132 ms
Execution time : 64,493.345 ms