explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w2CQ

Settings
# exclusive inclusive rows x rows loops node
1. 10.655 42.170 ↑ 1.0 40,323 1

Hash Join (cost=1,164.31..2,111.21 rows=40,323 width=16) (actual time=25.688..42.170 rows=40,323 loops=1)

  • Hash Cond: (taggings.tag_id = tags.id)
2. 5.957 5.957 ↑ 1.0 40,323 1

Seq Scan on taggings (cost=0.00..841.04 rows=40,323 width=4) (actual time=0.021..5.957 rows=40,323 loops=1)

  • Filter: ((taggable_type)::text = 'Ci::Runner'::text)
3. 15.434 25.558 ↑ 1.0 40,325 1

Hash (cost=660.25..660.25 rows=40,325 width=16) (actual time=25.558..25.558 rows=40,325 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2560kB
4. 10.124 10.124 ↑ 1.0 40,325 1

Seq Scan on tags (cost=0.00..660.25 rows=40,325 width=16) (actual time=0.013..10.124 rows=40,325 loops=1)