explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BTYm

Settings
# exclusive inclusive rows x rows loops node
1. 32.799 6,999.307 ↑ 465.6 10 1

Gather (cost=1,000.00..5,931,342.42 rows=4,656 width=16) (actual time=3,364.198..6,999.307 rows=10 loops=1)

  • Workers Planned: 8
  • Workers Launched: 8
2. 6,966.508 6,966.508 ↑ 582.0 1 9

Parallel Seq Scan on "INVENTORYTRANSACTION" "IT" (cost=0.00..5,929,876.82 rows=582 width=16) (actual time=5,762.476..6,966.508 rows=1 loops=9)

  • Filter: (("FORMATTEDPOSTINGORDERNUMBER")::text ~~ 'R01-T001750536%'::text)
  • Rows Removed by Filter: 5847699
Planning time : 0.224 ms
Execution time : 6,999.337 ms