explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xLF6

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 2,065.311 ↑ 1.0 1 1

Limit (cost=520.54..1,040.83 rows=1 width=1,332) (actual time=2,065.309..2,065.311 rows=1 loops=1)

2. 0.152 2,065.301 ↓ 70.0 70 1

Nested Loop Left Join (cost=0.25..520.54 rows=1 width=1,332) (actual time=2,024.048..2,065.301 rows=70 loops=1)

3. 2,059.339 2,059.339 ↓ 70.0 70 1

Function Scan on tf_call_list_v2 c (cost=0.25..520.25 rows=1 width=1,268) (actual time=2,022.807..2,059.339 rows=70 loops=1)

  • Filter: ((f_unaccent((clinic_name)::text) ~~* unaccent('%Dundrum%'::text)) AND (f_unaccent(scan_name) ~~* unaccent('%MRI%'::text)))
  • Rows Removed by Filter: 8562
4. 5.810 5.810 ↑ 1.0 1 70

Result (cost=0.00..0.26 rows=1 width=32) (actual time=0.083..0.083 rows=1 loops=70)