explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5kto

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.464 ↓ 0.0 0 1

Unique (cost=3,676.23..3,774.93 rows=94 width=17,239) (actual time=0.464..0.464 rows=0 loops=1)

  • Buffers: shared hit=34
2. 0.446 0.464 ↓ 0.0 0 1

Sort (cost=3,676.23..3,676.46 rows=94 width=17,239) (actual time=0.464..0.464 rows=0 loops=1)

  • Sort Key: deliverytr0_.transaction_date, deliverytr0_.id, company1_.id, company2_.id, address3_.id, address4_.id, xdock5_.id, xdock6_.id, xdock7_.id, user8_.id, user9_.id, product10_.id, receiver11_.id, optiondefi12_.id, receiverad13_.id, optiondefi14_.id, deliverytr0_.created_by, deliverytr0_.created_on, deliverytr0_.row_status, deliverytr0_.row_version, deliverytr0_.tenant_id, deliverytr0_.updated_by, deliverytr0_.updated_on, deliverytr0_.accept_date, deliverytr0_.application_no, deliverytr0_.assigned_user_id, deliverytr0_.barcode, deliverytr0_.chute_no, deliverytr0_.chute_time, deliverytr0_.current_user_id, deliverytr0_.current_vehicle_id, deliverytr0_.current_xdock_id, deliverytr0_.custody_time, deliverytr0_.customer_id, deliverytr0_.customer_delivery_no, deliverytr0_.customer_invoice_id, deliverytr0_.customer_order_id, deliverytr0_.delete_reason, deliverytr0_.delivered_date, deliverytr0_.delivered_person, deliverytr0_.delivered_person_gsm, deliverytr0_.delivered_person_id_no, deliverytr0_.par_delivered_person_type, deliverytr0_.delivery_attempt, deliverytr0_.delivery_date_current, deliverytr0_.delivery_date_original, deliverytr0_.delivery_date_promised, deliverytr0_.delivery_end_time, deliverytr0_.delivery_slot_current, deliverytr0_.delivery_slot_original, deliverytr0_.delivery_slot_promised, deliverytr0_.delivery_start_time, deliverytr0_.par_delivery_status, deliverytr0_.par_delivery_type, deliverytr0_.desi, deliverytr0_.dispatch_xdock_id, deliverytr0_.distribution_zone_id, deliverytr0_.first_process_date, deliverytr0_.first_visit_date, deliverytr0_.first_visit_time, deliverytr0_.first_visit_slot, deliverytr0_.height, deliverytr0_.par_integration_direction, deliverytr0_.integration_message, deliverytr0_.par_integration_status, deliverytr0_.invoice_amount, deliverytr0_.par_invoice_status, deliverytr0_.invoice_vat, deliverytr0_.kg, deliverytr0_.latest_courier_user_id, deliverytr0_.latitude, deliverytr0_.length, deliverytr0_.longtitude, deliverytr0_.merchant_id, deliverytr0_.non_delivery_date, deliverytr0_.par_non_delivery_reason, deliverytr0_.non_return_date, deliverytr0_.par_non_return_reason, deliverytr0_.non_signature_date, deliverytr0_.par_non_signature_reason, deliverytr0_.par_operation_status, deliverytr0_.parcel_no, deliverytr0_.payout_amount, deliverytr0_.par_payout_status, deliverytr0_.postponed, deliverytr0_.product_id, deliverytr0_.product_slots_id, deliverytr0_.receiver_id, deliverytr0_.receiver_address_id, deliverytr0_.receiver_xdock_id, deliverytr0_.recipient_address_id, deliverytr0_.return_date, deliverytr0_.return_flag, deliverytr0_.return_person, deliverytr0_.return_person_gsm, deliverytr0_.return_person_id_no, deliverytr0_.par_return_person_type, deliverytr0_.sender_address_id, deliverytr0_.sender_xdock_id, deliverytr0_.signature_date, deliverytr0_.signature_person_id_no, deliverytr0_.total_parcels, deliverytr0_.par_transaction_type, deliverytr0_.width, company1_.created_by, company1_.created_on, company1_.row_status, company1_.row_version, company1_.tenant_id, company1_.updated_by, company1_.updated_on, company1_.abbreviation_code, company1_.company_company_id, company1_.company_extension_id, company1_.company_logo, company1_.par_company_type, company1_.corporate_name, company1_.failed_attempt, company1_.company_name, company1_.title, company2_.created_by, company2_.created_on, company2_.row_status, company2_.row_version, company2_.tenant_id, company2_.updated_by, company2_.updated_on, company2_.abbreviation_code, company2_.company_company_id, company2_.company_extension_id, company2_.company_logo, company2_.par_company_type, company2_.corporate_name, company2_.failed_attempt, company2_.company_name, company2_.title, address3_.created_by, address3_.created_on, address3_.row_status, address3_.row_version, address3_.tenant_id, address3_.updated_by, address3_.updated_on, address3_.address_code, address3_.address_line_1, address3_.address_line_2, address3_.city_id, address3_.company_address_id, address3_.country_id, address3_.district_id, address3_.latitude, address3_.longtitude, address3_.postal_code, address3_.town_id, address4_.created_by, address4_.created_on, address4_.row_status, address4_.row_version, address4_.tenant_id, address4_.updated_by, address4_.updated_on, address4_.address_code, address4_.address_line_1, address4_.address_line_2, address4_.city_id, address4_.company_address_id, address4_.country_id, address4_.district_id, address4_.latitude, address4_.longtitude, address4_.postal_code, address4_.town_id, xdock5_.created_by, xdock5_.created_on, xdock5_.row_status, xdock5_.row_version, xdock5_.tenant_id, xdock5_.updated_by, xdock5_.updated_on, xdock5_.abbreviation_code, xdock5_.address, xdock5_.address_code, xdock5_.company_id, xdock5_.distribution_xdock_id, xdock5_.district_id, xdock5_.xdock_name, xdock5_.return_xdock_id, xdock5_.par_xdock_type, xdock6_.created_by, xdock6_.created_on, xdock6_.row_status, xdock6_.row_version, xdock6_.tenant_id, xdock6_.updated_by, xdock6_.updated_on, xdock6_.abbreviation_code, xdock6_.address, xdock6_.address_code, xdock6_.company_id, xdock6_.distribution_xdock_id, xdock6_.district_id, xdock6_.xdock_name, xdock6_.return_xdock_id, xdock6_.par_xdock_type, xdock7_.created_by, xdock7_.created_on, xdock7_.row_status, xdock7_.row_version, xdock7_.tenant_id, xdock7_.updated_by, xdock7_.updated_on, xdock7_.abbreviation_code, xdock7_.address, xdock7_.address_code, xdock7_.company_id, xdock7_.distribution_xdock_id, xdock7_.district_id, xdock7_.xdock_name, xdock7_.return_xdock_id, xdock7_.par_xdock_type, user8_.created_by, user8_.created_on, user8_.row_status, user8_.row_version, user8_.tenant_id, user8_.updated_by, user8_.updated_on, user8_.address, user8_.citizenship_no, user8_.company_id, user8_.device_token, user8_.email, user8_.false_login_count, user8_.firstname, user8_.par_language, user8_.lastname, user8_.locked, user8_.old_password_1, user8_.old_password_2, user8_.password, user8_.tel, user8_.user_type, user8_.username, user9_.created_by, user9_.created_on, user9_.row_status, user9_.row_version, user9_.tenant_id, user9_.updated_by, user9_.updated_on, user9_.address, user9_.citizenship_no, user9_.company_id, user9_.device_token, user9_.email, user9_.false_login_count, user9_.firstname, user9_.par_language, user9_.lastname, user9_.locked, user9_.old_password_1, user9_.old_password_2, user9_.password, user9_.tel, user9_.user_type, user9_.username, product10_.created_by, product10_.created_on, product10_.row_status, product10_.row_version, product10_.tenant_id, product10_.updated_by, product10_.updated_on, product10_.message_key, product10_.priority, product10_.product_code, product10_.product_name, product10_.vat_rate, receiver11_.created_by, receiver11_.created_on, receiver11_.row_status, receiver11_.row_version, receiver11_.tenant_id, receiver11_.updated_by, receiver11_.updated_on, receiver11_.company_customer_id, receiver11_.email, receiver11_.first_name, receiver11_.gsm1, receiver11_.gsm2, receiver11_.id_no, receiver11_.last_name, optiondefi12_.created_by, optiondefi12_.created_on, optiondefi12_.row_status, optiondefi12_.row_version, optiondefi12_.tenant_id, optiondefi12_.updated_by, optiondefi12_.updated_on, optiondefi12_.option_key, optiondefi12_.message_key, optiondefi12_.option_order, optiondefi12_.option_type, receiverad13_.created_by, receiverad13_.created_on, receiverad13_.row_status, receiverad13_.row_version, receiverad13_.tenant_id, receiverad13_.updated_by, receiverad13_.updated_on, receiverad13_.address_id, receiverad13_.citizenship_no, receiverad13_.recipient_person, receiverad13_.recipient_person_gsm1, receiverad13_.recipient_person_gsm2, receiverad13_.email, receiverad13_.gender, receiverad13_.address_name, receiverad13_.nationality, receiverad13_.occupation, receiverad13_.passport_no, receiverad13_.receiver_id, receiverad13_.title, optiondefi14_.created_by, optiondefi14_.created_on, optiondefi14_.row_status, optiondefi14_.row_version, optiondefi14_.tenant_id, optiondefi14_.updated_by, optiondefi14_.updated_on, optiondefi14_.option_key, optiondefi14_.message_key, optiondefi14_.option_order, optiondefi14_.option_type, delivery15_.created_by, delivery15_.created_on, delivery15_.row_status, delivery15_.row_version, delivery15_.tenant_id, delivery15_.updated_by, delivery15_.updated_on, delivery15_.accept_date, delivery15_.application_no, delivery15_.assigned_user_id, delivery15_.barcode, delivery15_.chute_no, delivery15_.chute_time, delivery15_.collected, delivery15_.current_user_id, delivery15_.current_vehicle_id, delivery15_.current_xdock_id, delivery15_.custody_time, delivery15_.customer_id, delivery15_.customer_delivery_no, delivery15_.customer_invoice_id, delivery15_.customer_order_id, delivery15_.delivered_person_id_no, delivery15_.delivered_date, delivery15_.delivered_person, delivery15_.delivered_person_gsm, delivery15_.par_delivered_person_type, delivery15_.delivery_attempt, delivery15_.delivery_date_current, delivery15_.delivery_date_original, delivery15_.delivery_date_promised, delivery15_.delivery_end_time, delivery15_.delivery_slot_current, delivery15_.delivery_slot_original, delivery15_.delivery_slot_promised, delivery15_.delivery_start_time, delivery15_.par_delivery_status, delivery15_.par_delivery_type, delivery15_.desi, delivery15_.dispatch_xdock_id, delivery15_.distribution_zone_id, delivery15_.first_process_date, delivery15_.first_visit_date, delivery15_.first_visit_time, delivery15_.first_visit_slot, delivery15_.height, delivery15_.par_integration_status, delivery15_.invoice_amount, delivery15_.invoice_btk, delivery15_.par_invoice_status, delivery15_.invoice_vat, delivery15_.kg, delivery15_.latest_courier_user_id, delivery15_.length, delivery15_.merchant_id, delivery15_.non_delivery_date, delivery15_.par_non_delivery_reason, delivery15_.non_return_date, delivery15_.par_non_return_reason, delivery15_.non_signature_date, delivery15_.par_non_signature_reason, delivery15_.par_operation_status, delivery15_.parcel_no, delivery15_.payout_amount, delivery15_.par_payout_status, delivery15_.postponed, delivery15_.product_id, delivery15_.product_slots_id, delivery15_.receiver_id, delivery15_.receiver_address_id, delivery15_.receiver_xdock_id, delivery15_.recipient_address_id, delivery15_.return_date, delivery15_.return_flag, delivery15_.return_person, delivery15_.return_person_gsm, delivery15_.return_person_id_no, delivery15_.par_return_person_type, delivery15_.sender_address_id, delivery15_.sender_xdock_id, delivery15_.signature_date, delivery15_.signature_person_id_no, delivery15_.total_parcels, delivery15_.width, delivery15_.xdock_responsible_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=34
