explain.depesz.com

PostgreSQL's explain analyze made readable

Result: niIE

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 9,152.848 ↑ 1.0 50 1

Limit (cost=0.85..1,317.10 rows=50 width=299) (actual time=8,742.040..9,152.848 rows=50 loops=1)

2. 0.000 9,152.821 ↑ 1,096.2 50 1

Nested Loop (cost=0.85..1,442,890.49 rows=54,811 width=299) (actual time=8,742.038..9,152.821 rows=50 loops=1)

3. 4,225.929 4,225.929 ↑ 2.1 1,002,038 1

Index Scan using idx_741762_primary on user_topics (cost=0.43..391,914.82 rows=2,138,170 width=261) (actual time=0.015..4,225.929 rows=1,002,038 loops=1)

  • Filter: (NOT is_archived)
  • Rows Removed by Filter: 1,919,943
4. 5,010.190 5,010.190 ↓ 0.0 0 1,002,038

Index Scan using idx_741710_primary on users "user" (cost=0.42..0.49 rows=1 width=46) (actual time=0.005..0.005 rows=0 loops=1,002,038)

  • Index Cond: (id = user_topics.user_id)
  • Filter: (organisation_id = 2,697)
  • Rows Removed by Filter: 1
Planning time : 0.378 ms
Execution time : 9,152.916 ms