explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tnWn

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

Sort (cost=7.76..7.77 rows=1 width=24) (actual rows= loops=)

  • Sort Key: catalog_language.display_name
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.70..7.75 rows=1 width=24) (actual rows= loops=)

  • Hash Cond: (catalog_language.id = catalog_ephemeronlink.object_id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on catalog_language (cost=0.00..1.90 rows=90 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=1.69..1.69 rows=1 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on catalog_ephemeronlink (cost=0.00..1.69 rows=1 width=4) (actual rows= loops=)

  • Filter: ((content_type_id = 6) AND (ephemeron_id = 332))
6.          

SubPlan (for Hash Join)

7. 0.000 0.000 ↓ 0.0

Seq Scan on catalog_ephemeronlink u0 (cost=0.00..1.81 rows=1 width=4) (actual rows= loops=)

  • Filter: ((content_type_id = 6) AND (ephemeron_id = 332) AND (object_id = catalog_language.id))
8. 0.000 0.000 ↓ 0.0

Seq Scan on catalog_follow u0_1 (cost=0.00..2.00 rows=1 width=4) (actual rows= loops=)

  • Filter: ((content_type_id = 6) AND (object_id = catalog_language.id) AND (user_id = 1))