3. 0.001 0.018 ↓ 0.0 0 1

Nested Loop (cost=415.58..3,673.14 rows=94 width=17,239) (actual time=0.018..0.018 rows=0 loops=1)

  • Buffers: shared hit=3
4. 0.017 0.017 ↓ 0.0 0 1

Index Scan using delivery_pkey on delivery delivery15_ (cost=0.43..8.45 rows=1 width=2,158) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (id = '15907864'::bigint)
  • Buffers: shared hit=3
5. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=415.15..3,663.75 rows=94 width=15,081) (never executed)

  • Hash Cond: (deliverytr0_.par_non_delivery_reason = optiondefi14_.id)
6. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=406.00..3,654.35 rows=94 width=14,975) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=405.56..2,859.82 rows=94 width=12,251) (never executed)

  • Hash Cond: (deliverytr0_.par_delivered_person_type = optiondefi12_.id)
8. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=396.41..2,850.42 rows=94 width=12,145) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=395.98..2,056.12 rows=94 width=11,982) (never executed)

  • Hash Cond: (deliverytr0_.product_id = product10_.id)
10. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=394.77..2,054.56 rows=94 width=11,868) (never executed)

  • Hash Cond: (deliverytr0_.assigned_user_id = user9_.id)
11. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=237.08..1,896.62 rows=94 width=9,592) (never executed)

  • Hash Cond: (deliverytr0_.current_user_id = user8_.id)
12. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=79.39..1,738.68 rows=94 width=7,316) (never executed)

  • Hash Cond: (deliverytr0_.current_xdock_id = xdock7_.id)
13. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=70.41..1,729.45 rows=94 width=7,100) (never executed)

  • Hash Cond: (deliverytr0_.receiver_xdock_id = xdock6_.id)
14. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=61.42..1,720.21 rows=94 width=6,884) (never executed)

  • Hash Cond: (deliverytr0_.sender_xdock_id = xdock5_.id)
15. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=52.44..1,710.97 rows=94 width=6,668) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=52.01..916.43 rows=94 width=5,431) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=51.57..121.90 rows=94 width=4,194) (never executed)

  • Hash Cond: (deliverytr0_.customer_id = company2_.id)
18. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=26.07..96.15 rows=94 width=3,523) (never executed)

  • Hash Cond: (deliverytr0_.merchant_id = company1_.id)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using delivery_transaction_delivery_id_ix on delivery_transaction deliverytr0_ (cost=0.57..70.41 rows=94 width=2,852) (never executed)

  • Index Cond: (delivery_id = '15907864'::bigint)
  • Filter: ((row_status)::text <> 'DELETED'::text)
20. 0.000 0.000 ↓ 0.0 0

Hash (cost=18.00..18.00 rows=600 width=671) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Seq Scan on company company1_ (cost=0.00..18.00 rows=600 width=671) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Hash (cost=18.00..18.00 rows=600 width=671) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Seq Scan on company company2_ (cost=0.00..18.00 rows=600 width=671) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Index Scan using address_pkey on address address3_ (cost=0.43..8.45 rows=1 width=1,237) (never executed)

  • Index Cond: (deliverytr0_.sender_address_id = id)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using address_pkey on address address4_ (cost=0.43..8.45 rows=1 width=1,237) (never executed)

  • Index Cond: (deliverytr0_.receiver_address_id = id)
