explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mqzj

Settings
# exclusive inclusive rows x rows loops node
1. 0.066 0.311 ↓ 6.0 6 1

Sort (cost=7.76..7.77 rows=1 width=24) (actual time=0.310..0.311 rows=6 loops=1)

  • Sort Key: catalog_language.display_name
  • Sort Method: quicksort Memory: 25kB
2. 0.045 0.245 ↓ 6.0 6 1

Hash Join (cost=1.70..7.75 rows=1 width=24) (actual time=0.109..0.245 rows=6 loops=1)

  • Hash Cond: (catalog_language.id = catalog_ephemeronlink.object_id)
3. 0.010 0.010 ↑ 1.0 90 1

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

4. 0.006 0.034 ↓ 6.0 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.028 0.028 ↓ 6.0 6 1

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

  • Filter: ((content_type_id = 6) AND (ephemeron_id = 332))
  • Rows Removed by Filter: 59
6.          

SubPlan (for Hash Join)

7. 0.090 0.090 ↑ 1.0 1 6

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

  • Filter: ((content_type_id = 6) AND (ephemeron_id = 332) AND (object_id = catalog_language.id))
  • Rows Removed by Filter: 64
8. 0.066 0.066 ↑ 1.0 1 6

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

  • Filter: ((content_type_id = 6) AND (object_id = catalog_language.id) AND (user_id = 1))
  • Rows Removed by Filter: 56
Planning time : 0.405 ms
Execution time : 0.351 ms