explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IcL8

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 7.451 ↓ 0.0 0 1

Sort (cost=71.27..71.30 rows=12 width=1,986) (actual time=7.451..7.451 rows=0 loops=1)

  • Sort Key: audit_trail.update_date
  • Sort Method: quicksort Memory: 25kB
2. 0.003 7.423 ↓ 0.0 0 1

HashAggregate (cost=70.94..71.06 rows=12 width=1,986) (actual time=7.423..7.423 rows=0 loops=1)

  • Group Key: audit_trail.table_name, audit_trail.key_value, audit_trail.update_date, audit_trail.update_user, audit_trail.string_value_1, audit_trail.string_value_2, audit_trail.string_value_3
3. 0.017 7.420 ↓ 0.0 0 1

Append (cost=0.00..70.73 rows=12 width=1,986) (actual time=7.420..7.420 rows=0 loops=1)

4. 0.003 6.646 ↓ 0.0 0 1

Append (cost=0.00..52.89 rows=6 width=1,156) (actual time=6.646..6.646 rows=0 loops=1)

5. 0.892 0.892 ↓ 0.0 0 1

Seq Scan on audit_trail (cost=0.00..4.68 rows=1 width=1,204) (actual time=0.892..0.892 rows=0 loops=1)

  • Filter: (((key_value)::text ~~ '20281,%'::text) AND ((table_name)::text = ANY ('{bond,instrument_link,instrument_desc,instrument_xref,instrument_column_xref,instrument_in_market,instr_char_attr,instr_float_attr,instr_int_attr,swap,swap_leg,swap_odd_cash_flow,base_option,equity,fra,currency_exchange,future_contract,put_call_schedule,dividend,barrier_option,instr_cash_flow,tic_gen..instr_statistic,instrument}'::text[])))
  • Rows Removed by Filter: 65
6. 0.743 0.743 ↓ 0.0 0 1

Seq Scan on audit_trail_201909 (cost=0.00..1.08 rows=1 width=1,111) (actual time=0.743..0.743 rows=0 loops=1)

  • Filter: (((key_value)::text ~~ '20281,%'::text) AND ((table_name)::text = ANY ('{bond,instrument_link,instrument_desc,instrument_xref,instrument_column_xref,instrument_in_market,instr_char_attr,instr_float_attr,instr_int_attr,swap,swap_leg,swap_odd_cash_flow,base_option,equity,fra,currency_exchange,future_contract,put_call_schedule,dividend,barrier_option,instr_cash_flow,tic_gen..instr_statistic,instrument}'::text[])))
  • Rows Removed by Filter: 2
7. 3.161 3.161 ↓ 0.0 0 1

Seq Scan on audit_trail_201910 (cost=0.00..43.56 rows=1 width=1,197) (actual time=3.161..3.161 rows=0 loops=1)

  • Filter: (((key_value)::text ~~ '20281,%'::text) AND ((table_name)::text = ANY ('{bond,instrument_link,instrument_desc,instrument_xref,instrument_column_xref,instrument_in_market,instr_char_attr,instr_float_attr,instr_int_attr,swap,swap_leg,swap_odd_cash_flow,base_option,equity,fra,currency_exchange,future_contract,put_call_schedule,dividend,barrier_option,instr_cash_flow,tic_gen..instr_statistic,instrument}'::text[])))
  • Rows Removed by Filter: 644
8. 0.602 0.602 ↓ 0.0 0 1

Seq Scan on audit_trail_201911 (cost=0.00..1.29 rows=1 width=1,175) (actual time=0.602..0.602 rows=0 loops=1)

  • Filter: (((key_value)::text ~~ '20281,%'::text) AND ((table_name)::text = ANY ('{bond,instrument_link,instrument_desc,instrument_xref,instrument_column_xref,instrument_in_market,instr_char_attr,instr_float_attr,instr_int_attr,swap,swap_leg,swap_odd_cash_flow,base_option,equity,fra,currency_exchange,future_contract,put_call_schedule,dividend,barrier_option,instr_cash_flow,tic_gen..instr_statistic,instrument}'::text[])))
  • Rows Removed by Filter: 7
9. 0.598 0.598 ↓ 0.0 0 1

Seq Scan on audit_trail_201912 (cost=0.00..1.04 rows=1 width=1,122) (actual time=0.598..0.598 rows=0 loops=1)

  • Filter: (((key_value)::text ~~ '20281,%'::text) AND ((table_name)::text = ANY ('{bond,instrument_link,instrument_desc,instrument_xref,instrument_column_xref,instrument_in_market,instr_char_attr,instr_float_attr,instr_int_attr,swap,swap_leg,swap_odd_cash_flow,base_option,equity,fra,currency_exchange,future_contract,put_call_schedule,dividend,barrier_option,instr_cash_flow,tic_gen..instr_statistic,instrument}'::text[])))
  • Rows Removed by Filter: 1
10. 0.647 0.647 ↓ 0.0 0 1

