explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MB1W

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 238.398 ↓ 5.8 87 1

Limit (cost=22,547.39..22,547.43 rows=15 width=564) (actual time=238.380..238.398 rows=87 loops=1)

2. 0.485 238.383 ↓ 5.8 87 1

Sort (cost=22,547.39..22,547.43 rows=15 width=564) (actual time=238.379..238.383 rows=87 loops=1)

  • Sort Key: "FullName
  • Sort Method: quicksort Memory: 102kB
3. 237.898 237.898 ↓ 5.8 87 1

Seq Scan on "Customers" (cost=0.00..22,547.10 rows=15 width=564) (actual time=7.480..237.898 rows=87 loops=1)

  • Filter: (("BankId" = 1) AND ((lower(("CustomerNumber")::text) ~~ '%michael%'::text) OR (("TaxId")::text ~~ '%michael%'::text) OR (lower(("FullName")::text) ~~ '%michael%'::text)))
  • Rows Removed by Filter: 49917