explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jiYS

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=1,197.10..1,197.11 rows=2 width=24) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=1,197.10..1,197.10 rows=2 width=24) (actual rows= loops=)

  • Sort Key: dt.id, dt.updated_at
3. 0.000 0.000 ↓ 0.0

Append (cost=48.98..1,197.09 rows=2 width=24) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=48.98..119.25 rows=1 width=24) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=48.56..110.90 rows=17 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on place_search op (cost=44.02..48.04 rows=1 width=8) (actual rows= loops=)

  • Recheck Cond: (lower((unaccent_alternate_localized_names)::text) ~~ lower(unaccent('%jericho%'::text)))
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on trgm_idx_place_search_unaccent_alternate_localized_names (cost=0.00..44.02 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (lower((unaccent_alternate_localized_names)::text) ~~ lower(unaccent('%jericho%'::text)))
8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on day_template_place dtp (cost=4.54..62.71 rows=16 width=24) (actual rows= loops=)

  • Recheck Cond: (geoname_id = op.geoname_id)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on day_template_place_geoname_idx (cost=0.00..4.54 rows=16 width=0) (actual rows= loops=)

  • Index Cond: (geoname_id = op.geoname_id)
10. 0.000 0.000 ↓ 0.0

Index Scan using day_pkey on day dt (cost=0.42..0.48 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (id = dtp.day_template_id)
  • Filter: ((archived IS FALSE) AND (local_agency_id = '7a47afb6-78a5-4919-b688-52375aac20d3'::uuid))
11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=133.13..1,077.81 rows=1 width=24) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on localized_day_search sldt (cost=132.71..467.61 rows=76 width=16) (actual rows= loops=)

  • Recheck Cond: ((lower((unaccent_title)::text) ~~ lower(unaccent('%jericho%'::text))) OR (lower(unaccent_description) ~~ lower(unaccent('%jericho%'::text))))
  • Filter: (auto_translated = ANY ('{t,f}'::boolean[]))
13. 0.000 0.000 ↓ 0.0

BitmapOr (cost=132.71..132.71 rows=88 width=0) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on trgm_idx_localized_day_search_title (cost=0.00..68.59 rows=78 width=0) (actual rows= loops=)

  • Index Cond: (lower((unaccent_title)::text) ~~ lower(unaccent('%jericho%'::text)))
15. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on trgm_idx_localized_day_search_description (cost=0.00..64.08 rows=10 width=0) (actual rows= loops=)

  • Index Cond: (lower(unaccent_description) ~~ lower(unaccent('%jericho%'::text)))
16. 0.000 0.000 ↓ 0.0

Index Scan using day_pkey on day dt_1 (cost=0.42..8.02 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (id = sldt.day_id)
  • Filter: ((archived IS FALSE) AND (local_agency_id = '7a47afb6-78a5-4919-b688-52375aac20d3'::uuid))