explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j6V0

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

Nested Loop Left Join (cost=100.25..8,545.37 rows=1 width=16) (actual time=18.196..18.196 rows=0 loops=1)

  • Filter: (member_public_token.id IS NULL)
2. 0.000 18.195 ↓ 0.0 0 1

Nested Loop Left Join (cost=99.83..8,531.40 rows=1 width=16) (actual time=18.195..18.195 rows=0 loops=1)

  • Filter: (card.id IS NULL)
3. 0.378 18.195 ↓ 0.0 0 1

Nested Loop Left Join (cost=99.54..8,527.32 rows=1 width=16) (actual time=18.195..18.195 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: 960
4. 0.123 15.897 ↓ 960.0 960 1

Nested Loop Left Join (cost=99.12..8,526.64 rows=1 width=69) (actual time=0.779..15.897 rows=960 loops=1)

5. 0.335 14.814 ↓ 960.0 960 1

Nested Loop Left Join (cost=98.68..8,525.77 rows=1 width=57) (actual time=0.776..14.814 rows=960 loops=1)

6. 0.509 14.479 ↓ 960.0 960 1

Nested Loop Left Join (cost=98.26..8,525.24 rows=1 width=53) (actual time=0.775..14.479 rows=960 loops=1)

7. 0.671 13.010 ↓ 960.0 960 1

Nested Loop Left Join (cost=97.83..8,517.46 rows=1 width=41) (actual time=0.770..13.010 rows=960 loops=1)

8. 0.087 11.379 ↓ 960.0 960 1

Nested Loop Left Join (cost=97.41..8,516.93 rows=1 width=33) (actual time=0.766..11.379 rows=960 loops=1)

  • Filter: (application.id IS NULL)
  • Rows Removed by Filter: 40
9. 0.548 10.292 ↑ 1.0 1,000 1

Nested Loop Left Join (cost=97.12..8,179.46 rows=1,000 width=33) (actual time=0.762..10.292 rows=1,000 loops=1)

10. 0.141 1.744 ↑ 1.0 1,000 1

Limit (cost=96.69..192.96 rows=1,000 width=20) (actual time=0.753..1.744 rows=1,000 loops=1)

11. 1.603 1.603 ↑ 538.9 2,000 1

Index Scan Backward using member_pkey on member (cost=0.43..103,751.61 rows=1,077,771 width=20) (actual time=0.011..1.603 rows=2,000 loops=1)

12. 8.000 8.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.008..0.008 rows=1 loops=1,000)

  • Index Cond: (member_uuid = member.uuid)
13. 1.000 1.000 ↓ 0.0 0 1,000

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=1,000)

  • Index Cond: (snapshot_id = snapshot.id)
14. 0.960 0.960 ↑ 1.0 1 960

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

  • Index Cond: (snapshot_id = snapshot.id)
15. 0.960 0.960 ↓ 0.0 0 960

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

  • Index Cond: (member_uuid = member.uuid)
16. 0.000 0.000 ↓ 0.0 0 960

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

  • Index Cond: (prescreen_identity_id = prescreen_identity.id)
17. 0.960 0.960 ↓ 0.0 0 960

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

  • Index Cond: (snapshot_id = snapshot.id)
18. 1.920 1.920 ↑ 1.0 1 960

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

  • Index Cond: (snapshot_id = snapshot.id)
19. 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)
20. 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=20) (never executed)

  • Index Cond: (member_uuid = member.uuid)
  • Filter: ((token_type)::text = 'APPLICATION_DEEPLINK'::text)
Planning time : 2.324 ms
Execution time : 18.363 ms