explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LXoM

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 391.859 ↑ 92.9 8 1

HashAggregate (cost=2,345.47..2,352.90 rows=743 width=40) (actual time=391.855..391.859 rows=8 loops=1)

  • Group Key: content.title, content.created
2. 0.001 391.841 ↑ 92.9 8 1

Append (cost=1.28..2,341.75 rows=743 width=40) (actual time=0.077..391.841 rows=8 loops=1)

3. 0.006 0.167 ↓ 8.0 8 1

Nested Loop (cost=1.28..40.03 rows=1 width=18) (actual time=0.077..0.167 rows=8 loops=1)

  • Join Filter: (property.property_id = connection.property_id)
  • Rows Removed by Join Filter: 9
4. 0.003 0.041 ↑ 1.0 1 1

Nested Loop (cost=0.28..9.82 rows=1 width=4) (actual time=0.033..0.041 rows=1 loops=1)

5. 0.025 0.025 ↑ 1.0 1 1

Seq Scan on category (cost=0.00..1.51 rows=1 width=4) (actual time=0.017..0.025 rows=1 loops=1)

  • Filter: (category = 'type'::text)
  • Rows Removed by Filter: 39
6. 0.013 0.013 ↑ 1.0 1 1

Index Scan using property_uidx on property (cost=0.28..8.30 rows=1 width=8) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((category_id = category.category_id) AND (property = 'mobile-list'::text))
7. 0.013 0.120 ↑ 2.8 17 1

Nested Loop (cost=1.01..29.62 rows=47 width=22) (actual time=0.033..0.120 rows=17 loops=1)

8. 0.006 0.030 ↑ 2.1 11 1

Nested Loop (cost=0.58..17.19 rows=23 width=22) (actual time=0.022..0.030 rows=11 loops=1)

9. 0.013 0.013 ↑ 1.0 1 1

Index Scan using users_namespace_identifier_idx on users (cost=0.29..8.31 rows=1 width=4) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: ((namespace = 'infront'::text) AND (identifier = '119491981'::text))
10. 0.011 0.011 ↑ 1.0 11 1

Index Scan using content_user_id_idx on content (cost=0.29..8.77 rows=11 width=26) (actual time=0.008..0.011 rows=11 loops=1)

  • Index Cond: (user_id = users.user_id)
11. 0.077 0.077 ↑ 1.0 2 11

Index Scan using fki_connection_content_id_fkey on connection (cost=0.43..0.52 rows=2 width=8) (actual time=0.007..0.007 rows=2 loops=11)

  • Index Cond: (content_id = content.content_id)
12. 61.870 391.673 ↓ 0.0 0 1

Nested Loop (cost=14.03..2,294.29 rows=742 width=18) (actual time=391.673..391.673 rows=0 loops=1)

13. 16.020 57.307 ↓ 78.8 68,124 1

Nested Loop (cost=13.60..1,869.35 rows=864 width=4) (actual time=12.299..57.307 rows=68,124 loops=1)

14. 0.002 0.027 ↑ 1.0 1 1

Nested Loop (cost=0.28..9.82 rows=1 width=4) (actual time=0.015..0.027 rows=1 loops=1)

15. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on category category_1 (cost=0.00..1.51 rows=1 width=4) (actual time=0.008..0.019 rows=1 loops=1)

  • Filter: (category = 'type'::text)
  • Rows Removed by Filter: 39
16. 0.006 0.006 ↑ 1.0 1 1

Index Scan using property_uidx on property property_1 (cost=0.28..8.30 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: ((category_id = category_1.category_id) AND (property = 'mobile-list'::text))
17. 30.490 41.260 ↓ 107.8 68,124 1

Bitmap Heap Scan on connection connection_1 (cost=13.33..1,853.21 rows=632 width=8) (actual time=12.279..41.260 rows=68,124 loops=1)

  • Recheck Cond: (property_id = property_1.property_id)
  • Heap Blocks: exact=5564
18. 10.770 10.770 ↓ 107.8 68,124 1

Bitmap Index Scan on connection_pkey (cost=0.00..13.17 rows=632 width=0) (actual time=10.770..10.770 rows=68,124 loops=1)

  • Index Cond: (property_id = property_1.property_id)
19. 272.496 272.496 ↓ 0.0 0 68,124

Index Scan using content_pkey on content content_1 (cost=0.42..0.48 rows=1 width=22) (actual time=0.004..0.004 rows=0 loops=68,124)

  • Index Cond: (content_id = connection_1.content_id)
  • Filter: (user_id IS NULL)
  • Rows Removed by Filter: 1