explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ccrS

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 6.646 ↓ 1.3 8 1

Unique (cost=1,241.64..1,241.69 rows=6 width=8) (actual time=6.640..6.646 rows=8 loops=1)

2. 0.012 6.639 ↓ 1.7 10 1

Sort (cost=1,241.64..1,241.66 rows=6 width=8) (actual time=6.639..6.639 rows=10 loops=1)

  • Sort Key: fea1.fas_account_id, fau.user_id
  • Sort Method: quicksort Memory: 25kB
3. 0.012 6.627 ↓ 1.7 10 1

Nested Loop (cost=0.86..1,241.57 rows=6 width=8) (actual time=2.442..6.627 rows=10 loops=1)

  • Join Filter: (fea1.flourish_account_id = fea2.flourish_account_id)
4. 0.003 6.599 ↓ 2.7 8 1

Nested Loop (cost=0.57..1,240.48 rows=3 width=20) (actual time=2.436..6.599 rows=8 loops=1)

5. 0.012 6.580 ↓ 2.7 8 1

Nested Loop (cost=0.29..1,239.01 rows=3 width=16) (actual time=2.429..6.580 rows=8 loops=1)

6. 6.544 6.544 ↓ 1.1 8 1

Seq Scan on flourish_account_user fau (cost=0.00..1,184.82 rows=7 width=8) (actual time=2.416..6.544 rows=8 loops=1)

  • Filter: ((user_id_type = 'ACCOUNT_OWNER'::text) AND (user_id = ANY ('{3,4,5,6,7,8,9,10}'::integer[])))
  • Rows Removed by Filter: 30,305
7. 0.024 0.024 ↑ 1.0 1 8

Index Only Scan using flourish_external_account_pkey on flourish_external_account fea1 (cost=0.29..7.73 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=8)

  • Index Cond: (flourish_account_id = fau.flourish_account_id)
  • Heap Fetches: 8
8. 0.016 0.016 ↑ 1.0 1 8

Index Only Scan using flourish_account_pkey on flourish_account fa (cost=0.29..0.49 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=8)

  • Index Cond: (flourish_account_id = fea1.flourish_account_id)
  • Heap Fetches: 0
9. 0.016 0.016 ↑ 1.0 1 8

Index Only Scan using flourish_external_account_pkey on flourish_external_account fea2 (cost=0.29..0.35 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=8)

  • Index Cond: (flourish_account_id = fa.flourish_account_id)
  • Heap Fetches: 10
Planning time : 1.232 ms
Execution time : 6.696 ms