explain.depesz.com

PostgreSQL's explain analyze made readable

Result: noZ2 : cluster count

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 3,303.981 ↑ 1.0 1 1

Aggregate (cost=1,241.29..1,241.30 rows=1 width=8) (actual time=3,303.981..3,303.981 rows=1 loops=1)

2. 0.000 3,303.976 ↓ 0.0 0 1

Nested Loop (cost=1.41..1,241.28 rows=1 width=0) (actual time=3,303.976..3,303.976 rows=0 loops=1)

3. 0.000 2,936.179 ↓ 385,476.0 385,476 1

Nested Loop Left Join (cost=0.99..1,240.83 rows=1 width=4) (actual time=17.937..2,936.179 rows=385,476 loops=1)

  • Filter: (mountablestorage_storagedevice.id IS NULL)
  • Rows Removed by Filter: 380
4. 32.894 2,626.213 ↓ 12,058.0 385,856 1

Nested Loop (cost=0.71..1,231.07 rows=32 width=4) (actual time=17.931..2,626.213 rows=385,856 loops=1)

5. 0.115 20.653 ↓ 526.0 526 1

Nested Loop (cost=0.29..1,223.88 rows=1 width=4) (actual time=17.918..20.653 rows=526 loops=1)

6. 17.848 17.848 ↑ 1.0 1 1

Seq Scan on billing_account (cost=0.00..1,221.56 rows=1 width=4) (actual time=17.239..17.848 rows=1 loops=1)

  • Filter: (company_id = 482)
  • Rows Removed by Filter: 14,887
7. 2.690 2.690 ↓ 526.0 526 1

Index Scan using authentication_user_account_id_78a72433 on authentication_user (cost=0.29..2.30 rows=1 width=8) (actual time=0.674..2.690 rows=526 loops=1)

  • Index Cond: (account_id = billing_account.id)
8. 2,572.666 2,572.666 ↓ 3.9 734 526

Index Scan using clusters_cluster_5e7b1936 on clusters_cluster (cost=0.42..5.33 rows=187 width=8) (actual time=0.178..4.891 rows=734 loops=526)

  • Index Cond: (owner_id = authentication_user.id)
  • Filter: (NOT is_deleted)
  • Rows Removed by Filter: 0
9. 385.856 385.856 ↓ 0.0 0 385,856

Index Scan using mountablestorage_storagedevice_cluster_id_key on mountablestorage_storagedevice (cost=0.28..0.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=385,856)

  • Index Cond: (clusters_cluster.id = cluster_id)
10. 385.476 385.476 ↓ 0.0 0 385,476

Index Scan using billing_projectassignment_cluster_id_key on billing_projectassignment u0 (cost=0.42..0.45 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=385,476)

  • Index Cond: (cluster_id = clusters_cluster.id)
  • Filter: (project_id = 371)
  • Rows Removed by Filter: 0