explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8APe

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

Nested Loop Anti Join (cost=3.99..92.33 rows=1 width=16) (actual time=0.054..0.054 rows=0 loops=1)

  • Join Filter: (member_public_token.member_uuid = member.uuid)
2. 0.000 0.053 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.57..75.84 rows=1 width=16) (actual time=0.053..0.053 rows=0 loops=1)

  • Join Filter: (card.member_uuid = member.uuid)
  • Filter: (card.id IS NULL)
3. 0.000 0.053 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.28..67.52 rows=1 width=16) (actual time=0.053..0.053 rows=0 loops=1)

  • Filter: (application.id IS NULL)
4. 0.004 0.053 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.98..59.20 rows=1 width=20) (actual time=0.053..0.053 rows=0 loops=1)

  • Filter: ((((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: 1
5. 0.000 0.044 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.55..50.71 rows=1 width=85) (actual time=0.042..0.044 rows=1 loops=1)

6. 0.000 0.036 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.13..42.26 rows=1 width=57) (actual time=0.035..0.036 rows=1 loops=1)

7. 0.000 0.036 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.70..33.81 rows=1 width=53) (actual time=0.035..0.036 rows=1 loops=1)

  • Join Filter: (prescreen_identity.member_uuid = member.uuid)
8. 0.000 0.030 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.28..25.35 rows=1 width=41) (actual time=0.029..0.030 rows=1 loops=1)

9. 0.005 0.024 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..16.90 rows=1 width=33) (actual time=0.023..0.024 rows=1 loops=1)

  • Join Filter: (snapshot.member_uuid = member.uuid)
10. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using member_uuid_unique_cons on member (cost=0.43..8.45 rows=1 width=16) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (uuid = '06894d4a-a943-4ab5-bdc7-80932165b592'::uuid)
  • Heap Fetches: 1
11. 0.008 0.008 ↑ 1.0 1 1

Index Scan using ix_snapshot_member_uuid on snapshot (cost=0.42..8.44 rows=1 width=33) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: (member_uuid = '06894d4a-a943-4ab5-bdc7-80932165b592'::uuid)
12. 0.006 0.006 ↑ 1.0 1 1

Index Scan using ix_evaluation_result_snapshot_id on evaluation_result (cost=0.42..8.44 rows=1 width=12) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (snapshot_id = snapshot.id)
13. 0.006 0.006 ↓ 0.0 0 1

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

  • Index Cond: (member_uuid = '06894d4a-a943-4ab5-bdc7-80932165b592'::uuid)
14. 0.000 0.000 ↓ 0.0 0 1

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

  • Index Cond: (prescreen_identity_id = prescreen_identity.id)
15. 0.008 0.008 ↑ 1.0 1 1

Index Scan using ix_pre_qualification_snapshot_id on pre_qualification (cost=0.42..8.44 rows=1 width=32) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: (snapshot_id = snapshot.id)
16. 0.005 0.005 ↓ 0.0 0 1

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

  • Index Cond: (snapshot_id = snapshot.id)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_application_snapshot_id on application (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Index Cond: (snapshot_id = snapshot.id)
18. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (member_uuid = '06894d4a-a943-4ab5-bdc7-80932165b592'::uuid)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using index_member_public_token_member_uuid on member_public_token (cost=0.42..16.48 rows=1 width=16) (never executed)

  • Index Cond: (member_uuid = '06894d4a-a943-4ab5-bdc7-80932165b592'::uuid)
  • Filter: ((token_type)::text = 'APPLICATION_DEEPLINK'::text)
Planning time : 2.203 ms
Execution time : 0.232 ms