explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mm9g

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on cgdom.cgr_transactions (cost=0.56..145.15 rows=17 width=1,069) (actual rows= loops=)

  • Update on cgdom.cgr_transactions_before_2020_06_01
  • Update on cgdom.cgr_transactions_before_2020_06_08
  • Update on cgdom.cgr_transactions_before_2020_06_15
  • Update on cgdom.cgr_transactions_before_2020_06_22
  • Update on cgdom.cgr_transactions_before_2020_06_29
  • Update on cgdom.cgr_transactions_before_2020_07_06
  • Update on cgdom.cgr_transactions_before_2020_07_13
  • Update on cgdom.cgr_transactions_before_2020_07_20
  • Update on cgdom.cgr_transactions_before_2020_07_27
  • Update on cgdom.cgr_transactions_before_2020_08_03
  • Update on cgdom.cgr_transactions_before_2020_08_10
  • Update on cgdom.cgr_transactions_before_2020_08_17
  • Update on cgdom.cgr_transactions_before_2020_08_24
  • Update on cgdom.cgr_transactions_before_2020_08_31
  • Update on cgdom.cgr_transactions_before_2020_09_07
  • Update on cgdom.cgr_transactions_before_2020_09_14
  • Update on cgdom.cgr_transactions_before_2020_09_21
2. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_06_01_pk on cgdom.cgr_transactions_before_2020_06_01 (cost=0.56..8.59 rows=1 width=1,011) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_06_01.appid, cgr_transactions_before_2020_06_01.transactionid, cgr_transactions_before_2020_06_01.user_acc_domai
  • Index Cond: (((cgr_transactions_before_2020_06_01.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_06_01.transactionid)::text = 'TES
3. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_06_08_pk on cgdom.cgr_transactions_before_2020_06_08 (cost=0.56..8.58 rows=1 width=1,011) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_06_08.appid, cgr_transactions_before_2020_06_08.transactionid, cgr_transactions_before_2020_06_08.user_acc_domai
  • Index Cond: (((cgr_transactions_before_2020_06_08.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_06_08.transactionid)::text = 'TES
4. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_06_15_pk on cgdom.cgr_transactions_before_2020_06_15 (cost=0.56..8.59 rows=1 width=1,008) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_06_15.appid, cgr_transactions_before_2020_06_15.transactionid, cgr_transactions_before_2020_06_15.user_acc_domai
  • Index Cond: (((cgr_transactions_before_2020_06_15.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_06_15.transactionid)::text = 'TES
5. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_06_22_pk on cgdom.cgr_transactions_before_2020_06_22 (cost=0.56..8.59 rows=1 width=1,009) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_06_22.appid, cgr_transactions_before_2020_06_22.transactionid, cgr_transactions_before_2020_06_22.user_acc_domai
  • Index Cond: (((cgr_transactions_before_2020_06_22.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_06_22.transactionid)::text = 'TES
6. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_06_29_pk on cgdom.cgr_transactions_before_2020_06_29 (cost=0.56..8.59 rows=1 width=1,008) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_06_29.appid, cgr_transactions_before_2020_06_29.transactionid, cgr_transactions_before_2020_06_29.user_acc_domai
  • Index Cond: (((cgr_transactions_before_2020_06_29.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_06_29.transactionid)::text = 'TES
7. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_07_06_pk on cgdom.cgr_transactions_before_2020_07_06 (cost=0.56..8.59 rows=1 width=1,006) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_07_06.appid, cgr_transactions_before_2020_07_06.transactionid, cgr_transactions_before_2020_07_06.user_acc_domai
  • Index Cond: (((cgr_transactions_before_2020_07_06.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_07_06.transactionid)::text = 'TES
8. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_07_13_pk on cgdom.cgr_transactions_before_2020_07_13 (cost=0.56..8.58 rows=1 width=1,005) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_07_13.appid, cgr_transactions_before_2020_07_13.transactionid, cgr_transactions_before_2020_07_13.user_acc_domai
  • Index Cond: (((cgr_transactions_before_2020_07_13.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_07_13.transactionid)::text = 'TES
9. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_07_20_pk on cgdom.cgr_transactions_before_2020_07_20 (cost=0.56..8.58 rows=1 width=1,000) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_07_20.appid, cgr_transactions_before_2020_07_20.transactionid, cgr_transactions_before_2020_07_20.user_acc_domai
  • Index Cond: (((cgr_transactions_before_2020_07_20.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_07_20.transactionid)::text = 'TES
10. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_07_27_pk on cgdom.cgr_transactions_before_2020_07_27 (cost=0.56..8.59 rows=1 width=1,000) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_07_27.appid, cgr_transactions_before_2020_07_27.transactionid, cgr_transactions_before_2020_07_27.user_acc_domai
  • Index Cond: (((cgr_transactions_before_2020_07_27.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_07_27.transactionid)::text = 'TES
11. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_08_03_pk on cgdom.cgr_transactions_before_2020_08_03 (cost=0.57..8.59 rows=1 width=1,000) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_08_03.appid, cgr_transactions_before_2020_08_03.transactionid, cgr_transactions_before_2020_08_03.user_acc_domai
  • Index Cond: (((cgr_transactions_before_2020_08_03.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_08_03.transactionid)::text = 'TES
12. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_08_10_pk on cgdom.cgr_transactions_before_2020_08_10 (cost=0.57..8.59 rows=1 width=996) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_08_10.appid, cgr_transactions_before_2020_08_10.transactionid, cgr_transactions_before_2020_08_10.user_acc_domai
  • Index Cond: (((cgr_transactions_before_2020_08_10.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_08_10.transactionid)::text = 'TES
13. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_08_17_trans_id on cgdom.cgr_transactions_before_2020_08_17 (cost=0.57..8.59 rows=1 width=1,000) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_08_17.appid, cgr_transactions_before_2020_08_17.transactionid, cgr_transactions_before_2020_08_17.user_acc_domai
  • Index Cond: ((cgr_transactions_before_2020_08_17.transactionid)::text = 'TEST_TRANS_01'::text)
  • Filter: (((cgr_transactions_before_2020_08_17.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_08_17.user_acc_domain)::text = 'GSM':
14. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_08_24_trans_id on cgdom.cgr_transactions_before_2020_08_24 (cost=0.57..8.59 rows=1 width=1,000) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_08_24.appid, cgr_transactions_before_2020_08_24.transactionid, cgr_transactions_before_2020_08_24.user_acc_domai
  • Index Cond: ((cgr_transactions_before_2020_08_24.transactionid)::text = 'TEST_TRANS_01'::text)
  • Filter: (((cgr_transactions_before_2020_08_24.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_08_24.user_acc_domain)::text = 'GSM':
15. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_08_31_trans_id on cgdom.cgr_transactions_before_2020_08_31 (cost=0.57..8.59 rows=1 width=1,000) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_08_31.appid, cgr_transactions_before_2020_08_31.transactionid, cgr_transactions_before_2020_08_31.user_acc_domai
  • Index Cond: ((cgr_transactions_before_2020_08_31.transactionid)::text = 'TEST_TRANS_01'::text)
  • Filter: (((cgr_transactions_before_2020_08_31.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_08_31.user_acc_domain)::text = 'GSM':
16. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_09_07_trans_id on cgdom.cgr_transactions_before_2020_09_07 (cost=0.57..8.59 rows=1 width=999) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_09_07.appid, cgr_transactions_before_2020_09_07.transactionid, cgr_transactions_before_2020_09_07.user_acc_domai
  • Index Cond: ((cgr_transactions_before_2020_09_07.transactionid)::text = 'TEST_TRANS_01'::text)
  • Filter: (((cgr_transactions_before_2020_09_07.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_09_07.user_acc_domain)::text = 'GSM':
17. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_09_14_pk on cgdom.cgr_transactions_before_2020_09_14 (cost=0.14..8.16 rows=1 width=1,556) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_09_14.appid, cgr_transactions_before_2020_09_14.transactionid, cgr_transactions_before_2020_09_14.user_acc_domai
  • Index Cond: (((cgr_transactions_before_2020_09_14.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_09_14.transactionid)::text = 'TES
18. 0.000 0.000 ↓ 0.0

Index Scan using indx_cgr_transactions_before_2020_09_21_pk on cgdom.cgr_transactions_before_2020_09_21 (cost=0.14..8.16 rows=1 width=1,556) (actual rows= loops=)

  • Output: cgr_transactions_before_2020_09_21.appid, cgr_transactions_before_2020_09_21.transactionid, cgr_transactions_before_2020_09_21.user_acc_domai
  • Index Cond: (((cgr_transactions_before_2020_09_21.appid)::text = 'CGTEST'::text) AND ((cgr_transactions_before_2020_09_21.transactionid)::text = 'TES