explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mpih

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 12,863.628 ↓ 0.0 0 1

Nested Loop Anti Join (cost=4,716.64..46,987.44 rows=1 width=16) (actual time=12,863.627..12,863.628 rows=0 loops=1)

2. 0.000 12,863.626 ↓ 0.0 0 1

Nested Loop Left Join (cost=4,716.22..46,986.77 rows=1 width=16) (actual time=12,863.626..12,863.626 rows=0 loops=1)

  • Filter: (card.id IS NULL)
3. 72.379 12,863.626 ↓ 0.0 0 1

Nested Loop Left Join (cost=4,715.93..46,986.44 rows=1 width=16) (actual time=12,863.626..12,863.626 rows=0 loops=1)

  • Filter: (((snapshot.member_uuid = '06894d4a-a943-4ab5-bdc7-80932165b592'::uuid) 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: 719,299
4. 398.293 11,352.649 ↓ 719,299.0 719,299 1

Nested Loop Left Join (cost=4,715.50..46,985.54 rows=1 width=85) (actual time=218.601..11,352.649 rows=719,299 loops=1)

5. 375.385 8,077.160 ↓ 719,299.0 719,299 1

Nested Loop Left Join (cost=4,715.07..46,984.88 rows=1 width=57) (actual time=217.259..8,077.160 rows=719,299 loops=1)

6. 109.722 7,701.775 ↓ 719,299.0 719,299 1

Nested Loop Left Join (cost=4,714.65..46,984.36 rows=1 width=53) (actual time=217.257..7,701.775 rows=719,299 loops=1)

7. 3.354 6,153.455 ↓ 719,299.0 719,299 1

Nested Loop Left Join (cost=4,714.22..46,983.77 rows=1 width=41) (actual time=216.586..6,153.455 rows=719,299 loops=1)

8. 360.056 1,115.176 ↓ 719,275.0 719,275 1

Hash Left Join (cost=4,713.80..46,983.24 rows=1 width=33) (actual time=214.531..1,115.176 rows=719,275 loops=1)

  • Hash Cond: (snapshot.id = application.snapshot_id)
  • Filter: (application.id IS NULL)
  • Rows Removed by Filter: 69,327
9. 541.250 541.250 ↓ 1.0 788,602 1

Seq Scan on snapshot (cost=0.00..38,627.93 rows=785,493 width=33) (actual time=0.025..541.250 rows=788,602 loops=1)

10. 22.127 213.870 ↑ 1.0 69,327 1

Hash (cost=3,843.91..3,843.91 rows=69,591 width=8) (actual time=213.870..213.870 rows=69,327 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 3,733kB
11. 191.743 191.743 ↑ 1.0 69,327 1

Seq Scan on application (cost=0.00..3,843.91 rows=69,591 width=8) (actual time=0.837..191.743 rows=69,327 loops=1)

12. 5,034.925 5,034.925 ↑ 1.0 1 719,275

Index Scan using ix_evaluation_result_snapshot_id on evaluation_result (cost=0.42..0.52 rows=1 width=12) (actual time=0.006..0.007 rows=1 loops=719,275)

  • Index Cond: (snapshot_id = snapshot.id)
13. 1,438.598 1,438.598 ↓ 0.0 0 719,299

Index Scan using prescreen_identity_member_uuid_key on prescreen_identity (cost=0.42..0.58 rows=1 width=28) (actual time=0.002..0.002 rows=0 loops=719,299)

  • Index Cond: (member_uuid = snapshot.member_uuid)
14. 0.000 0.000 ↓ 0.0 0 719,299

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=719,299)

  • Index Cond: (prescreen_identity_id = prescreen_identity.id)
15. 2,877.196 2,877.196 ↑ 1.0 1 719,299

Index Scan using ix_pre_qualification_snapshot_id on pre_qualification (cost=0.42..0.65 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=719,299)

  • Index Cond: (snapshot_id = snapshot.id)
16. 1,438.598 1,438.598 ↓ 0.0 0 719,299

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.002..0.002 rows=0 loops=719,299)

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

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

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

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

  • Index Cond: (member_uuid = snapshot.member_uuid)
  • Filter: ((token_type)::text = 'APPLICATION_DEEPLINK'::text)
Planning time : 22.920 ms
Execution time : 12,863.924 ms