explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KjNN

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 4.078 ↓ 0.0 0 1

Sort (cost=8,997.25..9,009.08 rows=4,733 width=1,986) (actual time=4.078..4.078 rows=0 loops=1)

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

Unique (cost=4,536.18..4,630.84 rows=4,733 width=1,986) (actual time=4.065..4.066 rows=0 loops=1)

3. 0.336 4.065 ↓ 0.0 0 1

Sort (cost=4,536.18..4,548.01 rows=4,733 width=1,986) (actual time=4.065..4.065 rows=0 loops=1)

  • Sort 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
  • Sort Method: quicksort Memory: 25kB
4. 0.000 3.729 ↓ 0.0 0 1

Append (cost=0.56..169.76 rows=4,733 width=1,986) (actual time=3.729..3.729 rows=0 loops=1)

5. 3.718 3.718 ↓ 0.0 0 1

Index Scan using audit_trail_pk_ux on audit_trail (cost=0.56..8.62 rows=4,709 width=1,191) (actual time=3.718..3.718 rows=0 loops=1)

  • Index Cond: (((key_value)::text ~>=~ '20281,'::text) AND ((key_value)::text ~<~ '20281-'::text))
  • 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[])))
6. 0.011 0.011 ↓ 0.0 0 1

Index Scan using audit_trail_pk_ux on audit_trail audit_trail_1 (cost=0.56..113.81 rows=24 width=1,191) (actual time=0.011..0.011 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[]))
Planning time : 11.770 ms
Execution time : 4.389 ms