explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IhvL

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 107.119 ↓ 0.0 0 1

Nested Loop Anti Join (cost=160.22..1,000.00 rows=1 width=16) (actual time=107.119..107.119 rows=0 loops=1)

2. 0.000 107.117 ↓ 0.0 0 1

Nested Loop Left Join (cost=159.80..986.03 rows=1 width=16) (actual time=107.117..107.117 rows=0 loops=1)

  • Filter: (card.id IS NULL)
3. 0.000 107.117 ↓ 0.0 0 1

Nested Loop Left Join (cost=159.51..981.95 rows=1 width=16) (actual time=107.117..107.117 rows=0 loops=1)

  • Filter: (application.id IS NULL)
4. 0.000 107.117 ↓ 0.0 0 1

Nested Loop Left Join (cost=159.21..981.61 rows=1 width=20) (actual time=107.117..107.117 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)))
5. 0.001 107.117 ↓ 0.0 0 1

Nested Loop (cost=158.78..980.72 rows=1 width=85) (actual time=107.117..107.117 rows=0 loops=1)

6. 0.000 107.116 ↓ 0.0 0 1

Nested Loop (cost=158.36..980.19 rows=1 width=81) (actual time=107.116..107.116 rows=0 loops=1)

7. 0.000 107.116 ↓ 0.0 0 1

Nested Loop (cost=157.93..979.66 rows=1 width=77) (actual time=107.116..107.116 rows=0 loops=1)

8. 0.001 107.116 ↓ 0.0 0 1

Nested Loop (cost=157.51..979.00 rows=1 width=45) (actual time=107.116..107.116 rows=0 loops=1)

  • Join Filter: (member_chunk.member_uuid = snapshot.member_uuid)
9. 0.428 107.115 ↓ 0.0 0 1

Merge Join (cost=157.08..357.25 rows=884 width=44) (actual time=107.115..107.115 rows=0 loops=1)

  • Merge Cond: (prescreen_identity.member_uuid = member_chunk.member_uuid)
10. 105.190 105.190 ↑ 449.0 1,257 1

Index Scan using prescreen_identity_member_uuid_key on prescreen_identity (cost=0.42..117,633.30 rows=564,395 width=28) (actual time=0.011..105.190 rows=1,257 loops=1)

11. 0.518 1.497 ↑ 1.0 1,000 1

Sort (cost=156.53..159.03 rows=1,000 width=16) (actual time=1.283..1.497 rows=1,000 loops=1)

  • Sort Key: member_chunk.member_uuid
  • Sort Method: quicksort Memory: 71kB
12. 0.109 0.979 ↑ 1.0 1,000 1

Subquery Scan on member_chunk (cost=0.43..106.70 rows=1,000 width=16) (actual time=0.015..0.979 rows=1,000 loops=1)

13. 0.061 0.870 ↑ 1.0 1,000 1

Limit (cost=0.43..96.70 rows=1,000 width=20) (actual time=0.015..0.870 rows=1,000 loops=1)

14. 0.809 0.809 ↑ 1,077.0 1,000 1

Index Scan Backward using member_pkey on member (cost=0.43..103,685.65 rows=1,076,976 width=20) (actual time=0.014..0.809 rows=1,000 loops=1)

15. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_snapshot_member_uuid on snapshot (cost=0.42..0.69 rows=1 width=33) (never executed)

  • Index Cond: (member_uuid = prescreen_identity.member_uuid)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_pre_qualification_snapshot_id on pre_qualification (cost=0.42..0.65 rows=1 width=32) (never executed)

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

Index Scan using ix_evaluation_result_snapshot_id on evaluation_result (cost=0.42..0.52 rows=1 width=12) (never executed)

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

Index Scan using ix_prescreen_offer_prescreen_identity_id on prescreen_offer (cost=0.42..0.51 rows=1 width=12) (never executed)

  • Index Cond: (prescreen_identity_id = prescreen_identity.id)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using fb_prescreen_offer_snapshot_id_key on fb_prescreen_offer (cost=0.43..0.86 rows=1 width=16) (never executed)

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

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

  • Index Cond: (snapshot_id = snapshot.id)
21. 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_chunk.member_uuid)
22. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (member_uuid = member_chunk.member_uuid)
  • Filter: ((token_type)::text = 'APPLICATION_DEEPLINK'::text)
Planning time : 20.943 ms
Execution time : 107.338 ms