26. 0.000 0.000 ↓ 0.0 0

Hash (cost=6.77..6.77 rows=177 width=216) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Seq Scan on xdock xdock5_ (cost=0.00..6.77 rows=177 width=216) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Hash (cost=6.77..6.77 rows=177 width=216) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Seq Scan on xdock xdock6_ (cost=0.00..6.77 rows=177 width=216) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Hash (cost=6.77..6.77 rows=177 width=216) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Seq Scan on xdock xdock7_ (cost=0.00..6.77 rows=177 width=216) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Hash (cost=134.53..134.53 rows=1,853 width=2,276) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Seq Scan on users user8_ (cost=0.00..134.53 rows=1,853 width=2,276) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Hash (cost=134.53..134.53 rows=1,853 width=2,276) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Seq Scan on users user9_ (cost=0.00..134.53 rows=1,853 width=2,276) (never executed)

36. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.09..1.09 rows=9 width=114) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Seq Scan on product product10_ (cost=0.00..1.09 rows=9 width=114) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Index Scan using receiver_pkey on receiver receiver11_ (cost=0.43..8.45 rows=1 width=163) (never executed)

  • Index Cond: (deliverytr0_.receiver_id = id)
39. 0.000 0.000 ↓ 0.0 0

Hash (cost=6.29..6.29 rows=229 width=106) (never executed)

40. 0.000 0.000 ↓ 0.0 0

Seq Scan on option_definition optiondefi12_ (cost=0.00..6.29 rows=229 width=106) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Index Scan using receiver_address_pkey on receiver_address receiverad13_ (cost=0.43..8.45 rows=1 width=2,724) (never executed)

  • Index Cond: (deliverytr0_.recipient_address_id = id)
42. 0.000 0.000 ↓ 0.0 0

Hash (cost=6.29..6.29 rows=229 width=106) (never executed)

43. 0.000 0.000 ↓ 0.0 0

Seq Scan on option_definition optiondefi14_ (cost=0.00..6.29 rows=229 width=106) (never executed)

Planning time : 1,426.198 ms
Execution time : 2.343 ms