explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S82S

Settings
# exclusive inclusive rows x rows loops node
1. 0.251 1.648 ↑ 1.0 17 1

Limit (cost=2.94..3.62 rows=17 width=14) (actual time=0.639..1.648 rows=17 loops=1)

2. 0.269 1.397 ↑ 1.0 17 1

Hash Join (cost=2.94..3.62 rows=17 width=14) (actual time=0.623..1.397 rows=17 loops=1)

  • Hash Cond: (taggit_taggeditem.object_id = piks_pik.id)
3. 0.344 0.969 ↑ 1.0 17 1

Merge Join (cost=1.80..2.41 rows=17 width=18) (actual time=0.439..0.969 rows=17 loops=1)

  • Merge Cond: (taggit_tag.id = taggit_taggeditem.tag_id)
4. 0.105 0.105 ↑ 1,409.0 12 1

Index Scan using taggit_tag_pkey on taggit_tag (cost=0.29..544.91 rows=16,908 width=14) (actual time=0.017..0.105 rows=12 loops=1)

5. 0.289 0.520 ↑ 1.0 17 1

Sort (cost=1.52..1.56 rows=17 width=8) (actual time=0.395..0.520 rows=17 loops=1)

  • Sort Key: taggit_taggeditem.tag_id
  • Sort Method: quicksort Memory: 25kB
6. 0.231 0.231 ↑ 1.0 17 1

Seq Scan on taggit_taggeditem (cost=0.00..1.17 rows=17 width=8) (actual time=0.013..0.231 rows=17 loops=1)

7. 0.079 0.159 ↓ 1.2 7 1

Hash (cost=1.06..1.06 rows=6 width=4) (actual time=0.152..0.159 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.080 0.080 ↓ 1.2 7 1

Seq Scan on piks_pik (cost=0.00..1.06 rows=6 width=4) (actual time=0.014..0.080 rows=7 loops=1)