explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vftI

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

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

  • Update on cgr_transactions_before_2020_06_01
  • Update on cgr_transactions_before_2020_06_08
  • Update on cgr_transactions_before_2020_06_15
  • Update on cgr_transactions_before_2020_06_22
  • Update on cgr_transactions_before_2020_06_29
  • Update on cgr_transactions_before_2020_07_06
  • Update on cgr_transactions_before_2020_07_13
  • Update on cgr_transactions_before_2020_07_20
  • Update on cgr_transactions_before_2020_07_27
  • Update on cgr_transactions_before_2020_08_03
  • Update on cgr_transactions_before_2020_08_10
  • Update on cgr_transactions_before_2020_08_17
  • Update on cgr_transactions_before_2020_08_24
  • Update on cgr_transactions_before_2020_08_31
  • Update on cgr_transactions_before_2020_09_07
  • Update on cgr_transactions_before_2020_09_14
  • Update on 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 cgr_transactions_before_2020_06_01 (cost=0.56..8.59 rows=1 width=1,011) (actual rows= loops=)

  • Index Cond: (((appid)::text = 'CGTEST'::text) AND ((transactionid)::text = 'TEST_TRANS_01'::text) AND ((user_acc_domain)::text = 'GSM'::text))
3. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (((appid)::text = 'CGTEST'::text) AND ((transactionid)::text = 'TEST_TRANS_01'::text) AND ((user_acc_domain)::text = 'GSM'::text))
4. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (((appid)::text = 'CGTEST'::text) AND ((transactionid)::text = 'TEST_TRANS_01'::text) AND ((user_acc_domain)::text = 'GSM'::text))
5. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (((appid)::text = 'CGTEST'::text) AND ((transactionid)::text = 'TEST_TRANS_01'::text) AND ((user_acc_domain)::text = 'GSM'::text))
6. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (((appid)::text = 'CGTEST'::text) AND ((transactionid)::text = 'TEST_TRANS_01'::text) AND ((user_acc_domain)::text = 'GSM'::text))
7. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (((appid)::text = 'CGTEST'::text) AND ((transactionid)::text = 'TEST_TRANS_01'::text) AND ((user_acc_domain)::text = 'GSM'::text))
8. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (((appid)::text = 'CGTEST'::text) AND ((transactionid)::text = 'TEST_TRANS_01'::text) AND ((user_acc_domain)::text = 'GSM'::text))
9. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (((appid)::text = 'CGTEST'::text) AND ((transactionid)::text = 'TEST_TRANS_01'::text) AND ((user_acc_domain)::text = 'GSM'::text))
10. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (((appid)::text = 'CGTEST'::text) AND ((transactionid)::text = 'TEST_TRANS_01'::text) AND ((user_acc_domain)::text = 'GSM'::text))
11. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (((appid)::text = 'CGTEST'::text) AND ((transactionid)::text = 'TEST_TRANS_01'::text) AND ((user_acc_domain)::text = 'GSM'::text))
12. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (((appid)::text = 'CGTEST'::text) AND ((transactionid)::text = 'TEST_TRANS_01'::text) AND ((user_acc_domain)::text = 'GSM'::text))
13. 0.000 0.000 ↓ 0.0

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

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

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

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

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

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

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

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

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

  • Index Cond: (((appid)::text = 'CGTEST'::text) AND ((transactionid)::text = 'TEST_TRANS_01'::text) AND ((user_acc_domain)::text = 'GSM'::text))
18. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (((appid)::text = 'CGTEST'::text) AND ((transactionid)::text = 'TEST_TRANS_01'::text) AND ((user_acc_domain)::text = 'GSM'::text))