explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TUcY

Settings
# exclusive inclusive rows x rows loops node
1. 0.084 0.134 ↓ 0.0 0 1

Delete on client (cost=0.45..3.49 rows=1 width=34) (actual time=0.134..0.134 rows=0 loops=1)

  • Buffers: shared hit=7
2. 0.004 0.050 ↑ 1.0 1 1

Nested Loop (cost=0.45..3.49 rows=1 width=34) (actual time=0.048..0.050 rows=1 loops=1)

  • Buffers: shared hit=5
3. 0.003 0.024 ↑ 1.0 1 1

HashAggregate (cost=0.03..0.04 rows=1 width=32) (actual time=0.024..0.024 rows=1 loops=1)

  • Group Key: "ANY_subquery".cid
  • Buffers: shared hit=1
4. 0.004 0.021 ↑ 1.0 1 1

Subquery Scan on ANY_subquery (cost=0.00..0.02 rows=1 width=32) (actual time=0.020..0.021 rows=1 loops=1)

  • Buffers: shared hit=1
5. 0.002 0.017 ↑ 1.0 1 1

Limit (cost=0.00..0.01 rows=1 width=4) (actual time=0.017..0.017 rows=1 loops=1)

  • Buffers: shared hit=1
6. 0.015 0.015 ↑ 1,313,582.0 1 1

Seq Scan on tmp_client_ids (cost=0.00..18,948.82 rows=1,313,582 width=4) (actual time=0.015..0.015 rows=1 loops=1)

  • Buffers: shared hit=1
7. 0.022 0.022 ↑ 1.0 1 1

Index Scan using clientpk on client (cost=0.43..3.45 rows=1 width=10) (actual time=0.021..0.022 rows=1 loops=1)

  • Index Cond: (id = "ANY_subquery".cid)
  • Buffers: shared hit=4