Seq Scan on audit_trail_202006 (cost=0.00..1.21 rows=1 width=1,126) (actual time=0.647..0.647 rows=0 loops=1)

  • Filter: (((key_value)::text ~~ '20281,%'::text) AND ((table_name)::text = ANY ('{bond,instrument_link,instrument_desc,instrument_xref,instrument_column_xref,instrument_in_market,instr_char_attr,instr_float_attr,instr_int_attr,swap,swap_leg,swap_odd_cash_flow,base_option,equity,fra,currency_exchange,future_contract,put_call_schedule,dividend,barrier_option,instr_cash_flow,tic_gen..instr_statistic,instrument}'::text[])))
  • Rows Removed by Filter: 5
11. 0.003 0.757 ↓ 0.0 0 1

Append (cost=0.00..17.65 rows=6 width=1,156) (actual time=0.756..0.757 rows=0 loops=1)

12. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on audit_trail audit_trail_1 (cost=0.00..4.68 rows=1 width=1,204) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (((key_value)::text = '20281'::text) AND ((table_name)::text = ANY ('{bond,instrument_link,instrument_desc,instrument_xref,instrument_column_xref,instrument_in_market,instr_char_attr,instr_float_attr,instr_int_attr,swap,swap_leg,swap_odd_cash_flow,base_option,equity,fra,currency_exchange,future_contract,put_call_schedule,dividend,barrier_option,instr_cash_flow,tic_gen..instr_statistic,instrument}'::text[])))
  • Rows Removed by Filter: 65
13. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on audit_trail_201909 audit_trail_201909_1 (cost=0.00..1.08 rows=1 width=1,111) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (((key_value)::text = '20281'::text) AND ((table_name)::text = ANY ('{bond,instrument_link,instrument_desc,instrument_xref,instrument_column_xref,instrument_in_market,instr_char_attr,instr_float_attr,instr_int_attr,swap,swap_leg,swap_odd_cash_flow,base_option,equity,fra,currency_exchange,future_contract,put_call_schedule,dividend,barrier_option,instr_cash_flow,tic_gen..instr_statistic,instrument}'::text[])))
  • Rows Removed by Filter: 2
14. 0.712 0.712 ↓ 0.0 0 1

Index Scan using audit_trail_201910_pk on audit_trail_201910 audit_trail_201910_1 (cost=0.28..8.32 rows=1 width=1,197) (actual time=0.712..0.712 rows=0 loops=1)

  • Index Cond: ((key_value)::text = '20281'::text)
  • Filter: ((table_name)::text = ANY ('{bond,instrument_link,instrument_desc,instrument_xref,instrument_column_xref,instrument_in_market,instr_char_attr,instr_float_attr,instr_int_attr,swap,swap_leg,swap_odd_cash_flow,base_option,equity,fra,currency_exchange,future_contract,put_call_schedule,dividend,barrier_option,instr_cash_flow,tic_gen..instr_statistic,instrument}'::text[]))
15. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on audit_trail_201911 audit_trail_201911_1 (cost=0.00..1.29 rows=1 width=1,175) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (((key_value)::text = '20281'::text) AND ((table_name)::text = ANY ('{bond,instrument_link,instrument_desc,instrument_xref,instrument_column_xref,instrument_in_market,instr_char_attr,instr_float_attr,instr_int_attr,swap,swap_leg,swap_odd_cash_flow,base_option,equity,fra,currency_exchange,future_contract,put_call_schedule,dividend,barrier_option,instr_cash_flow,tic_gen..instr_statistic,instrument}'::text[])))
  • Rows Removed by Filter: 7
16. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on audit_trail_201912 audit_trail_201912_1 (cost=0.00..1.04 rows=1 width=1,122) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (((key_value)::text = '20281'::text) AND ((table_name)::text = ANY ('{bond,instrument_link,instrument_desc,instrument_xref,instrument_column_xref,instrument_in_market,instr_char_attr,instr_float_attr,instr_int_attr,swap,swap_leg,swap_odd_cash_flow,base_option,equity,fra,currency_exchange,future_contract,put_call_schedule,dividend,barrier_option,instr_cash_flow,tic_gen..instr_statistic,instrument}'::text[])))
  • Rows Removed by Filter: 1
17. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on audit_trail_202006 audit_trail_202006_1 (cost=0.00..1.21 rows=1 width=1,126) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (((key_value)::text = '20281'::text) AND ((table_name)::text = ANY ('{bond,instrument_link,instrument_desc,instrument_xref,instrument_column_xref,instrument_in_market,instr_char_attr,instr_float_attr,instr_int_attr,swap,swap_leg,swap_odd_cash_flow,base_option,equity,fra,currency_exchange,future_contract,put_call_schedule,dividend,barrier_option,instr_cash_flow,tic_gen..instr_statistic,instrument}'::text[])))
  • Rows Removed by Filter: 5
Planning time : 30.447 ms
Execution time : 7.640 ms