explain.depesz.com

PostgreSQL's explain analyze made readable

Result: loi2

Settings
# exclusive inclusive rows x rows loops node
1. 0.162 0.290 ↓ 0.0 0 1

Delete on client (cost=0.70..34.94 rows=10 width=34) (actual time=0.290..0.290 rows=0 loops=1)

  • Buffers: shared hit=58
2. 0.016 0.128 ↑ 1.1 9 1

Nested Loop (cost=0.70..34.94 rows=10 width=34) (actual time=0.053..0.128 rows=9 loops=1)

  • Buffers: shared hit=40
3. 0.015 0.042 ↑ 1.0 10 1

HashAggregate (cost=0.27..0.37 rows=10 width=32) (actual time=0.038..0.042 rows=10 loops=1)

  • Group Key: "ANY_subquery".cid
  • Buffers: shared hit=1
4. 0.008 0.027 ↑ 1.0 10 1

Subquery Scan on ANY_subquery (cost=0.00..0.24 rows=10 width=32) (actual time=0.022..0.027 rows=10 loops=1)

  • Buffers: shared hit=1
5. 0.003 0.019 ↑ 1.0 10 1

Limit (cost=0.00..0.14 rows=10 width=4) (actual time=0.016..0.019 rows=10 loops=1)

  • Buffers: shared hit=1
6. 0.016 0.016 ↑ 131,323.8 10 1

Seq Scan on tmp_client_ids (cost=0.00..18,945.38 rows=1,313,238 width=4) (actual time=0.014..0.016 rows=10 loops=1)

  • Buffers: shared hit=1
7. 0.070 0.070 ↑ 1.0 1 10

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

  • Index Cond: (id = "ANY_subquery".cid)
  • Buffers: shared hit=39
