explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TNeR

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 717.677 ↓ 0.0 0 1

Nested Loop Left Join (cost=15,498.68..23,930.26 rows=1 width=16) (actual time=717.677..717.677 rows=0 loops=1)

  • Filter: (card.id IS NULL)
2. 17.079 717.676 ↓ 0.0 0 1

Nested Loop Left Join (cost=15,498.39..23,926.18 rows=1 width=16) (actual time=717.676..717.676 rows=0 loops=1)

  • Filter: (((NOT (hashed SubPlan 1)) AND ((pre_qualification.application_status)::text = 'COMPLETE'::text) AND ((pre_qualification.underwriting_status)::text = 'APPROVED'::text) AND (pre_qualification.date_modified < '2019-09-30 00:00:00'::timestamp without time zone) AND (evaluation_result.date_created > '2019-09-01 00:00:00'::timestamp without time zone)) OR ((prescreen_offer.expiration_date > '2019-09-30 00:00:00'::timestamp without time zone) AND (prescreen_identity.date_modified < '2019-09-30 00:00:00'::timestamp without time zone) AND (prescreen_identity.date_modified > '2019-09-30 00:00:00'::timestamp without time zone)) OR (((snapshot.type)::text = 'FACEBOOK_PRESCREEN'::text) AND (fb_prescreen_offer.id IS NOT NULL) AND (fb_prescreen_offer.date_modified < '2019-09-30 00:00:00'::timestamp without time zone) AND (fb_prescreen_offer.date_modified > '2019-09-01 00:00:00'::timestamp without time zone)))
  • Rows Removed by Filter: 875
3. 0.121 9.840 ↓ 875.0 875 1

Nested Loop Left Join (cost=2.85..8,430.38 rows=1 width=69) (actual time=0.168..9.840 rows=875 loops=1)

4. 0.324 8.844 ↓ 875.0 875 1

Nested Loop Left Join (cost=2.42..8,429.50 rows=1 width=57) (actual time=0.162..8.844 rows=875 loops=1)

5. 0.540 8.520 ↓ 875.0 875 1

Nested Loop Left Join (cost=2.00..8,428.98 rows=1 width=53) (actual time=0.160..8.520 rows=875 loops=1)

6. 0.506 7.105 ↓ 875.0 875 1

Nested Loop Left Join (cost=1.57..8,421.20 rows=1 width=41) (actual time=0.035..7.105 rows=875 loops=1)

7. 0.057 5.724 ↓ 875.0 875 1

Nested Loop Left Join (cost=1.15..8,420.66 rows=1 width=33) (actual time=0.028..5.724 rows=875 loops=1)

  • Filter: (application.id IS NULL)
  • Rows Removed by Filter: 40
8. 0.000 4.752 ↑ 1.1 915 1

Nested Loop (cost=0.85..8,083.19 rows=1,000 width=33) (actual time=0.023..4.752 rows=915 loops=1)

9. 0.086 0.942 ↑ 1.0 1,000 1

Limit (cost=0.43..96.69 rows=1,000 width=20) (actual time=0.014..0.942 rows=1,000 loops=1)

10. 0.856 0.856 ↑ 1,077.6 1,000 1

Index Scan Backward using member_pkey on member (cost=0.43..103,737.18 rows=1,077,597 width=20) (actual time=0.013..0.856 rows=1,000 loops=1)

11. 4.000 4.000 ↑ 1.0 1 1,000

Index Scan using ix_snapshot_member_uuid on snapshot (cost=0.42..7.97 rows=1 width=33) (actual time=0.003..0.004 rows=1 loops=1,000)

  • Index Cond: (member_uuid = member.uuid)
12. 0.915 0.915 ↓ 0.0 0 915

Index Scan using ix_application_snapshot_id on application (cost=0.29..0.33 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=915)

  • Index Cond: (snapshot_id = snapshot.id)
13. 0.875 0.875 ↑ 1.0 1 875

Index Scan using ix_evaluation_result_snapshot_id on evaluation_result (cost=0.42..0.52 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=875)

  • Index Cond: (snapshot_id = snapshot.id)
14. 0.875 0.875 ↓ 0.0 0 875

Index Scan using prescreen_identity_member_uuid_key on prescreen_identity (cost=0.42..7.77 rows=1 width=28) (actual time=0.001..0.001 rows=0 loops=875)

  • Index Cond: (member_uuid = member.uuid)
15. 0.000 0.000 ↓ 0.0 0 875

Index Scan using ix_prescreen_offer_prescreen_identity_id on prescreen_offer (cost=0.42..0.51 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=875)

  • Index Cond: (prescreen_identity_id = prescreen_identity.id)
16. 0.875 0.875 ↓ 0.0 0 875

Index Scan using fb_prescreen_offer_snapshot_id_key on fb_prescreen_offer (cost=0.43..0.86 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=875)

  • Index Cond: (snapshot_id = snapshot.id)
17. 1.750 1.750 ↑ 1.0 1 875

Index Scan using ix_pre_qualification_snapshot_id on pre_qualification (cost=0.42..0.65 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=875)

  • Index Cond: (snapshot_id = snapshot.id)
18.          

SubPlan (for Nested Loop Left Join)

19. 689.007 689.007 ↑ 1.0 48,895 1

Seq Scan on member_public_token (cost=0.00..15,371.80 rows=49,327 width=16) (actual time=0.757..689.007 rows=48,895 loops=1)

  • Filter: ((token_type)::text = 'APPLICATION_DEEPLINK'::text)
  • Rows Removed by Filter: 204,379
20. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_card_member_uuid on card (cost=0.29..4.07 rows=1 width=20) (never executed)

  • Index Cond: (member_uuid = member.uuid)
Planning time : 2.315 ms
Execution time : 717.856 ms