explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tCBV

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1.122 ↑ 1.0 81 1

Limit (cost=709.20..709.41 rows=82 width=575) (actual time=1.112..1.122 rows=81 loops=1)

2. 0.480 1.116 ↑ 1.0 81 1

Sort (cost=709.20..709.41 rows=82 width=575) (actual time=1.112..1.116 rows=81 loops=1)

  • Sort Key: "Banks"."Name", "Customers"."FullName
  • Sort Method: quicksort Memory: 99kB
3. 0.071 0.636 ↑ 1.0 81 1

Nested Loop Left Join (cost=17.05..706.60 rows=82 width=575) (actual time=0.059..0.636 rows=81 loops=1)

4. 0.090 0.241 ↑ 1.0 81 1

Nested Loop (cost=16.76..380.56 rows=82 width=575) (actual time=0.047..0.241 rows=81 loops=1)

5. 0.008 0.008 ↑ 1.0 1 1

Index Scan using "PK_BankId" on "Banks" (cost=0.13..8.14 rows=1 width=14) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: ("BankId" = 1)
6. 0.123 0.143 ↑ 1.0 81 1

Bitmap Heap Scan on "Customers" (cost=16.63..371.60 rows=82 width=565) (actual time=0.034..0.143 rows=81 loops=1)

  • Recheck Cond: (to_tsvector('simple'::regconfig, f_concat_ws(' '::text, VARIADIC ARRAY[("CustomerNumber")::text, ("TaxId")::text, ("FullName")::text])) @@ '''michael'''::tsquery)
  • Filter: ("BankId" = 1)
  • Heap Blocks: exact=80
7. 0.020 0.020 ↑ 1.0 81 1

Bitmap Index Scan on idx_customers_tsv (cost=0.00..16.61 rows=82 width=0) (actual time=0.020..0.020 rows=81 loops=1)

  • Index Cond: (to_tsvector('simple'::regconfig, f_concat_ws(' '::text, VARIADIC ARRAY[("CustomerNumber")::text, ("TaxId")::text, ("FullName")::text])) @@ '''michael'''::tsquery)
8. 0.324 0.324 ↑ 1.0 1 81

Index Only Scan using ix_customeraddresses_customerid_addressindex_zero on "CustomerAddresses" (cost=0.29..3.97 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=81)

  • Index Cond: ("CustomerId" = "Customers"."CustomerId")
  • Heap Fetches: 0
Planning time : 0.792 ms