explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IO7f

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 6.862 ↓ 98.0 98 1

Limit (cost=394.49..394.50 rows=1 width=128) (actual time=6.838..6.862 rows=98 loops=1)

2. 0.187 6.850 ↓ 98.0 98 1

Sort (cost=394.49..394.50 rows=1 width=128) (actual time=6.837..6.850 rows=98 loops=1)

  • Sort Key: communication_emailevent."timestamp" DESC
  • Sort Method: quicksort Memory: 38kB
3. 0.046 6.663 ↓ 98.0 98 1

Nested Loop (cost=2.27..394.48 rows=1 width=128) (actual time=0.131..6.663 rows=98 loops=1)

4. 0.074 6.225 ↓ 98.0 98 1

Nested Loop (cost=1.98..390.82 rows=1 width=136) (actual time=0.086..6.225 rows=98 loops=1)

5. 0.070 5.857 ↓ 98.0 98 1

Nested Loop (cost=1.70..387.34 rows=1 width=132) (actual time=0.075..5.857 rows=98 loops=1)

6. 0.018 5.493 ↓ 98.0 98 1

Nested Loop (cost=1.42..383.95 rows=1 width=132) (actual time=0.070..5.493 rows=98 loops=1)

7. 0.091 4.985 ↓ 98.0 98 1

Nested Loop (cost=0.99..375.50 rows=1 width=128) (actual time=0.061..4.985 rows=98 loops=1)

8. 0.058 0.058 ↓ 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.038..0.058 rows=93 loops=1)

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

Index Scan using communication_emailevent_8b938c66 on communication_emailevent (cost=0.57..369.81 rows=1 width=74) (actual time=0.011..0.052 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) AND ((info)::text = 'G'::text))
  • Rows Removed by Filter: 43
10. 0.490 0.490 ↑ 1.0 1 98

Index Scan using communication_communicationprocess_pkey on communication_communicationprocess (cost=0.42..8.44 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=98)

  • Index Cond: (process_ptr_id = communication_emailevent.process_id)
11. 0.294 0.294 ↑ 1.0 1 98

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=98)

  • Index Cond: (id = communication_communicationprocess.owner_id)
12. 0.294 0.294 ↑ 1.0 1 98

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=98)

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

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.004 rows=1 loops=98)

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