explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gpcR

Settings
# exclusive inclusive rows x rows loops node
1. 14.823 15.776 ↑ 2.5 2 1

Hash Join (cost=69.88..112.26 rows=5 width=557) (actual time=15.599..15.776 rows=2 loops=1)

  • Hash Cond: (a."CustomerId" = c."CustomerId")
  • Join Filter: (to_tsvector((((((((((((((((((((((c."FullName")::text || ' '::text) || (c."FirstName")::text) || ' '::text) || (c."MiddleName")::text) || ' '::text) || (c."LastName")::text) || ' '::text) || replace((a."EmailAddress1")::text, '@'::text, ' '::text)) || ' '::text) || replace((a."EmailAddress2")::text, '@'::text, ' '::text)) || ' '::text) || (a."HomePhone")::text) || ' '::text) || (a."WorkPhone")::text) || ' '::text) || (a."MobilePhone")::text) || ' '::text) || (c."CustomerNumber")::text) || ' '::text) || (c."TaxId")::text)) @@ to_tsquery('turner:*'::text))
  • Rows Removed by Join Filter: 1014
2. 0.341 0.341 ↑ 1.0 1,016 1

Seq Scan on "CustomerAddresses" a (cost=0.00..39.71 rows=1,016 width=157) (actual time=0.008..0.341 rows=1,016 loops=1)

  • Filter: ("AddressIndex" = 0)
  • Rows Removed by Filter: 1
3. 0.448 0.612 ↑ 1.0 1,017 1

Hash (cost=57.17..57.17 rows=1,017 width=400) (actual time=0.612..0.612 rows=1,017 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 379kB
4. 0.164 0.164 ↑ 1.0 1,017 1

Seq Scan on "Customers" c (cost=0.00..57.17 rows=1,017 width=400) (actual time=0.002..0.164 rows=1,017 loops=1)

Planning time : 0.729 ms
Execution time : 17.726 ms