explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D8O1

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.053 ↓ 0.0 0 1

Update on platform_fee_calculation_temp (cost=0.55..2.81 rows=1 width=2,523) (actual time=0.053..0.053 rows=0 loops=1)

2. 0.051 0.051 ↓ 0.0 0 1

Index Scan using platform_fee_calculation_temp_revenue_date_str_hub_server_g_idx on platform_fee_calculation_temp (cost=0.55..2.81 rows=1 width=2,523) (actual time=0.051..0.051 rows=0 loops=1)

  • Index Cond: (((revenue_date_str)::text = '2020-01-01'::text) AND ((hub)::text = 'Malta'::text) AND ((server)::text = 'DENMARK'::text) AND (ggr_group = '1128'::numeric) AND ((serial_number)::text = '111053531'::text) AND (platform_id = '1105'::numeric) AND (brand_id = '3531'::numeric))
Planning time : 0.442 ms
Execution time : 0.186 ms