explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7LRn

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 8.059 ↓ 100.0 100 1

Limit (cost=389.56..389.57 rows=1 width=128) (actual time=8.033..8.059 rows=100 loops=1)

2. 0.179 8.047 ↓ 100.0 100 1

Sort (cost=389.56..389.57 rows=1 width=128) (actual time=8.031..8.047 rows=100 loops=1)

  • Sort Key: communication_emailevent."timestamp" DESC
  • Sort Method: quicksort Memory: 39kB
3. 0.117 7.868 ↓ 100.0 100 1

Nested Loop (cost=2.27..389.55 rows=1 width=128) (actual time=0.132..7.868 rows=100 loops=1)

4. 0.068 7.451 ↓ 100.0 100 1

Nested Loop (cost=1.98..385.89 rows=1 width=136) (actual time=0.121..7.451 rows=100 loops=1)

5. 0.092 7.083 ↓ 100.0 100 1

Nested Loop (cost=1.70..382.41 rows=1 width=132) (actual time=0.110..7.083 rows=100 loops=1)

6. 0.049 6.691 ↓ 100.0 100 1

Nested Loop (cost=1.42..379.02 rows=1 width=132) (actual time=0.100..6.691 rows=100 loops=1)

7. 0.081 6.042 ↓ 100.0 100 1

Nested Loop (cost=0.99..375.07 rows=1 width=128) (actual time=0.091..6.042 rows=100 loops=1)

8. 0.102 0.102 ↓ 93.0 93 1

Index Scan using contact_contact_frequency_pref_5a2e2f212093a5d5_uniq on contact_contact (cost=0.43..5.68 rows=1 width=54) (actual time=0.066..0.102 rows=93 loops=1)

  • Index Cond: ((frequency_pref)::text = 'G'::text)
9. 5.859 5.859 ↑ 1.0 1 93

Index Scan using communication_emailevent_8b938c66 on communication_emailevent (cost=0.57..369.39 rows=1 width=74) (actual time=0.014..0.063 rows=1 loops=93)

  • Index Cond: (recipient_id = contact_contact.id)
  • Filter: (("timestamp" >= '2017-12-01 12:46:00-05'::timestamp with time zone) AND ((event)::text = 'P'::text))
  • Rows Removed by Filter: 43
10. 0.600 0.600 ↑ 1.0 1 100

Index Scan using communication_communicationprocess_pkey on communication_communicationprocess (cost=0.42..3.94 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=100)

  • Index Cond: (process_ptr_id = communication_emailevent.process_id)
11. 0.300 0.300 ↑ 1.0 1 100

Index Scan using user_profile_advisoraccount_pkey on user_profile_advisoraccount (cost=0.28..3.38 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (id = communication_communicationprocess.owner_id)
12. 0.300 0.300 ↑ 1.0 1 100

Index Only Scan using auth_user_pkey on auth_user (cost=0.28..3.48 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (id = user_profile_advisoraccount.user_id)
  • Heap Fetches: 100
13. 0.300 0.300 ↑ 1.0 1 100

Index Only Scan using auth_user_groups_user_id_group_id_key on auth_user_groups (cost=0.29..3.65 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: ((user_id = user_profile_advisoraccount.user_id) AND (group_id = 10))
  • Heap Fetches: 100