explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CE7J

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,276.161 ↓ 1.1 18 1

Limit (cost=11,602.96..11,603.00 rows=17 width=71) (actual time=1,276.157..1,276.161 rows=18 loops=1)

2. 0.040 1,276.159 ↓ 1.0 28 1

Sort (cost=11,602.94..11,603.00 rows=27 width=71) (actual time=1,276.154..1,276.159 rows=28 loops=1)

  • Sort Key: t.name
  • Sort Method: quicksort Memory: 28kB
3. 113.220 1,276.119 ↓ 1.0 28 1

GroupAggregate (cost=11,595.80..11,602.29 rows=27 width=71) (actual time=1,108.999..1,276.119 rows=28 loops=1)

  • Group Key: t.id
4. 359.210 1,162.899 ↓ 944.9 767,237 1

Sort (cost=11,595.80..11,597.83 rows=812 width=47) (actual time=1,105.180..1,162.899 rows=767,237 loops=1)

  • Sort Key: t.id
  • Sort Method: quicksort Memory: 100,721kB
5. 91.162 803.689 ↓ 944.9 767,237 1

Nested Loop Left Join (cost=0.56..11,556.56 rows=812 width=47) (actual time=0.022..803.689 rows=767,237 loops=1)

6. 0.095 0.095 ↓ 1.0 28 1

Index Scan using tag_name_initial_not_archived on tag t (cost=0.14..32.44 rows=27 width=31) (actual time=0.006..0.095 rows=28 loops=1)

7. 712.432 712.432 ↓ 48.2 27,401 28

Index Scan using campaign_tag_join_tag_idx on campaign_tag_join ctj (cost=0.43..421.13 rows=569 width=32) (actual time=0.018..25.444 rows=27,401 loops=28)

  • Index Cond: (t.id = tag_id)