Planning time : 0.326 ms
Execution time : 1,516.694 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint client_external_service_client_id_fkey 0.154 ms 1 0.154 ms
for constraint client_external_client_lookup_client_id_fkey 0.096 ms 1 0.096 ms
for constraint vehicle_base_rate_client_id_fkey 0.101 ms 1 0.101 ms
for constraint quote_billing_client_id_fkey 0.088 ms 1 0.088 ms
for constraint order_group_client_id_fkey 0.080 ms 1 0.080 ms
for constraint customer_exclusions_client_id_fkey 0.110 ms 1 0.110 ms
for constraint client_id_fk 0.092 ms 1 0.092 ms
for constraint adp_customer_client_id_fkey 0.246 ms 1 0.246 ms
for constraint adp_customer_parent_id_fkey 0.097 ms 1 0.097 ms
for constraint adpcust_dlr_fk 0.995 ms 1 0.995 ms
for constraint adporder_dlr_fk 0.372 ms 1 0.372 ms
for constraint agent_drop_point_id_fkey 0.103 ms 1 0.103 ms
for constraint cdmcustfktwo 0.696 ms 1 0.696 ms
for constraint cdmdlrfktwo 0.161 ms 1 0.161 ms
for constraint client_idfk 1.298 ms 1 1.298 ms
for constraint client_idfk 5.096 ms 1 5.096 ms
for constraint client_idfk 0.108 ms 1 0.108 ms
for constraint client_parent_billing_client_id_fkey 212.492 ms 1 212.492 ms
for constraint clientwarehousefk 205.449 ms 1 205.449 ms
for constraint clobmobifk 0.392 ms 1 0.392 ms
for constraint clsmsifk 0.119 ms 1 0.119 ms
for constraint custcodecustfk 0.105 ms 1 0.105 ms
for constraint customer_list_dealer_id_fkey 0.133 ms 1 0.133 ms
for constraint customer_list_source_dealer_id_fkey 0.097 ms 1 0.097 ms
for constraint ddp_dlr_fk 0.655 ms 1 0.655 ms
for constraint dealer_performance_dealer_id_fkey 0.367 ms 1 0.367 ms
for constraint delivery_order_billing_client_id_fkey 448.559 ms 1 448.559 ms
for constraint dispdealerfk 0.170 ms 1 0.170 ms
for constraint dlrhistdlrfk 0.108 ms 1 0.108 ms
for constraint dlrhistwhfk 0.087 ms 1 0.087 ms
for constraint doorderedbyfk 0.385 ms 1 0.385 ms
for constraint driver_dealer_change_new_dealer_id_fkey 0.112 ms 1 0.112 ms
for constraint driver_dealer_change_old_dealer_id_fkey 0.095 ms 1 0.095 ms
for constraint driver_position_client_id_fkey 0.357 ms 1 0.357 ms
for constraint driverdealerfk 0.255 ms 1 0.255 ms
for constraint fk_client_from_adp_feed 0.097 ms 1 0.097 ms
for constraint fmpbilltoclientfk 0.119 ms 1 0.119 ms
for constraint fmplocwhfk 0.105 ms 1 0.105 ms
for constraint mergeclientfk 171.550 ms 1 171.550 ms
for constraint orderdestfk 0.460 ms 1 0.460 ms
for constraint ordersourcefk 0.174 ms 1 0.174 ms
for constraint origdestfk 197.925 ms 1 197.925 ms
for constraint origsourcefk 240.882 ms 1 240.882 ms
for constraint recurring_routes_alternate_endpoint_id_fkey 0.147 ms 1 0.147 ms
for constraint recurring_routes_alternate_startpoint_id_fkey 0.064 ms 1 0.064 ms
for constraint scheduled_run_warehouse_id_fkey 0.080 ms 1 0.080 ms
for constraint scheduled_run_warehouse_id_fkey1 0.062 ms 1 0.062 ms
for constraint scheduled_run_warehouse_id_fkey2 0.061 ms 1 0.061 ms
for constraint shiptoclientfk 0.069 ms 1 0.069 ms
for constraint signerclientfk 0.082 ms 1 0.082 ms
for constraint sr_client_map_client_id_fkey 0.081 ms 1 0.081 ms
for constraint transfer_history_from_client_id_fkey 10.074 ms 1 10.074 ms
for constraint transfer_history_to_client_id_fkey 10.761 ms 1 10.761 ms
for constraint vehicle_dispatch_map_dealer_id_fkey 0.130 ms 1 0.130 ms
for constraint vehicle_location_fk 0.147 ms 1 0.147 ms
for constraint vendor_client_id_fkey 0.079 ms 1 0.079 ms
for constraint warehousefk 0.077 ms 1 0.077 ms
for constraint zone_dispatch_fk 0.093 ms 1 0.093 ms
for constraint client_idfk 0.079 ms 1 0.079 ms
for constraint client_idfk 0.075 ms 1 0.075 ms
for constraint client_idfk 0.067 ms 1 0.067 ms
for constraint client_idfk 0.073 ms 1 0.073 ms
for constraint transfer_location_setting_local_client_id_fkey 0.069 ms 1 0.069 ms
for constraint sms_text_log_location_id_fkey 0.072 ms 1 0.072 ms
for constraint client_email_template_map_client_id_fkey 0.080 ms 1 0.080 ms
for constraint fk_pickup_source_id_map_to_source 0.081 ms 1 0.081 ms
for constraint driver_default_start_client_id_fkey 0.169 ms 1 0.169 ms
for constraint driver_default_end_client_id_fkey 0.122 ms 1 0.122 ms
for constraint customer_list_default_start_client_id_fkey 0.076 ms 1 0.076 ms
for constraint customer_list_default_end_client_id_fkey 0.067 ms 1 0.067 ms
for constraint scorev2_route_performance_by_dealer_summary_dealer_id_fkey 0.129 ms 1 0.129 ms
for constraint scorev2_driver_dealer_performance_dealer_id_fkey 1.390 ms 1 1.390 ms
for constraint scorev2_driver_dealer_performance_summary_dealer_id_fkey 0.126 ms 1 0.126 ms
for constraint driver_home_client_id_fkey 0.124 ms 1 0.124 ms
for constraint client_notification_recipient_client_id_fkey 0.267 ms 1 0.267 ms
for constraint location_id_fk 0.073 ms 1 0.073 ms