explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iX15

Settings
# exclusive inclusive rows x rows loops node
1. 20.833 617,591.522 ↓ 0.0 0 1

Delete on public.persons (cost=1,851,521.34..1,860,697.56 rows=1,203 width=102) (actual time=617,591.494..617,591.522 rows=0 loops=1)

2. 0.762 617,570.689 ↓ 1.9 2,329 1

Nested Loop (cost=1,851,521.34..1,860,697.56 rows=1,203 width=102) (actual time=617,465.669..617,570.689 rows=2,329 loops=1)

  • Output: persons.ctid, r.ctid, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid, em1.ctid, em2.ctid, ev_recipient_so.ctid, evs_tml.ctid, fast_access_scens.ctid, form_perms.ctid, imported_recipient.ctid, recip_resp_stats.ctid,
  • Inner Unique: true
3. 3.779 617,430.187 ↑ 1.1 2,329 1

HashAggregate (cost=1,851,520.90..1,851,547.57 rows=2,667 width=104) (actual time=617,429.100..617,430.187 rows=2,329 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid, em1.ctid, em2.ctid, ev_recipient_so.ctid, evs_tml.ctid, fast_access_scens.ctid, form_perms.ctid, imported_recipient.ctid, recip_resp_stat
  • Group Key: r.recipient_id
4. 1.480 617,426.408 ↓ 2.9 7,864 1

Nested Loop Anti Join (cost=3.30..1,851,514.23 rows=2,667 width=104) (actual time=292.503..617,426.408 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid, em1.ctid, em2.ctid, ev_recipient_so.ctid, evs_tml.ctid, fast_access_scens.ctid, form_perms.ctid, imported_recipient.ctid, recip_res
5. 2.234 617,377.744 ↓ 2.9 7,864 1

Merge Anti Join (cost=3.01..1,850,694.07 rows=2,667 width=98) (actual time=253.024..617,377.744 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid, em1.ctid, em2.ctid, ev_recipient_so.ctid, evs_tml.ctid, fast_access_scens.ctid, form_perms.ctid, imported_recipient.ctid, rec
  • Merge Cond: (r.recipient_id = form_perms.person_id)
6. 0.267 617,361.193 ↓ 2.9 7,864 1

Nested Loop Anti Join (cost=2.29..1,850,663.66 rows=2,667 width=92) (actual time=238.699..617,361.193 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid, em1.ctid, em2.ctid, ev_recipient_so.ctid, evs_tml.ctid, fast_access_scens.ctid, imported_recipient.ctid, recip_resp_sta
7. 1.915 617,274.422 ↓ 2.9 7,864 1

Nested Loop Anti Join (cost=1.87..1,845,398.79 rows=2,667 width=86) (actual time=163.419..617,274.422 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid, em1.ctid, em2.ctid, ev_recipient_so.ctid, evs_tml.ctid, fast_access_scens.ctid, imported_recipient.ctid, recip_re
8. 7.131 617,264.643 ↓ 2.9 7,864 1

Nested Loop Anti Join (cost=1.58..1,844,578.54 rows=2,667 width=80) (actual time=163.408..617,264.643 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid, em1.ctid, em2.ctid, ev_recipient_so.ctid, evs_tml.ctid, fast_access_scens.ctid, imported_recipient.ctid, re
  • Join Filter: (r.recipient_id = recip_resp_stats.recip_id)
  • Rows Removed by Join Filter: 31,456
9. 1.653 617,257.512 ↓ 2.9 7,864 1

Merge Anti Join (cost=1.58..1,844,417.47 rows=2,667 width=74) (actual time=163.391..617,257.512 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid, em1.ctid, em2.ctid, ev_recipient_so.ctid, evs_tml.ctid, fast_access_scens.ctid, imported_recipient.ct
  • Merge Cond: (r.recipient_id = imported_recipient.recipient_id)
10. 2.425 617,255.855 ↓ 2.9 7,864 1

Nested Loop Anti Join (cost=1.43..1,844,380.14 rows=2,667 width=68) (actual time=163.384..617,255.855 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid, em1.ctid, em2.ctid, ev_recipient_so.ctid, evs_tml.ctid, fast_access_scens.ctid
  • Join Filter: (r.recipient_id = fast_access_scens.person_id)
11. 2.337 617,253.430 ↓ 2.9 7,864 1

Nested Loop Anti Join (cost=1.43..1,835,966.47 rows=2,667 width=62) (actual time=163.379..617,253.430 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid, em1.ctid, em2.ctid, ev_recipient_so.ctid, evs_tml.ctid
  • Join Filter: (r.recipient_id = evs_tml.owner)
12. 2.307 617,251.093 ↓ 2.9 7,864 1

Nested Loop Anti Join (cost=1.43..1,835,156.12 rows=2,667 width=56) (actual time=163.371..617,251.093 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid, em1.ctid, em2.ctid, ev_recipient_so.ctid
  • Join Filter: (r.recipient_id = ev_recipient_so.recipient_id)
13. 2.324 617,248.786 ↓ 2.9 7,864 1

Nested Loop Anti Join (cost=1.43..1,829,543.67 rows=2,667 width=50) (actual time=163.366..617,248.786 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid, em1.ctid, em2.ctid
  • Join Filter: (r.recipient_id = em2.launcher_id)
14. 2.412 617,246.462 ↓ 2.9 7,864 1

Nested Loop Anti Join (cost=1.43..1,828,733.32 rows=2,667 width=44) (actual time=163.362..617,246.462 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid, em1.ctid
  • Join Filter: (r.recipient_id = em1.halter_id)
15. 1.395 617,244.050 ↓ 2.9 7,864 1

Merge Anti Join (cost=1.43..1,827,922.97 rows=2,667 width=38) (actual time=163.344..617,244.050 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid, enh_msg_recipients.ctid
  • Merge Cond: (r.recipient_id = enh_msg_recipients.recipient_id)
16. 1.415 617,242.651 ↓ 2.9 7,864 1

Merge Anti Join (cost=1.28..1,827,878.64 rows=2,667 width=32) (actual time=163.338..617,242.651 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid, enh_msg_monitors.ctid
  • Merge Cond: (r.recipient_id = enh_msg_monitors.person_id)
17. 2.678 617,241.231 ↓ 2.9 7,864 1

Nested Loop Left Join (cost=1.12..1,827,831.51 rows=2,667 width=26) (actual time=163.330..617,241.231 rows=7,864 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid, dvc.ctid
18. 617,226.908 617,226.908 ↑ 1.1 2,329 1

Nested Loop Left Join (cost=0.56..1,783,869.32 rows=2,667 width=20) (actual time=163.309..617,226.908 rows=2,329 loops=1)

  • Output: r.ctid, r.recipient_id, contact_sessions.ctid
  • Join Filter: (r.recipient_id = contact_sessions.person_id)
  • -> Index Scan using recipients_recipid_person_deleted_pidx on public.recipients r (cost=0.56..1780257.75 rows=2,667 width=14) (actual time=163.296..617226.214
  • Output: r.ctid, r.recipient_id
  • Filter: ((r.deleted_id <> '-1'::integer) AND (r.when_updated <= '2018-12-24 23:30:06.291+00'::timestamp with time zone) AND ((r.recipient_cat)::text = 'PE
  • Rows Removed by Filter: 26,706,187
19. 0.000 0.000 ↓ 0.0 0 2,329

Materialize (cost=0.00..11.35 rows=90 width=14) (actual time=0.000..0.000 rows=0 loops=2,329)

  • Output: contact_sessions.ctid, contact_sessions.person_id
20. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on public.contact_sessions (cost=0.00..10.90 rows=90 width=14) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: contact_sessions.ctid, contact_sessions.person_id
21. 11.645 11.645 ↑ 28.3 3 2,329

Index Scan using idx_dvc2 on public.dvc (cost=0.56..15.63 rows=85 width=14) (actual time=0.003..0.005 rows=3 loops=2,329)

  • Output: dvc.ctid, dvc.person_id
  • Index Cond: (dvc.person_id = r.recipient_id)
22. 0.005 0.005 ↓ 0.0 0 1

Index Scan using idx_enh_msg_monitors2 on public.enh_msg_monitors (cost=0.15..37.05 rows=1,360 width=14) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: enh_msg_monitors.ctid, enh_msg_monitors.person_id
23. 0.004 0.004 ↓ 0.0 0 1

Index Scan using idx_enh_msg_recipients2 on public.enh_msg_recipients (cost=0.15..34.65 rows=1,200 width=14) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: enh_msg_recipients.ctid, enh_msg_recipients.recipient_id
24. 0.000 0.000 ↓ 0.0 0 7,864

Materialize (cost=0.00..10.30 rows=20 width=14) (actual time=0.000..0.000 rows=0 loops=7,864)

  • Output: em1.ctid, em1.halter_id
25. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on public.enh_msgs em1 (cost=0.00..10.20 rows=20 width=14) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: em1.ctid, em1.halter_id
26. 0.000 0.000 ↓ 0.0 0 7,864

Materialize (cost=0.00..10.30 rows=20 width=14) (actual time=0.000..0.000 rows=0 loops=7,864)

  • Output: em2.ctid, em2.launcher_id
27. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on public.enh_msgs em2 (cost=0.00..10.20 rows=20 width=14) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: em2.ctid, em2.launcher_id
28. 0.000 0.000 ↓ 0.0 0 7,864

Materialize (cost=0.00..12.10 rows=140 width=14) (actual time=0.000..0.000 rows=0 loops=7,864)

  • Output: ev_recipient_so.ctid, ev_recipient_so.recipient_id
29. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on public.ev_recipient_so (cost=0.00..11.40 rows=140 width=14) (actual time=0.002..0.003 rows=0 loops=1)

  • Output: ev_recipient_so.ctid, ev_recipient_so.recipient_id
30. 0.000 0.000 ↓ 0.0 0 7,864

Materialize (cost=0.00..10.30 rows=20 width=14) (actual time=0.000..0.000 rows=0 loops=7,864)

  • Output: evs_tml.ctid, evs_tml.owner
31. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on public.evs_tml (cost=0.00..10.20 rows=20 width=14) (actual time=0.002..0.003 rows=0 loops=1)

  • Output: evs_tml.ctid, evs_tml.owner
32. 0.000 0.000 ↓ 0.0 0 7,864

Materialize (cost=0.00..13.15 rows=210 width=14) (actual time=0.000..0.000 rows=0 loops=7,864)

  • Output: fast_access_scens.ctid, fast_access_scens.person_id
33. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.fast_access_scens (cost=0.00..12.10 rows=210 width=14) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: fast_access_scens.ctid, fast_access_scens.person_id
34. 0.004 0.004 ↓ 0.0 0 1

Index Scan using idx_imported_recipient_id on public.imported_recipient (cost=0.15..28.65 rows=800 width=14) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: imported_recipient.ctid, imported_recipient.recipient_id
35. 0.000 0.000 ↑ 1.0 4 7,864

Materialize (cost=0.00..1.06 rows=4 width=14) (actual time=0.000..0.000 rows=4 loops=7,864)

  • Output: recip_resp_stats.ctid, recip_resp_stats.recip_id
36. 0.007 0.007 ↑ 1.0 4 1

Seq Scan on public.recip_resp_stats (cost=0.00..1.04 rows=4 width=14) (actual time=0.006..0.007 rows=4 loops=1)

  • Output: recip_resp_stats.ctid, recip_resp_stats.recip_id
37. 7.864 7.864 ↓ 0.0 0 7,864

Index Scan using idx_recipient_ntfn5 on public.recipient_ntfn (cost=0.29..225.99 rows=12,865 width=14) (actual time=0.001..0.001 rows=0 loops=7,864)

  • Output: recipient_ntfn.ctid, recipient_ntfn.recipient_id
  • Index Cond: (recipient_ntfn.recipient_id = r.recipient_id)
38. 86.504 86.504 ↓ 0.0 0 7,864

Index Scan using idx_sns3 on public.sns (cost=0.42..1.97 rows=1 width=14) (actual time=0.011..0.011 rows=0 loops=7,864)

  • Output: sns.ctid, sns.last_update_recipient_id
  • Index Cond: (sns.last_update_recipient_id = r.recipient_id)
39. 14.317 14.317 ↑ 47.3 10 1

Index Scan using idx_form_perm_pers on public.form_perms (cost=0.27..22.55 rows=473 width=14) (actual time=14.313..14.317 rows=10 loops=1)

  • Output: form_perms.ctid, form_perms.person_id
40. 47.184 47.184 ↓ 0.0 0 7,864

Index Scan using idx_sns_recipients2 on public.sns_recipients (cost=0.29..338.17 rows=19,296 width=14) (actual time=0.006..0.006 rows=0 loops=7,864)

  • Output: sns_recipients.ctid, sns_recipients.recipient_id
  • Index Cond: (sns_recipients.recipient_id = r.recipient_id)
41. 139.740 139.740 ↑ 1.0 1 2,329

Index Scan using persons_pk on public.persons (cost=0.44..3.43 rows=1 width=14) (actual time=0.060..0.060 rows=1 loops=2,329)

  • Output: persons.ctid, persons.person_id
  • Index Cond: (persons.person_id = r.recipient_id)
Planning time : 1,213.153 ms
Execution time : 627,812.383 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
RI_ConstraintTrigger_a_3294742 for constraint application_perms_person_id_fk on persons 91.329 ms 2329 0.039 ms
RI_ConstraintTrigger_a_3294752 for constraint application_person_id_fk on persons 183.373 ms 2329 0.079 ms
RI_ConstraintTrigger_a_3294797 for constraint cfav_to_persons_fk on persons 49.876 ms 2329 0.021 ms
RI_ConstraintTrigger_a_3294852 for constraint contact_sessions_fk1 on persons 96.872 ms 2329 0.042 ms
RI_ConstraintTrigger_a_3294892 for constraint cov_pid_fk1 on persons 57.542 ms 2329 0.025 ms
RI_ConstraintTrigger_a_3294937 for constraint dashboard_owner_fk on persons 41.211 ms 2329 0.018 ms
RI_ConstraintTrigger_a_3294942 for constraint dashboard_usage_person_fk on persons 37.766 ms 2329 0.016 ms
RI_ConstraintTrigger_a_3295137 for constraint dyntm_pid_fk1 on persons 54.519 ms 2329 0.023 ms
RI_ConstraintTrigger_a_3295177 for constraint enh_msg_monitors_fk2 on persons 78.870 ms 2329 0.034 ms
RI_ConstraintTrigger_a_3295232 for constraint enh_msgs_fk4 on persons 68.362 ms 2329 0.029 ms
RI_ConstraintTrigger_a_3295237 for constraint enh_msgs_fk5 on persons 64.064 ms 2329 0.028 ms
RI_ConstraintTrigger_a_3295297 for constraint ev_annotation_person_id_fk on persons 48.955 ms 2329 0.021 ms
RI_ConstraintTrigger_a_3295482 for constraint fast_access_scens_fk2 on persons 86.916 ms 2329 0.037 ms
RI_ConstraintTrigger_a_3295552 for constraint fk_dp_person_id on persons 35.854 ms 2329 0.015 ms
RI_ConstraintTrigger_a_3295632 for constraint fk_import_job_person on persons 46.441 ms 2329 0.020 ms
RI_ConstraintTrigger_a_3295722 for constraint fk_pass_reset_person on persons 43.893 ms 2329 0.019 ms
RI_ConstraintTrigger_a_3295747 for constraint fk_ppv_to_person on persons 41.135 ms 2329 0.018 ms
RI_ConstraintTrigger_a_3295852 for constraint fk_rsp_person_id on persons 54.133 ms 2329 0.023 ms
RI_ConstraintTrigger_a_3295882 for constraint fk_scen_attachments_person on persons 36.615 ms 2329 0.016 ms
RI_ConstraintTrigger_a_3295922 for constraint fk_sfp_person_id on persons 56.441 ms 2329 0.024 ms
RI_ConstraintTrigger_a_3295977 for constraint fk_sub_perms_person_id on persons 42.191 ms 2329 0.018 ms
RI_ConstraintTrigger_a_3296102 for constraint form_perm_pers_fk on persons 69.939 ms 2329 0.030 ms
RI_ConstraintTrigger_a_3296187 for constraint import_by_person_fk on persons 203.997 ms 2329 0.088 ms
RI_ConstraintTrigger_a_3296262 for constraint incidents_owner_fk on persons 147.024 ms 2329 0.063 ms
RI_ConstraintTrigger_a_3296267 for constraint incidents_reporter_fk on persons 67.101 ms 2329 0.029 ms
RI_ConstraintTrigger_a_3296277 for constraint infocenter_user_state_person_id_fk on persons 65.546 ms 2329 0.028 ms
RI_ConstraintTrigger_a_3296287 for constraint integration_associations_person_id_fk on persons 64.454 ms 2329 0.028 ms
RI_ConstraintTrigger_a_3296297 for constraint integration_endpoints_api_person_id_fk on persons 77.670 ms 2329 0.033 ms
RI_ConstraintTrigger_a_3296362 for constraint integration_script_steps_creator_fk on persons 89.716 ms 2329 0.039 ms
RI_ConstraintTrigger_a_3296372 for constraint integration_script_steps_owner_fk on persons 76.034 ms 2329 0.033 ms
RI_ConstraintTrigger_a_3296417 for constraint integrations_run_as_fkey on persons 75.090 ms 2329 0.032 ms
RI_ConstraintTrigger_a_3296477 for constraint libraries_owner_fk on persons 65.247 ms 2329 0.028 ms
RI_ConstraintTrigger_a_3296492 for constraint library_perms_person_id_fk on persons 63.722 ms 2329 0.027 ms
RI_ConstraintTrigger_a_3296637 for constraint oauth_access_token_person_id_fk on persons 58.675 ms 2329 0.025 ms
RI_ConstraintTrigger_a_3296657 for constraint oauth_refresh_tokens_person_id_fk on persons 41.064 ms 2329 0.018 ms
RI_ConstraintTrigger_a_3296672 for constraint oncall_reminder_person_id_fk on persons 35.329 ms 2329 0.015 ms
RI_ConstraintTrigger_a_3296702 for constraint oncall_shift_data_person_id_fk on persons 80.066 ms 2329 0.034 ms
RI_ConstraintTrigger_a_3296892 for constraint pcv_to_persons_fk on persons 36.156 ms 2329 0.016 ms
RI_ConstraintTrigger_a_3296897 for constraint person_alert_fk on persons 36.961 ms 2329 0.016 ms
RI_ConstraintTrigger_a_3296907 for constraint person_api_keys_person_id_fk on persons 36.293 ms 2329 0.016 ms
RI_ConstraintTrigger_a_3296912 for constraint person_attrs_fk1 on persons 35.726 ms 2329 0.015 ms
RI_ConstraintTrigger_a_3296927 for constraint person_favorites_fk1 on persons 93.008 ms 2329 0.040 ms
RI_ConstraintTrigger_a_3296932 for constraint person_favorites_fk2 on persons 37.389 ms 2329 0.016 ms
RI_ConstraintTrigger_a_3296937 for constraint person_id_fk on persons 73.205 ms 2329 0.031 ms
RI_ConstraintTrigger_a_3296947 for constraint persons_dvc_fk1 on persons 456.610 ms 2329 0.196 ms
RI_ConstraintTrigger_a_3296957 for constraint phone_pers_cred_fk1 on persons 37.107 ms 2329 0.016 ms
RI_ConstraintTrigger_a_3296992 for constraint pr_personid_fk1 on persons 42.376 ms 2329 0.018 ms
RI_ConstraintTrigger_a_3297102 for constraint ps_person_id_fk on persons 39.637 ms 2329 0.017 ms
RI_ConstraintTrigger_a_3297107 for constraint ps_person_msp_id_fk on persons 33.606 ms 2329 0.014 ms
RI_ConstraintTrigger_a_3297112 for constraint ps_person_msp_person_id_fk on persons 31.723 ms 2329 0.014 ms
RI_ConstraintTrigger_a_3297117 for constraint ps_sup_id_fk on persons 139.988 ms 2329 0.060 ms
RI_ConstraintTrigger_a_3297232 for constraint registration_trial_person_id_fk on persons 129.516 ms 2329 0.056 ms
RI_ConstraintTrigger_a_3297337 for constraint scen_favs_fk2 on persons 35.288 ms 2329 0.015 ms
RI_ConstraintTrigger_a_3297342 for constraint scen_init_pers_fk on persons 34.778 ms 2329 0.015 ms
RI_ConstraintTrigger_a_3297402 for constraint scen_sups_fk2 on persons 52.907 ms 2329 0.023 ms
RI_ConstraintTrigger_a_3297467 for constraint script_step_perms_person_id_fk on persons 56.759 ms 2329 0.024 ms
RI_ConstraintTrigger_a_3297492 for constraint search_filter_person_fk on persons 36.999 ms 2329 0.016 ms
RI_ConstraintTrigger_a_3297502 for constraint search_filter_usage_person_fk on persons 40.191 ms 2329 0.017 ms
RI_ConstraintTrigger_a_3297662 for constraint sub_manager_person_id_fk on persons 36.477 ms 2329 0.016 ms
RI_ConstraintTrigger_a_3297782 for constraint tmp_rpmt_fk1 on persons 35.752 ms 2329 0.015 ms
RI_ConstraintTrigger_a_3297787 for constraint tmp_rpmt_fk3 on persons 34.517 ms 2329 0.015 ms
RI_ConstraintTrigger_a_3297852 for constraint web_pers_cred_fk1 on persons 61.054 ms 2329 0.026 ms
persons_rev_tr on persons 390.022 ms 2329 0.167 ms
RI_ConstraintTrigger_a_3294722 for constraint apple_push_dvc_dtl_fk1 on dvc 152.025 ms 6642 0.023 ms
RI_ConstraintTrigger_a_3295057 for constraint dvc_bes_dev_dtl_fk1 on dvc 89.426 ms 6642 0.013 ms
RI_ConstraintTrigger_a_3295062 for constraint dvc_dvc_tfs_fk1 on dvc 148.143 ms 6642 0.022 ms
RI_ConstraintTrigger_a_3295067 for constraint dvc_email_dev_dtl_fk1 on dvc 362.179 ms 6642 0.055 ms
RI_ConstraintTrigger_a_3295072 for constraint dvc_gen_dev_dtl_fk1 on dvc 104.738 ms 6642 0.016 ms
RI_ConstraintTrigger_a_3295077 for constraint dvc_im_dvc_dtl_fk on dvc 86.405 ms 6642 0.013 ms
RI_ConstraintTrigger_a_3295097 for constraint dvc_num_page_dtl_fk1 on dvc 88.591 ms 6642 0.013 ms
RI_ConstraintTrigger_a_3295102 for constraint dvc_txt_page_dtl_fk1 on dvc 101.373 ms 6642 0.015 ms
RI_ConstraintTrigger_a_3295107 for constraint dvc_txt_phone_dtl_fk1 on dvc 298.440 ms 6642 0.045 ms
RI_ConstraintTrigger_a_3295112 for constraint dvc_virt_dev_dtl_fk1 on dvc 125.336 ms 6642 0.019 ms
RI_ConstraintTrigger_a_3295117 for constraint dvc_voc_dev_dtl_fk1 on dvc 352.567 ms 6642 0.053 ms
RI_ConstraintTrigger_a_3295487 for constraint fax_dvc_dtl_fk1 on dvc 100.226 ms 6642 0.015 ms
RI_ConstraintTrigger_a_3296127 for constraint gcm_push_dvc_dtl_fk1 on dvc 87.492 ms 6642 0.013 ms
RI_ConstraintTrigger_a_3296677 for constraint oncall_reminders_configured_devices_device_id_fk on dvc 111.555 ms 6642 0.017 ms
RI_ConstraintTrigger_a_3297842 for constraint voice_ivr_dvc_fk on dvc 89.609 ms 6642 0.013 ms
dvc_rev_tr on dvc 1,586.111 ms 6642 0.239 ms
voc_dvc_dtl_rev_tr on voc_dvc_dtl 568.584 ms 3321 0.171 ms
email_dvc_dtl_rev_tr on email_dvc_dtl 602.759 ms 2214 0.272 ms
txt_phone_dvc_dtl_rev_tr on txt_phone_dvc_dtl 408.820 ms 1107 0.369 ms