explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Es27

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

Hash Join (cost=124,867.16..137,369,872.37 rows=1,524,056 width=173) (actual rows= loops=)

  • Hash Cond: (v.id = cvp.place_description_version_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on place_description_version v (cost=0.00..212,556.97 rows=4,724,797 width=68) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=105,816.46..105,816.46 rows=1,524,056 width=81) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=100,403.70..105,816.46 rows=1,524,056 width=81) (actual rows= loops=)

  • Hash Cond: (e.id = cvp.place_description_id)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=13.18..1,431.00 rows=1,521,881 width=81) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

HashAggregate (cost=12.75..14.75 rows=200 width=8) (actual rows= loops=)

  • Group Key: find_all_related_place_descriptions_by_geocode.id
7. 0.000 0.000 ↓ 0.0

Function Scan on find_all_related_place_descriptions_by_geocode (cost=0.25..10.25 rows=1,000 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using place_description_pkey on place_description e (cost=0.43..8.41 rows=1 width=73) (actual rows= loops=)

  • Index Cond: (id = find_all_related_place_descriptions_by_geocode.id)
9. 0.000 0.000 ↓ 0.0

Hash (cost=62,289.12..62,289.12 rows=3,048,112 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on place_description_current_version_pointer cvp (cost=0.00..62,289.12 rows=3,048,112 width=16) (actual rows= loops=)

11.          

SubPlan (for Hash Join)

12. 0.000 0.000 ↓ 0.0

Aggregate (cost=89.88..89.89 rows=1 width=32) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Only Scan using place_description_match_ux1 on place_description_match m (cost=0.43..89.76 rows=47 width=8) (actual rows= loops=)

  • Index Cond: (place_description_version_id = v.id)