explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Elmd

Settings
# exclusive inclusive rows x rows loops node
1. 1.513 57,435.079 ↓ 47.0 47 1

Nested Loop (cost=24.19..18,225,057.59 rows=1 width=78) (actual time=105.132..57,435.079 rows=47 loops=1)

2. 0.307 0.365 ↓ 47.0 47 1

Bitmap Heap Scan on matched_lm22 m (cost=23.76..2,135.45 rows=1 width=49) (actual time=0.133..0.365 rows=47 loops=1)

  • Recheck Cond: (cusip = '3140Q9HT3'::text)
  • Filter: (loanseqnum = '5984851654'::text)
  • Rows Removed by Filter: 828
  • Heap Blocks: exact=33
3. 0.058 0.058 ↑ 1.1 875 1

Bitmap Index Scan on matched_lm22_cusip_idx (cost=0.00..23.76 rows=979 width=0) (actual time=0.058..0.058 rows=875 loops=1)

  • Index Cond: (cusip = '3140Q9HT3'::text)
4. 0.611 57,433.201 ↑ 51.0 1 47

Append (cost=0.42..18,222,921.61 rows=51 width=21) (actual time=523.843..1,221.983 rows=1 loops=47)

5. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ak_attom_id_transaction_id_idx on recorder_ak r (cost=0.42..40,425.14 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
6. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_al_attom_id_transaction_id_idx on recorder_al r_1 (cost=0.56..237,766.59 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
7. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ar_attom_id_transaction_id_idx on recorder_ar r_2 (cost=0.43..185,676.01 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
8. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_az_attom_id_transaction_id_idx on recorder_az r_3 (cost=0.56..885,348.84 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
9. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ca_attom_id_transaction_id_idx on recorder_ca r_4 (cost=0.57..4,202,342.10 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
10. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_co_attom_id_transaction_id_idx on recorder_co r_5 (cost=0.56..546,526.40 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
11. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ct_attom_id_transaction_id_idx on recorder_ct r_6 (cost=0.56..260,576.20 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
12. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_de_attom_id_transaction_id_idx on recorder_de r_7 (cost=0.43..52,585.99 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
13. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_fl_attom_id_transaction_id_idx on recorder_fl r_8 (cost=0.56..1,989,661.81 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
14. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ga_attom_id_transaction_id_idx on recorder_ga r_9 (cost=0.56..399,042.66 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
15. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_hi_attom_id_transaction_id_idx on recorder_hi r_10 (cost=0.43..102,554.33 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
16. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ia_attom_id_transaction_id_idx on recorder_ia r_11 (cost=0.43..120,493.07 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
17. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_id_attom_id_transaction_id_idx on recorder_id r_12 (cost=0.43..80,754.21 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
18. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_il_attom_id_transaction_id_idx on recorder_il r_13 (cost=0.56..561,929.54 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
19. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_in_attom_id_transaction_id_idx on recorder_in r_14 (cost=0.56..205,651.83 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
20. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ks_attom_id_transaction_id_idx on recorder_ks r_15 (cost=0.43..70,567.14 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
21. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ky_attom_id_transaction_id_idx on recorder_ky r_16 (cost=0.43..110,153.59 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
22. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_la_attom_id_transaction_id_idx on recorder_la r_17 (cost=0.43..99,331.09 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
23. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ma_attom_id_transaction_id_idx on recorder_ma r_18 (cost=0.56..353,759.74 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
24. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_md_attom_id_transaction_id_idx on recorder_md r_19 (cost=0.56..276,566.78 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
25. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_me_attom_id_transaction_id_idx on recorder_me r_20 (cost=0.43..47,294.95 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
26. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_mi_attom_id_transaction_id_idx on recorder_mi r_21 (cost=0.56..374,045.71 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
27. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_mn_attom_id_transaction_id_idx on recorder_mn r_22 (cost=0.56..162,820.82 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
28. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_mo_attom_id_transaction_id_idx on recorder_mo r_23 (cost=0.56..237,282.05 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
29. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ms_attom_id_transaction_id_idx on recorder_ms r_24 (cost=0.43..92,148.36 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
30. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_mt_attom_id_transaction_id_idx on recorder_mt r_25 (cost=0.43..38,840.10 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
31. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_nc_attom_id_transaction_id_idx on recorder_nc r_26 (cost=0.56..547,093.79 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
32. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_nd_attom_id_transaction_id_idx on recorder_nd r_27 (cost=0.42..40,004.91 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
33. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ne_attom_id_transaction_id_idx on recorder_ne r_28 (cost=0.43..107,515.68 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
34. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_nh_attom_id_transaction_id_idx on recorder_nh r_29 (cost=0.42..58,919.66 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
35. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_nj_attom_id_transaction_id_idx on recorder_nj r_30 (cost=0.56..473,056.16 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
36. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_nm_attom_id_transaction_id_idx on recorder_nm r_31 (cost=0.43..122,519.09 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
37. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_nv_attom_id_transaction_id_idx on recorder_nv r_32 (cost=0.56..318,603.45 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
38. 57,432.590 57,432.590 ↑ 1.0 1 47

Index Scan using recorder_ny_attom_id_transaction_id_idx on recorder_ny r_33 (cost=0.56..1,067,206.18 rows=1 width=21) (actual time=523.831..1,221.970 rows=1 loops=47)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
39. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_oh_attom_id_transaction_id_idx on recorder_oh r_34 (cost=0.56..494,830.38 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
40. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ok_attom_id_transaction_id_idx on recorder_ok r_35 (cost=0.56..160,864.12 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
41. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_or_attom_id_transaction_id_idx on recorder_or r_36 (cost=0.56..211,164.97 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
42. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_pa_attom_id_transaction_id_idx on recorder_pa r_37 (cost=0.56..400,712.29 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
43. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ri_attom_id_transaction_id_idx on recorder_ri r_38 (cost=0.43..46,126.19 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
44. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_sc_attom_id_transaction_id_idx on recorder_sc r_39 (cost=0.56..180,711.59 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
45. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_sd_attom_id_transaction_id_idx on recorder_sd r_40 (cost=0.42..18,780.51 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
46. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_tn_attom_id_transaction_id_idx on recorder_tn r_41 (cost=0.56..329,216.25 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
47. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_tx_attom_id_transaction_id_idx on recorder_tx r_42 (cost=0.56..791,826.87 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
48. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_ut_attom_id_transaction_id_idx on recorder_ut r_43 (cost=0.56..175,620.61 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
49. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_va_attom_id_transaction_id_idx on recorder_va r_44 (cost=0.56..224,826.10 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
50. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_vt_attom_id_transaction_id_idx on recorder_vt r_45 (cost=0.42..11,090.15 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
51. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_wa_attom_id_transaction_id_idx on recorder_wa r_46 (cost=0.56..393,795.02 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
52. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_wi_attom_id_transaction_id_idx on recorder_wi r_47 (cost=0.56..226,922.25 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
53. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_wv_attom_id_transaction_id_idx on recorder_wv r_48 (cost=0.43..37,595.44 rows=1 width=22) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
54. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_wy_attom_id_transaction_id_idx on recorder_wy r_49 (cost=0.42..19,296.90 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
55. 0.000 0.000 ↓ 0.0 0

Index Scan using recorder_default_attom_id_transaction_id_idx on recorder_default r_50 (cost=0.42..30,477.75 rows=1 width=21) (never executed)

  • Index Cond: (transaction_id = m.transaction_id)
  • Filter: (((attom_id = m.attom_id) OR (m.attom_id IS NULL)) AND (m.state = state))
Planning time : 6.754 ms
Execution time : 57,435.494 ms