explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eCVUt

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 401.016 ↓ 10.0 10 1

Limit (cost=19,062.58..615,987.03 rows=1 width=4) (actual time=147.662..401.016 rows=10 loops=1)

2. 93.655 401.009 ↓ 10.0 10 1

Gather (cost=19,062.58..615,987.03 rows=1 width=4) (actual time=147.660..401.009 rows=10 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.025 307.354 ↓ 4.0 4 3 / 3

Nested Loop (cost=18,062.58..614,986.93 rows=1 width=4) (actual time=130.225..307.354 rows=4 loops=3)

4. 291.742 307.193 ↑ 12.5 4 3 / 3

Parallel Bitmap Heap Scan on user_clusters (cost=18,062.15..614,564.05 rows=50 width=8) (actual time=130.164..307.193 rows=4 loops=3)

  • Recheck Cond: ((cluster_id = 39) AND (deleted_at IS NULL))
  • Filter: ((user_searchable @@ '''nitin'''::tsquery) OR (lower(email) = 'nitin@peoplegrove.com'::text) OR (lower(email) ~~* 'nitin%'::text))
  • Rows Removed by Filter: 73967
  • Heap Blocks: exact=11171
5. 15.451 15.451 ↑ 1.1 455,976 1 / 3

Bitmap Index Scan on user_clusters_user_id_hub_id_unique (cost=0.00..18,062.12 rows=486,091 width=0) (actual time=46.354..46.354 rows=455,976 loops=1)

  • Index Cond: (cluster_id = 39)
6. 0.136 0.136 ↑ 1.0 1 12 / 3

Index Scan using user_hubs_hub_id_user_id_idx on user_hubs (cost=0.43..8.46 rows=1 width=8) (actual time=0.034..0.034 rows=1 loops=12)

  • Index Cond: ((hub_id = 39) AND (user_id = user_clusters.user_id))
  • Filter: ((deleted_at IS NULL) AND (cluster_id = 39))
Planning time : 1.045 ms
Execution time : 401.095 ms