Planning time : 0.390 ms
Execution time : 8,203.578 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint client_external_service_client_id_fkey 0.545 ms 9 0.061 ms
for constraint client_external_client_lookup_client_id_fkey 0.435 ms 9 0.048 ms
for constraint vehicle_base_rate_client_id_fkey 1.502 ms 9 0.167 ms
for constraint quote_billing_client_id_fkey 0.675 ms 9 0.075 ms
for constraint order_group_client_id_fkey 0.343 ms 9 0.038 ms
for constraint customer_exclusions_client_id_fkey 0.541 ms 9 0.060 ms
for constraint client_id_fk 0.473 ms 9 0.053 ms
for constraint adp_customer_client_id_fkey 1.478 ms 9 0.164 ms
for constraint adp_customer_parent_id_fkey 0.528 ms 9 0.059 ms
for constraint adpcust_dlr_fk 1.015 ms 9 0.113 ms
for constraint adporder_dlr_fk 1.144 ms 9 0.127 ms
for constraint agent_drop_point_id_fkey 0.532 ms 9 0.059 ms
for constraint cdmcustfktwo 4.486 ms 9 0.498 ms
for constraint cdmdlrfktwo 0.935 ms 9 0.104 ms
for constraint client_idfk 7.936 ms 9 0.882 ms
for constraint client_idfk 31.251 ms 9 3.472 ms
for constraint client_idfk 0.607 ms 9 0.067 ms
for constraint client_parent_billing_client_id_fkey 1,359.455 ms 9 151.051 ms
for constraint clientwarehousefk 1,322.701 ms 9 146.967 ms
for constraint clobmobifk 1.285 ms 9 0.143 ms
for constraint clsmsifk 0.580 ms 9 0.064 ms
for constraint custcodecustfk 0.547 ms 9 0.061 ms
for constraint customer_list_dealer_id_fkey 0.593 ms 9 0.066 ms
for constraint customer_list_source_dealer_id_fkey 0.510 ms 9 0.057 ms
for constraint ddp_dlr_fk 1.576 ms 9 0.175 ms
for constraint dealer_performance_dealer_id_fkey 2.293 ms 9 0.255 ms
for constraint delivery_order_billing_client_id_fkey 2.390 ms 9 0.266 ms
for constraint dispdealerfk 0.676 ms 9 0.075 ms
for constraint dlrhistdlrfk 0.554 ms 9 0.062 ms
for constraint dlrhistwhfk 0.490 ms 9 0.054 ms
for constraint doorderedbyfk 1.484 ms 9 0.165 ms
for constraint driver_dealer_change_new_dealer_id_fkey 0.608 ms 9 0.068 ms
for constraint driver_dealer_change_old_dealer_id_fkey 0.525 ms 9 0.058 ms
for constraint driver_position_client_id_fkey 2.272 ms 9 0.252 ms
for constraint driverdealerfk 1.406 ms 9 0.156 ms
for constraint fk_client_from_adp_feed 0.516 ms 9 0.057 ms
for constraint fmpbilltoclientfk 0.622 ms 9 0.069 ms
for constraint fmplocwhfk 0.584 ms 9 0.065 ms
for constraint mergeclientfk 1,314.424 ms 9 146.047 ms
for constraint orderdestfk 3.262 ms 9 0.362 ms
for constraint ordersourcefk 1.482 ms 9 0.165 ms
for constraint origdestfk 1,760.325 ms 9 195.592 ms
for constraint origsourcefk 2,151.968 ms 9 239.108 ms
for constraint recurring_routes_alternate_endpoint_id_fkey 1.260 ms 9 0.140 ms
for constraint recurring_routes_alternate_startpoint_id_fkey 0.454 ms 9 0.050 ms
for constraint scheduled_run_warehouse_id_fkey 0.545 ms 9 0.061 ms
for constraint scheduled_run_warehouse_id_fkey1 0.438 ms 9 0.049 ms
for constraint scheduled_run_warehouse_id_fkey2 0.430 ms 9 0.048 ms
for constraint shiptoclientfk 0.463 ms 9 0.051 ms
for constraint signerclientfk 0.536 ms 9 0.060 ms
for constraint sr_client_map_client_id_fkey 0.561 ms 9 0.062 ms
for constraint transfer_history_from_client_id_fkey 90.627 ms 9 10.070 ms
for constraint transfer_history_to_client_id_fkey 91.776 ms 9 10.197 ms
for constraint vehicle_dispatch_map_dealer_id_fkey 0.760 ms 9 0.084 ms
for constraint vehicle_location_fk 1.039 ms 9 0.115 ms
for constraint vendor_client_id_fkey 0.552 ms 9 0.061 ms
for constraint warehousefk 0.515 ms 9 0.057 ms
for constraint zone_dispatch_fk 0.564 ms 9 0.063 ms
for constraint client_idfk 0.514 ms 9 0.057 ms
for constraint client_idfk 0.473 ms 9 0.053 ms
for constraint client_idfk 0.451 ms 9 0.050 ms
for constraint client_idfk 0.551 ms 9 0.061 ms
for constraint transfer_location_setting_local_client_id_fkey 0.469 ms 9 0.052 ms
for constraint sms_text_log_location_id_fkey 0.474 ms 9 0.053 ms
for constraint client_email_template_map_client_id_fkey 0.483 ms 9 0.054 ms
for constraint fk_pickup_source_id_map_to_source 0.542 ms 9 0.060 ms
for constraint driver_default_start_client_id_fkey 1.282 ms 9 0.142 ms
for constraint driver_default_end_client_id_fkey 0.949 ms 9 0.105 ms
for constraint customer_list_default_start_client_id_fkey 0.530 ms 9 0.059 ms
for constraint customer_list_default_end_client_id_fkey 0.479 ms 9 0.053 ms
for constraint scorev2_route_performance_by_dealer_summary_dealer_id_fkey 0.946 ms 9 0.105 ms
for constraint scorev2_driver_dealer_performance_dealer_id_fkey 11.658 ms 9 1.295 ms
for constraint scorev2_driver_dealer_performance_summary_dealer_id_fkey 0.948 ms 9 0.105 ms
for constraint driver_home_client_id_fkey 0.941 ms 9 0.105 ms
for constraint client_notification_recipient_client_id_fkey 2.151 ms 9 0.239 ms
for constraint location_id_fk 0.499 ms 9 0.055 ms