explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JVHt

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

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

2. 0.011 6.787 ↓ 1.7 10 1

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

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

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

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

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

5. 0.006 6.728 ↓ 2.7 8 1

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

6. 6.690 6.690 ↓ 1.1 8 1

Seq Scan on flourish_account_user fau (cost=0.00..1,184.82 rows=7 width=8) (actual time=2.855..6.690 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,304
7. 0.032 0.032 ↑ 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.004 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.258 ms
Execution time : 6.869 ms