explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qmoM

Settings
# exclusive inclusive rows x rows loops node
1. 0.263 4.009 ↓ 45.0 270 1

Nested Loop (cost=318.29..588.67 rows=6 width=10) (actual time=2.205..4.009 rows=270 loops=1)

2. 0.123 2.666 ↓ 1.9 270 1

Nested Loop (cost=317.87..515.70 rows=139 width=14) (actual time=2.180..2.666 rows=270 loops=1)

3. 0.080 2.183 ↓ 2.0 45 1

HashAggregate (cost=317.45..317.68 rows=23 width=8) (actual time=2.158..2.183 rows=45 loops=1)

  • Group Key: u0.id
4. 0.067 2.103 ↓ 2.0 45 1

Nested Loop (cost=5.33..317.39 rows=23 width=8) (actual time=0.834..2.103 rows=45 loops=1)

5. 0.078 1.496 ↓ 1.9 45 1

Nested Loop (cost=4.90..295.38 rows=24 width=12) (actual time=0.751..1.496 rows=45 loops=1)

6. 0.421 1.058 ↓ 1.9 45 1

Bitmap Heap Scan on fs_node u0 (cost=4.48..92.82 rows=24 width=4) (actual time=0.667..1.058 rows=45 loops=1)

  • Recheck Cond: (path ~ '1.599.1587.5728.5730.5733.*{1}'::lquery)
  • Filter: (archived_at IS NULL)
  • Heap Blocks: exact=45
7. 0.637 0.637 ↓ 1.7 45 1

Bitmap Index Scan on path_gist_idx (cost=0.00..4.47 rows=26 width=0) (actual time=0.637..0.637 rows=45 loops=1)

  • Index Cond: (path ~ '1.599.1587.5728.5730.5733.*{1}'::lquery)
8. 0.360 0.360 ↑ 1.0 1 45

Index Scan using fs_permission_node_id_access_right_81ac3a0e_uniq on fs_permission u1 (cost=0.42..8.44 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=45)

  • Index Cond: ((node_id = u0.id) AND ((access_right)::text = 'view'::text))
9. 0.540 0.540 ↑ 1.0 1 45

Index Only Scan using fs_userpermission_user_id_permission_id_baa0e460_uniq on fs_userpermission u2 (cost=0.43..0.92 rows=1 width=4) (actual time=0.012..0.012 rows=1 loops=45)

  • Index Cond: ((user_id = 178) AND (permission_id = u1.id))
  • Heap Fetches: 33
10. 0.360 0.360 ↑ 1.0 6 45

Index Scan using fs_permission_node_id_638e8a2b on fs_permission (cost=0.42..8.55 rows=6 width=14) (actual time=0.006..0.008 rows=6 loops=45)

  • Index Cond: (node_id = u0.id)
11. 1.080 1.080 ↑ 1.0 1 270

Index Only Scan using fs_userpermission_user_id_permission_id_baa0e460_uniq on fs_userpermission (cost=0.43..0.52 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=270)

  • Index Cond: ((user_id = 178) AND (permission_id = fs_permission.id))
  • Heap Fetches: 198
Planning time : 2.930 ms
Execution time : 4.391 ms