explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DK2C

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

Limit (cost=49,935.08..49,935.17 rows=13 width=24) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=49,935.08..49,935.17 rows=13 width=24) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=49,935.08..49,935.11 rows=13 width=24) (actual rows= loops=)

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

Hash Join (cost=5,141.20..49,934.84 rows=13 width=24) (actual rows= loops=)

  • Hash Cond: (dtp.geoname_id = op.geoname_id)
  • Join Filter: ((op.alternate_localized_names ~~* unaccent('%jericho%'::text)) OR (lower(sldt.unaccent_title) ~~ unaccent('%jericho%'::text)) OR (lower(sldt.unaccent_description) ~~ unaccent('%jericho%'::text)))
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,267.13..43,484.97 rows=21,363 width=553) (actual rows= loops=)

  • Hash Cond: (sldt.day_id = dt.id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on optimized_localized_day sldt (cost=0.00..34,033.40 rows=795,072 width=537) (actual rows= loops=)

  • Filter: (auto_translated = ANY ('{t,f}'::boolean[]))
7. 0.000 0.000 ↓ 0.0

Hash (cost=4,233.20..4,233.20 rows=2,715 width=48) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,134.05..4,233.20 rows=2,715 width=48) (actual rows= loops=)

  • Hash Cond: (dtp.day_template_id = dt.id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on day_template_place dtp (cost=0.00..2,385.00 rows=137,400 width=24) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=1,109.46..1,109.46 rows=1,967 width=24) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on day dt (cost=48.14..1,109.46 rows=1,967 width=24) (actual rows= loops=)

  • Recheck Cond: (local_agency_id = '7a47afb6-78a5-4919-b688-52375aac20d3'::uuid)
  • Filter: (archived IS FALSE)
12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_7f936ef033ad5476 (cost=0.00..47.65 rows=2,031 width=0) (actual rows= loops=)

  • Index Cond: (local_agency_id = '7a47afb6-78a5-4919-b688-52375aac20d3'::uuid)
13. 0.000 0.000 ↓ 0.0

Hash (cost=411.03..411.03 rows=25,203 width=20) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on optimized_place op (cost=0.00..411.03 rows=25,203 width=20) (actual rows= loops=)