explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LPMz

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 612.623 ↑ 1.0 1 1

Limit (cost=16,927.78..16,928.39 rows=1 width=3,071) (actual time=612.622..612.623 rows=1 loops=1)

  • Buffers: shared hit=3768
2. 0.000 612.622 ↑ 1.0 1 1

Unique (cost=16,927.78..16,928.39 rows=1 width=3,071) (actual time=612.621..612.622 rows=1 loops=1)

  • Buffers: shared hit=3768
3. 0.297 612.622 ↑ 1.0 1 1

Sort (cost=16,927.78..16,927.79 rows=1 width=3,071) (actual time=612.621..612.622 rows=1 loops=1)

  • Sort Key: orders.ordered_at, orders.code, order_items.no, customers.code, customers.short_name, drivers.code, drivers.name, trucks.code, trucks.number_plate, orders.additional_truck, truck_models.code, truck_models.label, address_labels.code, address_labels.label, associates1.code, associates1.name, offices.code, offices.name, orders.departure_at, orders.arrival_at, districts.code, districts.label, areas1.code, orders.departure_area_text, orders.departure_address, orders.shipper_name, orders.shipper_poc, areas2.code, orders.arrival_area_text, orders.arrival_address, orders.consignee_name, orders.consignee_poc, areas3.code, orders.via, notes.code, orders.departure_note_comment1, orders.departure_note_comment2, orders.departure_note_comment3, areas1.distance, truckages1.code, truckages1.name, orders.truckage_fundament, tax_types1.id, tax_types1.label, orders.truckage_extra, order_items.quantity, order_items.item_code, order_items.item_name, order_items.unit, order_items.item_cost, order_items.amount, orders.truckage_item_cost_total, orders.truckage_fundament_total, orders.truckage_hour_extra, tax_types2.id, tax_types2.label, orders.truckage_distance_extra, tax_types3.id, tax_types3.label, orders.truckage_discount, tax_types4.id, tax_types4.label, orders.truckage_other1, tax_types5.id, tax_types5.label, orders.truckage_other2, tax_types6.id, tax_types6.label, orders.truckage_toll, tax_types7.id, tax_types7.label, orders.truckage_total, drive_report_truckages.total, drive_report_truckages.tax, drive_report_truckages.taxable_total, drive_report_truckages.item_total, tax_rates1.rate, orders.truckage_truck_total, orders.truckage_driver_total, truckages2.code, truckages2.name, associates1.associate_rate, orders.associate_truckage_fundament, tax_types8.id, tax_types8.label, orders.associate_truckage_extra, orders.associate_truckage_base, orders.associate_truckage_hour_extra, tax_types9.id, tax_types9.label, orders.associate_truckage_distance_extra, tax_types10.id, tax_types10.label, orders.associate_truckage_discount, tax_types11.id, tax_types11.label, orders.associate_truckage_other1, tax_types12.id, tax_types12.label, orders.associate_truckage_other2, tax_types13.id, tax_types13.label, orders.associate_truckage_toll, tax_types14.id, tax_types14.label, orders.associate_truckage_total, tax_rates2.rate, orders.user_id, users.name, orders.updated_at, orders.departure_notice_comment1, orders.departure_notice_comment2, orders.departure_notice_comment3, orders.constructor_name, orders.constructor_poc, orders.arrival_note_comment1, orders.arrival_note_comment2, orders.arrival_note_comment3, orders.arrival_notice_comment1, orders.arrival_notice_comment2, orders.arrival_notice_comment3, associates2.code, associates2.name, associates3.code, associates3.name, c_taxonomies.code, c_taxonomies.name, c_taxonomies_1.code, c_taxonomies_1.name, c_taxonomies_2.code, c_taxonomies_2.name, c_taxonomies_3.code, c_taxonomies_3.name, c_taxonomies_4.code, c_taxonomies_4.name, c_taxonomies_5.code, c_taxonomies_5.name, c_taxonomies_6.code, c_taxonomies_6.name, c_taxonomies_7.code, c_taxonomies_7.name, c_taxonomies_8.code, c_taxonomies_8.name, c_taxonomies_9.code, c_taxonomies_9.name, a_taxonomies.code, a_taxonomies.name, a_taxonomies_1.code, a_taxonomies_1.name, a_taxonomies_2.code, a_taxonomies_2.name, a_taxonomies_3.code, a_taxonomies_3.name, a_taxonomies_4.code, a_taxonomies_4.name, a_taxonomies_5.code, a_taxonomies_5.name, a_taxonomies_6.code, a_taxonomies_6.name, a_taxonomies_7.code, a_taxonomies_7.name, a_taxonomies_8.code, a_taxonomies_8.name, a_taxonomies_9.code, a_taxonomies_9.name, d_taxonomies.code, d_taxonomies.name, d_taxonomies_1.code, d_taxonomies_1.name, d_taxonomies_2.code, d_taxonomies_2.name, d_taxonomies_3.code, d_taxonomies_3.name, d_taxonomies_4.code, d_taxonomies_4.name, d_taxonomies_5.code, d_taxonomies_5.name, d_taxonomies_6.code, d_taxonomies_6.name, d_taxonomies_7.code, d_taxonomies_7.name, d_taxonomies_8.code, d_taxonomies_8.name, d_taxonomies_9.code, d_taxonomies_9.name, t_taxonomies.code, t_taxonomies.name, t_taxonomies_1.code, t_taxonomies_1.name, t_taxonomies_2.code, t_taxonomies_2.name, t_taxonomies_3.code, t_taxonomies_3.name, t_taxonomies_4.code, t_taxonomies_4.name, t_taxonomies_5.code, t_taxonomies_5.name, t_taxonomies_6.code, t_taxonomies_6.name, t_taxonomies_7.code, t_taxonomies_7.name, t_taxonomies_8.code, t_taxonomies_8.name, t_taxonomies_9.code, t_taxonomies_9.name, b_taxonomies.code, b_taxonomies.name, b_taxonomies_1.code, b_taxonomies_1.name, b_taxonomies_2.code, b_taxonomies_2.name, b_taxonomies_3.code, b_taxonomies_3.name, b_taxonomies_4.code, b_taxonomies_4.name, b_taxonomies_5.code, b_taxonomies_5.name, b_taxonomies_6.code, b_taxonomies_6.name, b_taxonomies_7.code, b_taxonomies_7.name, b_taxonomies_8.code, b_taxonomies_8.name, b_taxonomies_9.code, b_taxonomies_9.name, drivers1.code, drivers1.name, assistants1.cost, drivers2.code, drivers2.name, assistants2.cost, drivers3.code, drivers3.name, assistants3.cost, drivers4.code, drivers4.name, assistants4.cost, drivers5.code, drivers5.name, assistants5.cost, assistants1.order_id
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=3768
4. 0.100 612.325 ↑ 1.0 1 1

Nested Loop (cost=5,346.43..16,927.77 rows=1 width=3,071) (actual time=331.273..612.325 rows=1 loops=1)

  • Buffers: shared hit=3768
5. 0.055 582.917 ↑ 1.0 1 1

Nested Loop (cost=4,983.16..16,183.61 rows=1 width=2,875) (actual time=305.344..582.917 rows=1 loops=1)

  • Buffers: shared hit=3569
6. 0.005 574.497 ↑ 1.0 1 1

Nested Loop (cost=4,543.37..15,702.62 rows=1 width=2,723) (actual time=297.411..574.497 rows=1 loops=1)

  • Buffers: shared hit=3393
7. 0.457 574.467 ↑ 1.0 1 1

Nested Loop (cost=4,541.66..15,547.19 rows=1 width=2,498) (actual time=297.381..574.467 rows=1 loops=1)

  • Buffers: shared hit=3390
8. 2.653 504.587 ↑ 1.0 1 1

Nested Loop (cost=3,733.46..14,230.67 rows=1 width=2,346) (actual time=227.502..504.587 rows=1 loops=1)

  • Buffers: shared hit=3190
9. 0.018 124.809 ↑ 1.0 1 1

Nested Loop (cost=366.4..3,506.76 rows=1 width=2,194) (actual time=53.157..124.809 rows=1 loops=1)

  • Buffers: shared hit=1721
10. 0.011 124.784 ↑ 1.0 1 1

Nested Loop (cost=366.4..3,505.37 rows=1 width=1,678) (actual time=53.131..124.784 rows=1 loops=1)

  • Buffers: shared hit=1720
11. 0.114 124.757 ↑ 1.0 1 1

Nested Loop (cost=366.4..3,504.31 rows=1 width=1,646) (actual time=53.105..124.757 rows=1 loops=1)

  • Buffers: shared hit=1719
12. 0.004 78.573 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,760.15 rows=1 width=1,486) (actual time=27.286..78.573 rows=1 loops=1)

  • Buffers: shared hit=1520
13. 0.005 78.567 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,759.09 rows=1 width=1,454) (actual time=27.28..78.567 rows=1 loops=1)

  • Buffers: shared hit=1519
14. 0.004 78.558 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,758.04 rows=1 width=1,422) (actual time=27.273..78.558 rows=1 loops=1)

  • Buffers: shared hit=1518
15. 0.006 78.552 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,756.98 rows=1 width=1,390) (actual time=27.267..78.552 rows=1 loops=1)

  • Buffers: shared hit=1517
16. 0.004 78.545 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,755.93 rows=1 width=1,358) (actual time=27.26..78.545 rows=1 loops=1)

  • Buffers: shared hit=1516
17. 0.004 78.538 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,754.87 rows=1 width=1,326) (actual time=27.254..78.538 rows=1 loops=1)

  • Buffers: shared hit=1515
18. 0.006 78.530 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,753.82 rows=1 width=1,294) (actual time=27.247..78.53 rows=1 loops=1)

  • Buffers: shared hit=1514
19. 0.006 78.520 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,752.76 rows=1 width=1,262) (actual time=27.24..78.52 rows=1 loops=1)

  • Buffers: shared hit=1513
20. 0.005 78.511 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,751.71 rows=1 width=1,230) (actual time=27.234..78.511 rows=1 loops=1)

  • Buffers: shared hit=1512
21. 0.005 78.503 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,750.65 rows=1 width=1,198) (actual time=27.229..78.503 rows=1 loops=1)

  • Buffers: shared hit=1511
22. 0.011 78.494 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,749.6 rows=1 width=1,166) (actual time=27.222..78.494 rows=1 loops=1)

  • Buffers: shared hit=1510
23. 0.006 78.480 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,748.54 rows=1 width=1,134) (actual time=27.21..78.48 rows=1 loops=1)

  • Buffers: shared hit=1509
24. 0.006 78.471 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,747.49 rows=1 width=1,102) (actual time=27.203..78.471 rows=1 loops=1)

  • Buffers: shared hit=1508
25. 0.004 78.461 ↑ 1.0 1 1

Nested Loop (cost=3.14..2,746.43 rows=1 width=1,070) (actual time=27.197..78.461 rows=1 loops=1)

  • Buffers: shared hit=1507
26. 0.004 78.447 ↑ 1.0 1 1

Nested Loop (cost=2.85..2,738.12 rows=1 width=1,062) (actual time=27.185..78.447 rows=1 loops=1)

  • Buffers: shared hit=1504
27. 0.011 78.439 ↑ 1.0 1 1

Nested Loop (cost=2.85..2,737.03 rows=1 width=1,062) (actual time=27.178..78.439 rows=1 loops=1)

  • Buffers: shared hit=1503
28. 0.014 78.421 ↑ 1.0 1 1

Nested Loop (cost=2.85..2,735.93 rows=1 width=1,062) (actual time=27.162..78.421 rows=1 loops=1)

  • Buffers: shared hit=1502
29. 0.003 0.747 ↑ 1.0 1 1

Nested Loop (cost=2.85..164.57 rows=1 width=1,012) (actual time=0.394..0.747 rows=1 loops=1)

  • Buffers: shared hit=56
30. 0.004 0.741 ↑ 1.0 1 1

Nested Loop (cost=2.85..163.52 rows=1 width=956) (actual time=0.389..0.741 rows=1 loops=1)

  • Buffers: shared hit=55
31. 0.013 0.731 ↑ 1.0 1 1

Nested Loop (cost=2.85..162.46 rows=1 width=900) (actual time=0.379..0.731 rows=1 loops=1)

  • Buffers: shared hit=54
32. 0.015 0.696 ↑ 1.0 1 1

Nested Loop (cost=2.85..158.42 rows=1 width=905) (actual time=0.345..0.696 rows=1 loops=1)

  • Buffers: shared hit=52
33. 0.004 0.679 ↑ 1.0 1 1

Nested Loop (cost=2.85..138.39 rows=1 width=897) (actual time=0.329..0.679 rows=1 loops=1)

  • Buffers: shared hit=52
34. 0.001 0.675 ↑ 1.0 1 1

Nested Loop (cost=2.56..130.08 rows=1 width=898) (actual time=0.326..0.675 rows=1 loops=1)

  • Buffers: shared hit=52
35. 0.002 0.669 ↑ 1.0 1 1

Nested Loop (cost=2.27..121.76 rows=1 width=899) (actual time=0.322..0.669 rows=1 loops=1)

  • Buffers: shared hit=49
36. 0.005 0.661 ↑ 1.0 1 1

Nested Loop (cost=1.98..113.45 rows=1 width=892) (actual time=0.316..0.661 rows=1 loops=1)

  • Buffers: shared hit=46
37. 0.005 0.650 ↑ 1.0 1 1

Nested Loop (cost=1.71..105.14 rows=1 width=878) (actual time=0.307..0.65 rows=1 loops=1)

  • Buffers: shared hit=43
38. 0.004 0.637 ↑ 1.0 1 1

Nested Loop (cost=1.71..103.87 rows=1 width=822) (actual time=0.297..0.637 rows=1 loops=1)

  • Buffers: shared hit=42
39. 0.000 0.632 ↑ 1.0 1 1

Nested Loop (cost=1.43..95.56 rows=1 width=801) (actual time=0.294..0.632 rows=1 loops=1)

  • Buffers: shared hit=42
40. 0.003 0.631 ↑ 1.0 1 1

Nested Loop (cost=1.15..87.26 rows=1 width=780) (actual time=0.293..0.631 rows=1 loops=1)

  • Buffers: shared hit=42
41. 0.006 0.628 ↑ 1.0 1 1

Nested Loop (cost=0.86..78.95 rows=1 width=687) (actual time=0.29..0.628 rows=1 loops=1)

  • Buffers: shared hit=42
42. 0.020 0.617 ↑ 1.0 1 1

Nested Loop (cost=0.86..77.89 rows=1 width=631) (actual time=0.283..0.617 rows=1 loops=1)

  • Buffers: shared hit=41
43. 0.068 0.578 ↑ 1.0 1 1

Nested Loop (cost=0.86..74.78 rows=1 width=619) (actual time=0.273..0.578 rows=1 loops=1)

  • Buffers: shared hit=40
44. 0.005 0.422 ↑ 1.0 1 1

Nested Loop (cost=0.86..61.53 rows=1 width=600) (actual time=0.147..0.422 rows=1 loops=1)

  • Buffers: shared hit=34
45. 0.007 0.362 ↑ 1.0 1 1

Nested Loop (cost=0.58..53.22 rows=1 width=567) (actual time=0.09..0.362 rows=1 loops=1)

  • Buffers: shared hit=31
46. 0.095 0.349 ↑ 1.0 1 1

Nested Loop (cost=0.29..44.9 rows=1 width=551) (actual time=0.078..0.349 rows=1 loops=1)

  • Buffers: shared hit=28
47. 0.022 0.022 ↑ 1.0 1 1

Index Scan using orders_pkey on orders orders (cost=0.29..8.31 rows=1 width=447) (actual time=0.02..0.022 rows=1 loops=1)

  • Index Cond: (orders.id = 17720)
  • Filter: ((NOT orders.is_deleted) AND (orders.ordered_at >= '2020-01-10 00:00:00'::timestamp without time zone) AND (orders.ordered_at <= '2020-01-10 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=3
48. 0.232 0.232 ↑ 1.0 515 1

Seq Scan on customers customers (cost=0..30.15 rows=515 width=112) (actual time=0.007..0.232 rows=515 loops=1)

  • Filter: (NOT customers.is_deleted)
  • Buffers: shared hit=25
49. 0.006 0.006 ↑ 1.0 1 1

Index Scan using drive_report_orders_order_id_idx on drive_report_orders drive_report_orders (cost=0.29..8.31 rows=1 width=24) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: (drive_report_orders.order_id = 17720)
  • Filter: (NOT drive_report_orders.is_deleted)
  • Buffers: shared hit=3
50. 0.055 0.055 ↑ 1.0 1 1

Index Scan using drivers_pkey on drivers drivers (cost=0.29..8.3 rows=1 width=41) (actual time=0.054..0.055 rows=1 loops=1)

  • Index Cond: (orders.driver_id = drivers.id)
  • Filter: (NOT drivers.is_deleted)
  • Buffers: shared hit=3
51. 0.088 0.088 ↑ 1.0 322 1

Seq Scan on trucks trucks (cost=0..9.22 rows=322 width=27) (actual time=0.005..0.088 rows=322 loops=1)

  • Filter: (NOT trucks.is_deleted)
  • Buffers: shared hit=6
52. 0.019 0.019 ↑ 1.0 94 1

Seq Scan on truck_models truck_models (cost=0..1.94 rows=94 width=28) (actual time=0.004..0.019 rows=94 loops=1)

  • Filter: (NOT truck_models.is_deleted)
  • Buffers: shared hit=1
53. 0.005 0.005 ↓ 1.5 3 1

Seq Scan on address_labels address_labels (cost=0..1.03 rows=2 width=72) (actual time=0.004..0.005 rows=3 loops=1)

  • Filter: (NOT address_labels.is_deleted)
  • Buffers: shared hit=1
54. 0.000 0.000 ↓ 0.0 0 1

Index Scan using associates_pkey on associates associates1 (cost=0.28..8.3 rows=1 width=101) (actual time=0..0 rows=0 loops=1)

  • Index Cond: (orders.associate_id1 = associates1.id)
  • Filter: (NOT associates1.is_deleted)
55. 0.001 0.001 ↓ 0.0 0 1

Index Scan using associates_pkey on associates associates2 (cost=0.28..8.3 rows=1 width=37) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (orders.associate_id2 = associates2.id)
  • Filter: (NOT associates2.is_deleted)
56. 0.001 0.001 ↓ 0.0 0 1

Index Scan using associates_pkey on associates associates3 (cost=0.28..8.3 rows=1 width=37) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (orders.associate_id3 = associates3.id)
  • Filter: (NOT associates3.is_deleted)
57. 0.008 0.008 ↓ 2.0 16 1

Seq Scan on offices offices (cost=0..1.17 rows=8 width=72) (actual time=0.004..0.008 rows=16 loops=1)

  • Filter: (NOT offices.is_deleted)
  • Buffers: shared hit=1
58. 0.006 0.006 ↑ 1.0 1 1

Index Scan using districts_pkey on districts districts (cost=0.28..8.29 rows=1 width=30) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: (orders.district_id = districts.id)
  • Filter: (NOT districts.is_deleted)
  • Buffers: shared hit=3
59. 0.006 0.006 ↑ 1.0 1 1

Index Scan using areas_pkey on areas areas1 (cost=0.29..8.3 rows=1 width=23) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: (orders.departure_area_id = areas1.id)
  • Filter: (NOT areas1.is_deleted)
  • Buffers: shared hit=3
60. 0.005 0.005 ↑ 1.0 1 1

Index Scan using areas_pkey on areas areas2 (cost=0.29..8.3 rows=1 width=15) (actual time=0.003..0.005 rows=1 loops=1)

  • Index Cond: (orders.arrival_area_id = areas2.id)
  • Filter: (NOT areas2.is_deleted)
  • Buffers: shared hit=3
61. 0.000 0.000 ↓ 0.0 0 1

Index Scan using areas_pkey on areas areas3 (cost=0.29..8.3 rows=1 width=15) (actual time=0..0 rows=0 loops=1)

  • Index Cond: (orders.via_area_id = areas3.id)
  • Filter: (NOT areas3.is_deleted)
62. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on order_notes order_notes (cost=0..20 rows=2 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((NOT order_notes.is_deleted) AND (order_notes.order_id = 17720))
63. 0.022 0.022 ↑ 1.0 91 1

Seq Scan on notes notes (cost=0..2.91 rows=91 width=11) (actual time=0.003..0.022 rows=91 loops=1)

  • Filter: (NOT notes.is_deleted)
  • Buffers: shared hit=2
64. 0.006 0.006 ↓ 1.5 3 1

Seq Scan on truckages truckages1 (cost=0..1.03 rows=2 width=72) (actual time=0.005..0.006 rows=3 loops=1)

  • Filter: (NOT truckages1.is_deleted)
  • Buffers: shared hit=1
65. 0.003 0.003 ↓ 1.5 3 1

Seq Scan on truckages truckages2 (cost=0..1.03 rows=2 width=72) (actual time=0.002..0.003 rows=3 loops=1)

  • Filter: (NOT truckages2.is_deleted)
  • Buffers: shared hit=1
66. 77.660 77.660 ↑ 2.0 1 1

Seq Scan on order_items order_items (cost=0..2,571.34 rows=2 width=58) (actual time=26.755..77.66 rows=1 loops=1)

  • Filter: ((NOT order_items.is_deleted) AND (order_items.order_id = 17720))
  • Buffers: shared hit=1446
67. 0.007 0.007 ↑ 1.0 4 1

Seq Scan on tax_rates tax_rates2 (cost=0..1.04 rows=4 width=16) (actual time=0.006..0.007 rows=4 loops=1)

  • Buffers: shared hit=1
68. 0.004 0.004 ↑ 1.0 4 1

Seq Scan on tax_rates tax_rates1 (cost=0..1.04 rows=4 width=16) (actual time=0.003..0.004 rows=4 loops=1)

  • Buffers: shared hit=1
69. 0.010 0.010 ↑ 1.0 1 1

Index Scan using drive_report_truckages_drive_report_order_id_idx on drive_report_truckages drive_report_truckages (cost=0.29..8.31 rows=1 width=24) (actual time=0.008..0.01 rows=1 loops=1)

  • Index Cond: (drive_report_orders.id = drive_report_truckages.drive_report_order_id)
  • Filter: (NOT drive_report_truckages.is_deleted)
  • Buffers: shared hit=3
70. 0.004 0.004 ↓ 1.5 3 1

Seq Scan on tax_types tax_types1 (cost=0..1.03 rows=2 width=40) (actual time=0.003..0.004 rows=3 loops=1)

  • Filter: (NOT tax_types1.is_deleted)
  • Buffers: shared hit=1
71. 0.003 0.003 ↓ 1.5 3 1

Seq Scan on tax_types tax_types2 (cost=0..1.03 rows=2 width=40) (actual time=0.002..0.003 rows=3 loops=1)

  • Filter: (NOT tax_types2.is_deleted)
  • Buffers: shared hit=1
72. 0.003 0.003 ↓ 1.5 3 1

Seq Scan on tax_types tax_types3 (cost=0..1.03 rows=2 width=40) (actual time=0.001..0.003 rows=3 loops=1)

  • Filter: (NOT tax_types3.is_deleted)
  • Buffers: shared hit=1
73. 0.004 0.004 ↓ 1.5 3 1

Seq Scan on tax_types tax_types4 (cost=0..1.03 rows=2 width=40) (actual time=0.003..0.004 rows=3 loops=1)

  • Filter: (NOT tax_types4.is_deleted)
  • Buffers: shared hit=1
74. 0.003 0.003 ↓ 1.5 3 1

Seq Scan on tax_types tax_types5 (cost=0..1.03 rows=2 width=40) (actual time=0.002..0.003 rows=3 loops=1)

  • Filter: (NOT tax_types5.is_deleted)
  • Buffers: shared hit=1
75. 0.003 0.003 ↓ 1.5 3 1

Seq Scan on tax_types tax_types6 (cost=0..1.03 rows=2 width=40) (actual time=0.002..0.003 rows=3 loops=1)

  • Filter: (NOT tax_types6.is_deleted)
  • Buffers: shared hit=1
76. 0.004 0.004 ↓ 1.5 3 1

Seq Scan on tax_types tax_types7 (cost=0..1.03 rows=2 width=40) (actual time=0.002..0.004 rows=3 loops=1)

  • Filter: (NOT tax_types7.is_deleted)
  • Buffers: shared hit=1
77. 0.004 0.004 ↓ 1.5 3 1

Seq Scan on tax_types tax_types8 (cost=0..1.03 rows=2 width=40) (actual time=0.003..0.004 rows=3 loops=1)

  • Filter: (NOT tax_types8.is_deleted)
  • Buffers: shared hit=1
78. 0.003 0.003 ↓ 1.5 3 1

Seq Scan on tax_types tax_types9 (cost=0..1.03 rows=2 width=40) (actual time=0.002..0.003 rows=3 loops=1)

  • Filter: (NOT tax_types9.is_deleted)
  • Buffers: shared hit=1
79. 0.001 0.001 ↓ 1.5 3 1

Seq Scan on tax_types tax_types10 (cost=0..1.03 rows=2 width=40) (actual time=0.001..0.001 rows=3 loops=1)

  • Filter: (NOT tax_types10.is_deleted)
  • Buffers: shared hit=1
80. 0.002 0.002 ↓ 1.5 3 1

Seq Scan on tax_types tax_types11 (cost=0..1.03 rows=2 width=40) (actual time=0.002..0.002 rows=3 loops=1)

  • Filter: (NOT tax_types11.is_deleted)
  • Buffers: shared hit=1
81. 0.004 0.004 ↓ 1.5 3 1

Seq Scan on tax_types tax_types12 (cost=0..1.03 rows=2 width=40) (actual time=0.003..0.004 rows=3 loops=1)

  • Filter: (NOT tax_types12.is_deleted)
  • Buffers: shared hit=1
82. 0.002 0.002 ↓ 1.5 3 1

Seq Scan on tax_types tax_types13 (cost=0..1.03 rows=2 width=40) (actual time=0.001..0.002 rows=3 loops=1)

  • Filter: (NOT tax_types13.is_deleted)
  • Buffers: shared hit=1
83. 0.117 46.070 ↑ 1.0 515 1

Merge Join (cost=363.27..737.73 rows=515 width=168) (actual time=6.145..46.07 rows=515 loops=1)

  • Buffers: shared hit=199
84. 0.119 45.462 ↑ 1.0 515 1

Merge Join (cost=327.17..667.48 rows=515 width=152) (actual time=5.651..45.462 rows=515 loops=1)

  • Buffers: shared hit=180
85. 0.115 44.853 ↑ 1.0 515 1

Merge Join (cost=291.07..597.24 rows=515 width=136) (actual time=5.158..44.853 rows=515 loops=1)

  • Buffers: shared hit=161
86. 16.903 44.215 ↑ 1.0 515 1

Merge Join (cost=254.49..526.12 rows=515 width=120) (actual time=4.635..44.215 rows=515 loops=1)

  • Buffers: shared hit=142
87. 0.094 26.833 ↑ 1.0 515 1

Merge Join (cost=218.39..455.88 rows=515 width=104) (actual time=4.156..26.833 rows=515 loops=1)

  • Buffers: shared hit=123
88. 0.208 26.215 ↑ 1.0 515 1

Merge Join (cost=182.29..385.63 rows=515 width=88) (actual time=3.631..26.215 rows=515 loops=1)

  • Buffers: shared hit=104
89. 0.174 6.413 ↑ 1.0 515 1

Merge Join (cost=145.71..314.52 rows=515 width=72) (actual time=3.061..6.413 rows=515 loops=1)

  • Buffers: shared hit=84
90. 0.172 5.434 ↑ 1.0 515 1

Merge Join (cost=109.61..244.27 rows=515 width=56) (actual time=2.312..5.434 rows=515 loops=1)

  • Buffers: shared hit=64
91. 0.399 4.431 ↑ 1.0 515 1

Merge Join (cost=72.48..172.22 rows=515 width=40) (actual time=1.758..4.431 rows=515 loops=1)

  • Buffers: shared hit=44
92. 0.333 2.324 ↑ 1.0 515 1

Merge Join (cost=36.38..101.97 rows=515 width=24) (actual time=0.872..2.324 rows=515 loops=1)

  • Buffers: shared hit=24
93. 0.114 0.232 ↑ 1.0 515 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.023..0.232 rows=515 loops=1)

  • Buffers: shared hit=4
94. 0.118 0.118 ↑ 1.0 515 1

Index Only Scan using customers_pkey on customers customers_1 (cost=0.28..25.29 rows=515 width=8) (actual time=0.023..0.118 rows=515 loops=1)

  • Index Cond: (customers_1.id IS NOT NULL)
  • Buffers: shared hit=4
95. 0.154 1.759 ↓ 128.8 515 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.847..1.759 rows=515 loops=1)

  • Buffers: shared hit=20
96. 0.355 1.605 ↓ 128.8 515 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.845..1.605 rows=515 loops=1)

  • Buffers: shared hit=20
97. 0.180 0.290 ↑ 1.0 515 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.019..0.29 rows=515 loops=1)

  • Buffers: shared hit=4
98. 0.110 0.110 ↑ 1.0 515 1

Index Only Scan using customers_pkey on customers customers_2 (cost=0.28..25.29 rows=515 width=8) (actual time=0.019..0.11 rows=515 loops=1)

  • Index Cond: (customers_2.id IS NOT NULL)
  • Buffers: shared hit=4
99. 0.262 0.960 ↓ 128.8 515 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.825..0.96 rows=515 loops=1)

  • Sort Key: customer_taxonomies_1.customer_id
  • Sort Method: quicksort Memory: 49kB
  • Buffers: shared hit=16
100. 0.325 0.698 ↓ 128.8 515 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.163..0.698 rows=515 loops=1)

  • Buffers: shared hit=16
101. 0.233 0.233 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_1 (cost=0..23.87 rows=1,187 width=16) (actual time=0.004..0.233 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_1.is_deleted)
  • Buffers: shared hit=12
102. 0.005 0.140 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.14..0.14 rows=1 loops=1)

  • Buffers: shared hit=4
103. 0.135 0.135 ↑ 1.0 1 1

Seq Scan on taxonomies c_taxonomies_1 (cost=0..7.41 rows=1 width=24) (actual time=0.027..0.135 rows=1 loops=1)

  • Filter: ((NOT c_taxonomies_1.is_deleted) AND (c_taxonomies_1.taxonomy_type_id = 2))
  • Buffers: shared hit=4
104. 0.142 1.708 ↓ 128.8 515 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.884..1.708 rows=515 loops=1)

  • Buffers: shared hit=20
105. 0.327 1.566 ↓ 128.8 515 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.879..1.566 rows=515 loops=1)

  • Buffers: shared hit=20
106. 0.129 0.249 ↑ 1.0 515 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.02..0.249 rows=515 loops=1)

  • Buffers: shared hit=4
107. 0.120 0.120 ↑ 1.0 515 1

Index Only Scan using customers_pkey on customers customers_3 (cost=0.28..25.29 rows=515 width=8) (actual time=0.02..0.12 rows=515 loops=1)

  • Index Cond: (customers_3.id IS NOT NULL)
  • Buffers: shared hit=4
108. 0.311 0.990 ↓ 128.8 515 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.855..0.99 rows=515 loops=1)

  • Sort Key: customer_taxonomies.customer_id
  • Sort Method: quicksort Memory: 49kB
  • Buffers: shared hit=16
109. 0.395 0.679 ↓ 128.8 515 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.088..0.679 rows=515 loops=1)

  • Buffers: shared hit=16
110. 0.214 0.214 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies (cost=0..23.87 rows=1,187 width=16) (actual time=0.005..0.214 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies.is_deleted)
  • Buffers: shared hit=12
111. 0.005 0.070 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.07..0.07 rows=1 loops=1)

  • Buffers: shared hit=4
112. 0.065 0.065 ↑ 1.0 1 1

Seq Scan on taxonomies c_taxonomies (cost=0..7.41 rows=1 width=24) (actual time=0.005..0.065 rows=1 loops=1)

  • Filter: ((NOT c_taxonomies.is_deleted) AND (c_taxonomies.taxonomy_type_id = 1))
  • Buffers: shared hit=4
113. 0.006 0.831 ↑ 3.0 10 1

Materialize (cost=37.13..70.39 rows=30 width=24) (actual time=0.55..0.831 rows=10 loops=1)

  • Buffers: shared hit=20
114. 0.081 0.825 ↑ 3.0 10 1

Merge Join (cost=37.13..70.32 rows=30 width=24) (actual time=0.547..0.825 rows=10 loops=1)

  • Buffers: shared hit=20
115. 0.122 0.217 ↑ 1.0 511 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.019..0.217 rows=511 loops=1)

  • Buffers: shared hit=4
116. 0.095 0.095 ↑ 1.0 511 1

Index Only Scan using customers_pkey on customers customers_4 (cost=0.28..25.29 rows=515 width=8) (actual time=0.019..0.095 rows=511 loops=1)

  • Index Cond: (customers_4.id IS NOT NULL)
  • Buffers: shared hit=4
117. 0.018 0.527 ↑ 3.0 10 1

Sort (cost=36.86..36.93 rows=30 width=24) (actual time=0.524..0.527 rows=10 loops=1)

  • Sort Key: customer_taxonomies_4.customer_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=16
118. 0.191 0.509 ↑ 3.0 10 1

Hash Join (cost=7.5..36.12 rows=30 width=24) (actual time=0.086..0.509 rows=10 loops=1)

  • Buffers: shared hit=16
119. 0.247 0.247 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_4 (cost=0..23.87 rows=1,187 width=16) (actual time=0.004..0.247 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_4.is_deleted)
  • Buffers: shared hit=12
120. 0.009 0.071 ↑ 1.0 7 1

Hash (cost=7.41..7.41 rows=7 width=24) (actual time=0.071..0.071 rows=7 loops=1)

  • Buffers: shared hit=4
121. 0.062 0.062 ↑ 1.0 7 1

Seq Scan on taxonomies c_taxonomies_4 (cost=0..7.41 rows=7 width=24) (actual time=0.006..0.062 rows=7 loops=1)

  • Filter: ((NOT c_taxonomies_4.is_deleted) AND (c_taxonomies_4.taxonomy_type_id = 5))
  • Buffers: shared hit=4
122. 0.020 0.805 ↓ 10.0 40 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.746..0.805 rows=40 loops=1)

  • Buffers: shared hit=20
123. 0.086 0.785 ↓ 10.0 40 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.739..0.785 rows=40 loops=1)

  • Buffers: shared hit=20
124. 0.128 0.227 ↑ 1.0 514 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.024..0.227 rows=514 loops=1)

  • Buffers: shared hit=4
125. 0.099 0.099 ↑ 1.0 514 1

Index Only Scan using customers_pkey on customers customers_5 (cost=0.28..25.29 rows=515 width=8) (actual time=0.023..0.099 rows=514 loops=1)

  • Index Cond: (customers_5.id IS NOT NULL)
  • Buffers: shared hit=4
126. 0.031 0.472 ↓ 10.0 40 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.466..0.472 rows=40 loops=1)

  • Sort Key: customer_taxonomies_3.customer_id
  • Sort Method: quicksort Memory: 28kB
  • Buffers: shared hit=16
127. 0.187 0.441 ↓ 10.0 40 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.38..0.441 rows=40 loops=1)

  • Buffers: shared hit=16
128. 0.190 0.190 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_3 (cost=0..23.87 rows=1,187 width=16) (actual time=0.004..0.19 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_3.is_deleted)
  • Buffers: shared hit=12
129. 0.002 0.064 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.064..0.064 rows=1 loops=1)

  • Buffers: shared hit=4
130. 0.062 0.062 ↑ 1.0 1 1

Seq Scan on taxonomies c_taxonomies_3 (cost=0..7.41 rows=1 width=24) (actual time=0.007..0.062 rows=1 loops=1)

  • Filter: ((NOT c_taxonomies_3.is_deleted) AND (c_taxonomies_3.taxonomy_type_id = 4))
  • Buffers: shared hit=4
131. 0.044 19.594 ↓ 6.3 107 1

Materialize (cost=36.58..69.61 rows=17 width=24) (actual time=0.568..19.594 rows=107 loops=1)

  • Buffers: shared hit=20
132. 18.756 19.550 ↓ 6.3 107 1

Merge Join (cost=36.58..69.57 rows=17 width=24) (actual time=0.565..19.55 rows=107 loops=1)

  • Buffers: shared hit=20
133. 0.132 0.261 ↑ 1.0 515 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.049..0.261 rows=515 loops=1)

  • Buffers: shared hit=4
134. 0.129 0.129 ↑ 1.0 515 1

Index Only Scan using customers_pkey on customers customers_6 (cost=0.28..25.29 rows=515 width=8) (actual time=0.048..0.129 rows=515 loops=1)

  • Index Cond: (customers_6.id IS NOT NULL)
  • Buffers: shared hit=4
135. 0.054 0.533 ↓ 6.3 107 1

Sort (cost=36.3..36.34 rows=17 width=24) (actual time=0.515..0.533 rows=107 loops=1)

  • Sort Key: customer_taxonomies_2.customer_id
  • Sort Method: quicksort Memory: 33kB
  • Buffers: shared hit=16
136. 0.200 0.479 ↓ 6.3 107 1

Hash Join (cost=7.46..35.95 rows=17 width=24) (actual time=0.095..0.479 rows=107 loops=1)

  • Buffers: shared hit=16
137. 0.202 0.202 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_2 (cost=0..23.87 rows=1,187 width=16) (actual time=0.004..0.202 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_2.is_deleted)
  • Buffers: shared hit=12
138. 0.008 0.077 ↑ 1.0 4 1

Hash (cost=7.41..7.41 rows=4 width=24) (actual time=0.077..0.077 rows=4 loops=1)

  • Buffers: shared hit=4
139. 0.069 0.069 ↑ 1.0 4 1

Seq Scan on taxonomies c_taxonomies_2 (cost=0..7.41 rows=4 width=24) (actual time=0.013..0.069 rows=4 loops=1)

  • Filter: ((NOT c_taxonomies_2.is_deleted) AND (c_taxonomies_2.taxonomy_type_id = 3))
  • Buffers: shared hit=4
140. 0.004 0.524 ↓ 0.0 0 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.524..0.524 rows=0 loops=1)

  • Buffers: shared hit=19
141. 0.001 0.520 ↓ 0.0 0 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.52..0.52 rows=0 loops=1)

  • Buffers: shared hit=19
142. 0.000 0.019 ↑ 515.0 1 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.019..0.019 rows=1 loops=1)

  • Buffers: shared hit=3
143. 0.020 0.020 ↑ 515.0 1 1

Index Only Scan using customers_pkey on customers customers_7 (cost=0.28..25.29 rows=515 width=8) (actual time=0.019..0.02 rows=1 loops=1)

  • Index Cond: (customers_7.id IS NOT NULL)
  • Buffers: shared hit=3
144. 0.005 0.500 ↓ 0.0 0 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.5..0.5 rows=0 loops=1)

  • Sort Key: customer_taxonomies_7.customer_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=16
145. 0.183 0.495 ↓ 0.0 0 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.495..0.495 rows=0 loops=1)

  • Buffers: shared hit=16
146. 0.246 0.246 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_7 (cost=0..23.87 rows=1,187 width=16) (actual time=0.003..0.246 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_7.is_deleted)
  • Buffers: shared hit=12
147. 0.004 0.066 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.066..0.066 rows=1 loops=1)

  • Buffers: shared hit=4
148. 0.062 0.062 ↑ 1.0 1 1

Seq Scan on taxonomies c_taxonomies_7 (cost=0..7.41 rows=1 width=24) (actual time=0.01..0.062 rows=1 loops=1)

  • Filter: ((NOT c_taxonomies_7.is_deleted) AND (c_taxonomies_7.taxonomy_type_id = 8))
  • Buffers: shared hit=4
149. 0.003 0.479 ↓ 0.0 0 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.479..0.479 rows=0 loops=1)

  • Buffers: shared hit=19
150. 0.000 0.476 ↓ 0.0 0 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.476..0.476 rows=0 loops=1)

  • Buffers: shared hit=19
151. 0.002 0.022 ↑ 515.0 1 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.021..0.022 rows=1 loops=1)

  • Buffers: shared hit=3
152. 0.020 0.020 ↑ 515.0 1 1

Index Only Scan using customers_pkey on customers customers_8 (cost=0.28..25.29 rows=515 width=8) (actual time=0.02..0.02 rows=1 loops=1)

  • Index Cond: (customers_8.id IS NOT NULL)
  • Buffers: shared hit=3
153. 0.009 0.455 ↓ 0.0 0 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.455..0.455 rows=0 loops=1)

  • Sort Key: customer_taxonomies_6.customer_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=16
154. 0.172 0.446 ↓ 0.0 0 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.446..0.446 rows=0 loops=1)

  • Buffers: shared hit=16
155. 0.206 0.206 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_6 (cost=0..23.87 rows=1,187 width=16) (actual time=0.004..0.206 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_6.is_deleted)
  • Buffers: shared hit=12
156. 0.003 0.068 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.068..0.068 rows=1 loops=1)

  • Buffers: shared hit=4
157. 0.065 0.065 ↑ 1.0 1 1

Seq Scan on taxonomies c_taxonomies_6 (cost=0..7.41 rows=1 width=24) (actual time=0.009..0.065 rows=1 loops=1)

  • Filter: ((NOT c_taxonomies_6.is_deleted) AND (c_taxonomies_6.taxonomy_type_id = 7))
  • Buffers: shared hit=4
158. 0.002 0.523 ↓ 0.0 0 1

Materialize (cost=36.58..69.61 rows=17 width=24) (actual time=0.522..0.523 rows=0 loops=1)

  • Buffers: shared hit=19
159. 0.000 0.521 ↓ 0.0 0 1

Merge Join (cost=36.58..69.57 rows=17 width=24) (actual time=0.521..0.521 rows=0 loops=1)

  • Buffers: shared hit=19
160. 0.001 0.019 ↑ 515.0 1 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.019..0.019 rows=1 loops=1)

  • Buffers: shared hit=3
161. 0.018 0.018 ↑ 515.0 1 1

Index Only Scan using customers_pkey on customers customers_9 (cost=0.28..25.29 rows=515 width=8) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: (customers_9.id IS NOT NULL)
  • Buffers: shared hit=3
162. 0.006 0.502 ↓ 0.0 0 1

Sort (cost=36.3..36.34 rows=17 width=24) (actual time=0.501..0.502 rows=0 loops=1)

  • Sort Key: customer_taxonomies_5.customer_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=16
163. 0.219 0.496 ↓ 0.0 0 1

Hash Join (cost=7.46..35.95 rows=17 width=24) (actual time=0.496..0.496 rows=0 loops=1)

  • Buffers: shared hit=16
164. 0.209 0.209 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_5 (cost=0..23.87 rows=1,187 width=16) (actual time=0.002..0.209 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_5.is_deleted)
  • Buffers: shared hit=12
165. 0.003 0.068 ↑ 1.0 4 1

Hash (cost=7.41..7.41 rows=4 width=24) (actual time=0.068..0.068 rows=4 loops=1)

  • Buffers: shared hit=4
166. 0.065 0.065 ↑ 1.0 4 1

Seq Scan on taxonomies c_taxonomies_5 (cost=0..7.41 rows=4 width=24) (actual time=0.01..0.065 rows=4 loops=1)

  • Filter: ((NOT c_taxonomies_5.is_deleted) AND (c_taxonomies_5.taxonomy_type_id = 6))
  • Buffers: shared hit=4
167. 0.006 0.490 ↓ 0.0 0 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.49..0.49 rows=0 loops=1)

  • Buffers: shared hit=19
168. 0.003 0.484 ↓ 0.0 0 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.484..0.484 rows=0 loops=1)

  • Buffers: shared hit=19
169. 0.001 0.023 ↑ 515.0 1 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.023..0.023 rows=1 loops=1)

  • Buffers: shared hit=3
170. 0.022 0.022 ↑ 515.0 1 1

Index Only Scan using customers_pkey on customers customers_10 (cost=0.28..25.29 rows=515 width=8) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: (customers_10.id IS NOT NULL)
  • Buffers: shared hit=3
171. 0.005 0.458 ↓ 0.0 0 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.458..0.458 rows=0 loops=1)

  • Sort Key: customer_taxonomies_9.customer_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=16
172. 0.178 0.453 ↓ 0.0 0 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.453..0.453 rows=0 loops=1)

  • Buffers: shared hit=16
173. 0.193 0.193 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_9 (cost=0..23.87 rows=1,187 width=16) (actual time=0.004..0.193 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_9.is_deleted)
  • Buffers: shared hit=12
174. 0.004 0.082 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.082..0.082 rows=1 loops=1)

  • Buffers: shared hit=4
175. 0.078 0.078 ↑ 1.0 1 1

Seq Scan on taxonomies c_taxonomies_9 (cost=0..7.41 rows=1 width=24) (actual time=0.01..0.078 rows=1 loops=1)

  • Filter: ((NOT c_taxonomies_9.is_deleted) AND (c_taxonomies_9.taxonomy_type_id = 10))
  • Buffers: shared hit=4
176. 0.004 0.491 ↓ 0.0 0 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.491..0.491 rows=0 loops=1)

  • Buffers: shared hit=19
177. 0.002 0.487 ↓ 0.0 0 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.487..0.487 rows=0 loops=1)

  • Buffers: shared hit=19
178. 0.002 0.024 ↑ 515.0 1 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.024..0.024 rows=1 loops=1)

  • Buffers: shared hit=3
179. 0.022 0.022 ↑ 515.0 1 1

Index Only Scan using customers_pkey on customers customers_11 (cost=0.28..25.29 rows=515 width=8) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: (customers_11.id IS NOT NULL)
  • Buffers: shared hit=3
180. 0.005 0.461 ↓ 0.0 0 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.461..0.461 rows=0 loops=1)

  • Sort Key: customer_taxonomies_8.customer_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=16
181. 0.199 0.456 ↓ 0.0 0 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.456..0.456 rows=0 loops=1)

  • Buffers: shared hit=16
182. 0.194 0.194 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_8 (cost=0..23.87 rows=1,187 width=16) (actual time=0.003..0.194 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_8.is_deleted)
  • Buffers: shared hit=12
183. 0.003 0.063 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.063..0.063 rows=1 loops=1)

  • Buffers: shared hit=4
184. 0.060 0.060 ↑ 1.0 1 1

Seq Scan on taxonomies c_taxonomies_8 (cost=0..7.41 rows=1 width=24) (actual time=0.008..0.06 rows=1 loops=1)

  • Filter: ((NOT c_taxonomies_8.is_deleted) AND (c_taxonomies_8.taxonomy_type_id = 9))
  • Buffers: shared hit=4
185. 0.016 0.016 ↓ 1.5 3 1

Seq Scan on tax_types tax_types14 (cost=0..1.03 rows=2 width=40) (actual time=0.015..0.016 rows=3 loops=1)

  • Filter: (NOT tax_types14.is_deleted)
  • Buffers: shared hit=1
186. 0.007 0.007 ↓ 2.0 24 1

Seq Scan on users users (cost=0..1.24 rows=12 width=524) (actual time=0.004..0.007 rows=24 loops=1)

  • Filter: (NOT users.is_deleted)
  • Buffers: shared hit=1
187. 3.427 377.125 ↑ 1.0 14,088 1

Merge Join (cost=3,367.06..10,547.81 rows=14,088 width=168) (actual time=174.008..377.125 rows=14,088 loops=1)

  • Buffers: shared hit=1469
188. 3.442 341.495 ↑ 1.0 14,088 1

Merge Join (cost=3,031.78..9,553.89 rows=14,088 width=152) (actual time=141.803..341.495 rows=14,088 loops=1)

  • Buffers: shared hit=1330
189. 3.101 333.165 ↑ 1.0 14,088 1

Merge Join (cost=2,696.49..8,559.96 rows=14,088 width=136) (actual time=136.914..333.165 rows=14,088 loops=1)

  • Buffers: shared hit=1191
190. 3.204 313.426 ↑ 1.0 14,088 1

Merge Join (cost=2,361.21..7,566.04 rows=14,088 width=120) (actual time=120.273..313.426 rows=14,088 loops=1)

  • Buffers: shared hit=1052
191. 3.092 295.631 ↑ 1.0 14,088 1

Merge Join (cost=2,025.92..6,572.11 rows=14,088 width=104) (actual time=105.68..295.631 rows=14,088 loops=1)

  • Buffers: shared hit=913
192. 3.023 287.376 ↑ 1.0 14,088 1

Merge Join (cost=1,690.64..5,578.19 rows=14,088 width=88) (actual time=100.515..287.376 rows=14,088 loops=1)

  • Buffers: shared hit=774
193. 24.422 257.867 ↑ 1.0 14,088 1

Merge Join (cost=1,355.35..4,584.26 rows=14,088 width=72) (actual time=74.028..257.867 rows=14,088 loops=1)

  • Buffers: shared hit=635
194. 2.745 228.550 ↑ 1.0 14,088 1

Merge Join (cost=1,020.07..3,590.34 rows=14,088 width=56) (actual time=69.131..228.55 rows=14,088 loops=1)

  • Buffers: shared hit=496
195. 66.670 194.662 ↑ 1.0 14,088 1

Merge Join (cost=684.78..2,596.41 rows=14,088 width=40) (actual time=37.987..194.662 rows=14,088 loops=1)

  • Buffers: shared hit=357
196. 2.743 14.040 ↑ 1.0 14,088 1

Merge Join (cost=349.5..1,602.49 rows=14,088 width=24) (actual time=4.679..14.04 rows=14,088 loops=1)

  • Buffers: shared hit=180
197. 3.737 6.653 ↑ 1.0 14,088 1

Unique (cost=0.29..446.04 rows=14,088 width=8) (actual time=0.036..6.653 rows=14,088 loops=1)

  • Buffers: shared hit=41
198. 2.916 2.916 ↑ 1.0 14,088 1

Index Only Scan using drivers_pkey on drivers drivers_1 (cost=0.29..410.82 rows=14,088 width=8) (actual time=0.035..2.916 rows=14,088 loops=1)

  • Index Cond: (drivers_1.id IS NOT NULL)
  • Buffers: shared hit=41
199. 0.005 4.644 ↑ 309.0 1 1

Materialize (cost=349.21..976.48 rows=309 width=24) (actual time=4.641..4.644 rows=1 loops=1)

  • Buffers: shared hit=139
200. 0.018 4.639 ↑ 309.0 1 1

Merge Join (cost=349.21..975.71 rows=309 width=24) (actual time=4.636..4.639 rows=1 loops=1)

  • Buffers: shared hit=139
201. 0.028 0.075 ↑ 129.2 109 1

Unique (cost=0.29..446.04 rows=14,088 width=8) (actual time=0.033..0.075 rows=109 loops=1)

  • Buffers: shared hit=3
202. 0.047 0.047 ↑ 129.2 109 1

Index Only Scan using drivers_pkey on drivers drivers_2 (cost=0.29..410.82 rows=14,088 width=8) (actual time=0.03..0.047 rows=109 loops=1)

  • Index Cond: (drivers_2.id IS NOT NULL)
  • Buffers: shared hit=3
203. 0.014 4.546 ↑ 309.0 1 1

Sort (cost=348.93..349.7 rows=309 width=24) (actual time=4.545..4.546 rows=1 loops=1)

  • Sort Key: driver_taxonomies_1.driver_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=136
204. 2.074 4.532 ↑ 309.0 1 1

Hash Join (cost=7.49..336.15 rows=309 width=24) (actual time=0.13..4.532 rows=1 loops=1)

  • Buffers: shared hit=136
205. 2.383 2.383 ↑ 1.0 14,078 1

Seq Scan on driver_taxonomies driver_taxonomies_1 (cost=0..272.78 rows=14,078 width=16) (actual time=0.007..2.383 rows=14,078 loops=1)

  • Filter: (NOT driver_taxonomies_1.is_deleted)
  • Buffers: shared hit=132
206. 0.004 0.075 ↑ 1.0 6 1

Hash (cost=7.41..7.41 rows=6 width=24) (actual time=0.075..0.075 rows=6 loops=1)

  • Buffers: shared hit=4
207. 0.071 0.071 ↑ 1.0 6 1

Seq Scan on taxonomies d_taxonomies_1 (cost=0..7.41 rows=6 width=24) (actual time=0.067..0.071 rows=6 loops=1)

  • Filter: ((NOT d_taxonomies_1.is_deleted) AND (d_taxonomies_1.taxonomy_type_id = 32))
  • Buffers: shared hit=4
208. 3.861 113.952 ↓ 270.7 14,077 1

Materialize (cost=335.28..958.05 rows=52 width=24) (actual time=33.307..113.952 rows=14,077 loops=1)

  • Buffers: shared hit=177
209. 20.029 110.091 ↓ 270.7 14,077 1

Merge Join (cost=335.28..957.92 rows=52 width=24) (actual time=33.299..110.091 rows=14,077 loops=1)

  • Buffers: shared hit=177
210. 3.678 7.006 ↑ 1.0 14,078 1

Unique (cost=0.29..446.04 rows=14,088 width=8) (actual time=0.021..7.006 rows=14,078 loops=1)

  • Buffers: shared hit=41
211. 3.328 3.328 ↑ 1.0 14,078 1

Index Only Scan using drivers_pkey on drivers drivers_3 (cost=0.29..410.82 rows=14,088 width=8) (actual time=0.02..3.328 rows=14,078 loops=1)

  • Index Cond: (drivers_3.id IS NOT NULL)
  • Buffers: shared hit=41
212. 53.836 83.056 ↓ 270.7 14,077 1

Sort (cost=335..335.13 rows=52 width=24) (actual time=33.275..83.056 rows=14,077 loops=1)

  • Sort Key: driver_taxonomies.driver_id
  • Sort Method: quicksort Memory: 1044kB
  • Buffers: shared hit=136
213. 18.632 29.220 ↓ 270.7 14,077 1

Hash Join (cost=7.42..333.52 rows=52 width=24) (actual time=0.112..29.22 rows=14,077 loops=1)

  • Buffers: shared hit=136
214. 10.493 10.493 ↑ 1.0 14,078 1

Seq Scan on driver_taxonomies driver_taxonomies (cost=0..272.78 rows=14,078 width=16) (actual time=0.004..10.493 rows=14,078 loops=1)

  • Filter: (NOT driver_taxonomies.is_deleted)
  • Buffers: shared hit=132
215. 0.007 0.095 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.095..0.095 rows=1 loops=1)

  • Buffers: shared hit=4
216. 0.088 0.088 ↑ 1.0 1 1

Seq Scan on taxonomies d_taxonomies (cost=0..7.41 rows=1 width=24) (actual time=0.085..0.088 rows=1 loops=1)

  • Filter: ((NOT d_taxonomies.is_deleted) AND (d_taxonomies.taxonomy_type_id = 31))
  • Buffers: shared hit=4
217. 0.002 31.143 ↓ 0.0 0 1

Materialize (cost=335.28..958.05 rows=52 width=24) (actual time=31.143..31.143 rows=0 loops=1)

  • Buffers: shared hit=139
218. 0.001 31.141 ↓ 0.0 0 1

Merge Join (cost=335.28..957.92 rows=52 width=24) (actual time=31.141..31.141 rows=0 loops=1)

  • Buffers: shared hit=139
219. 0.001 0.027 ↑ 14,088.0 1 1

Unique (cost=0.29..446.04 rows=14,088 width=8) (actual time=0.027..0.027 rows=1 loops=1)

  • Buffers: shared hit=3
220. 0.026 0.026 ↑ 14,088.0 1 1

Index Only Scan using drivers_pkey on drivers drivers_4 (cost=0.29..410.82 rows=14,088 width=8) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: (drivers_4.id IS NOT NULL)
  • Buffers: shared hit=3
221. 0.007 31.113 ↓ 0.0 0 1

Sort (cost=335..335.13 rows=52 width=24) (actual time=31.113..31.113 rows=0 loops=1)

  • Sort Key: driver_taxonomies_4.driver_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=136
222. 2.131 31.106 ↓ 0.0 0 1

Hash Join (cost=7.42..333.52 rows=52 width=24) (actual time=31.106..31.106 rows=0 loops=1)

  • Buffers: shared hit=136
223. 28.900 28.900 ↑ 1.0 14,078 1

Seq Scan on driver_taxonomies driver_taxonomies_4 (cost=0..272.78 rows=14,078 width=16) (actual time=0.007..28.9 rows=14,078 loops=1)

  • Filter: (NOT driver_taxonomies_4.is_deleted)
  • Buffers: shared hit=132
224. 0.003 0.075 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.075..0.075 rows=1 loops=1)

  • Buffers: shared hit=4
225. 0.072 0.072 ↑ 1.0 1 1

Seq Scan on taxonomies d_taxonomies_4 (cost=0..7.41 rows=1 width=24) (actual time=0.07..0.072 rows=1 loops=1)

  • Filter: ((NOT d_taxonomies_4.is_deleted) AND (d_taxonomies_4.taxonomy_type_id = 35))
  • Buffers: shared hit=4
226. 0.004 4.895 ↓ 0.0 0 1

Materialize (cost=335.28..958.05 rows=52 width=24) (actual time=4.895..4.895 rows=0 loops=1)

  • Buffers: shared hit=139
227. 0.001 4.891 ↓ 0.0 0 1

Merge Join (cost=335.28..957.92 rows=52 width=24) (actual time=4.891..4.891 rows=0 loops=1)

  • Buffers: shared hit=139
228. 0.001 0.052 ↑ 14,088.0 1 1

Unique (cost=0.29..446.04 rows=14,088 width=8) (actual time=0.052..0.052 rows=1 loops=1)

  • Buffers: shared hit=3
229. 0.051 0.051 ↑ 14,088.0 1 1

Index Only Scan using drivers_pkey on drivers drivers_5 (cost=0.29..410.82 rows=14,088 width=8) (actual time=0.051..0.051 rows=1 loops=1)

  • Index Cond: (drivers_5.id IS NOT NULL)
  • Buffers: shared hit=3
230. 0.008 4.838 ↓ 0.0 0 1

Sort (cost=335..335.13 rows=52 width=24) (actual time=4.838..4.838 rows=0 loops=1)

  • Sort Key: driver_taxonomies_3.driver_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=136
231. 2.141 4.830 ↓ 0.0 0 1

Hash Join (cost=7.42..333.52 rows=52 width=24) (actual time=4.83..4.83 rows=0 loops=1)

  • Buffers: shared hit=136
232. 2.612 2.612 ↑ 1.0 14,078 1

Seq Scan on driver_taxonomies driver_taxonomies_3 (cost=0..272.78 rows=14,078 width=16) (actual time=0.008..2.612 rows=14,078 loops=1)

  • Filter: (NOT driver_taxonomies_3.is_deleted)
  • Buffers: shared hit=132
233. 0.002 0.077 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.077..0.077 rows=1 loops=1)

  • Buffers: shared hit=4
234. 0.075 0.075 ↑ 1.0 1 1

Seq Scan on taxonomies d_taxonomies_3 (cost=0..7.41 rows=1 width=24) (actual time=0.073..0.075 rows=1 loops=1)

  • Filter: ((NOT d_taxonomies_3.is_deleted) AND (d_taxonomies_3.taxonomy_type_id = 34))
  • Buffers: shared hit=4
235. 0.003 26.486 ↓ 0.0 0 1

Materialize (cost=335.28..958.05 rows=52 width=24) (actual time=26.486..26.486 rows=0 loops=1)

  • Buffers: shared hit=139
236. 0.002 26.483 ↓ 0.0 0 1

Merge Join (cost=335.28..957.92 rows=52 width=24) (actual time=26.483..26.483 rows=0 loops=1)

  • Buffers: shared hit=139
237. 0.002 0.026 ↑ 14,088.0 1 1

Unique (cost=0.29..446.04 rows=14,088 width=8) (actual time=0.026..0.026 rows=1 loops=1)

  • Buffers: shared hit=3
238. 0.024 0.024 ↑ 14,088.0 1 1

Index Only Scan using drivers_pkey on drivers drivers_6 (cost=0.29..410.82 rows=14,088 width=8) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: (drivers_6.id IS NOT NULL)
  • Buffers: shared hit=3
239. 0.006 26.455 ↓ 0.0 0 1

Sort (cost=335..335.13 rows=52 width=24) (actual time=26.455..26.455 rows=0 loops=1)

  • Sort Key: driver_taxonomies_2.driver_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=136
240. 2.316 26.449 ↓ 0.0 0 1

Hash Join (cost=7.42..333.52 rows=52 width=24) (actual time=26.449..26.449 rows=0 loops=1)

  • Buffers: shared hit=136
241. 24.064 24.064 ↑ 1.0 14,078 1

Seq Scan on driver_taxonomies driver_taxonomies_2 (cost=0..272.78 rows=14,078 width=16) (actual time=0.006..24.064 rows=14,078 loops=1)

  • Filter: (NOT driver_taxonomies_2.is_deleted)
  • Buffers: shared hit=132
242. 0.005 0.069 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.069..0.069 rows=1 loops=1)

  • Buffers: shared hit=4
243. 0.064 0.064 ↑ 1.0 1 1

Seq Scan on taxonomies d_taxonomies_2 (cost=0..7.41 rows=1 width=24) (actual time=0.063..0.064 rows=1 loops=1)

  • Filter: ((NOT d_taxonomies_2.is_deleted) AND (d_taxonomies_2.taxonomy_type_id = 33))
  • Buffers: shared hit=4
244. 0.004 5.163 ↓ 0.0 0 1

Materialize (cost=335.28..958.05 rows=52 width=24) (actual time=5.163..5.163 rows=0 loops=1)

  • Buffers: shared hit=139
245. 0.001 5.159 ↓ 0.0 0 1

Merge Join (cost=335.28..957.92 rows=52 width=24) (actual time=5.159..5.159 rows=0 loops=1)

  • Buffers: shared hit=139
246. 0.002 0.032 ↑ 14,088.0 1 1

Unique (cost=0.29..446.04 rows=14,088 width=8) (actual time=0.032..0.032 rows=1 loops=1)

  • Buffers: shared hit=3
247. 0.030 0.030 ↑ 14,088.0 1 1

Index Only Scan using drivers_pkey on drivers drivers_7 (cost=0.29..410.82 rows=14,088 width=8) (actual time=0.03..0.03 rows=1 loops=1)

  • Index Cond: (drivers_7.id IS NOT NULL)
  • Buffers: shared hit=3
248. 0.011 5.126 ↓ 0.0 0 1

Sort (cost=335..335.13 rows=52 width=24) (actual time=5.126..5.126 rows=0 loops=1)

  • Sort Key: driver_taxonomies_7.driver_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=136
249. 2.107 5.115 ↓ 0.0 0 1

Hash Join (cost=7.42..333.52 rows=52 width=24) (actual time=5.115..5.115 rows=0 loops=1)

  • Buffers: shared hit=136
250. 2.932 2.932 ↑ 1.0 14,078 1

Seq Scan on driver_taxonomies driver_taxonomies_7 (cost=0..272.78 rows=14,078 width=16) (actual time=0.008..2.932 rows=14,078 loops=1)

  • Filter: (NOT driver_taxonomies_7.is_deleted)
  • Buffers: shared hit=132
251. 0.005 0.076 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.076..0.076 rows=1 loops=1)

  • Buffers: shared hit=4
252. 0.071 0.071 ↑ 1.0 1 1

Seq Scan on taxonomies d_taxonomies_7 (cost=0..7.41 rows=1 width=24) (actual time=0.07..0.071 rows=1 loops=1)

  • Filter: ((NOT d_taxonomies_7.is_deleted) AND (d_taxonomies_7.taxonomy_type_id = 38))
  • Buffers: shared hit=4
253. 0.016 14.591 ↓ 0.0 0 1

Materialize (cost=335.28..958.05 rows=52 width=24) (actual time=14.591..14.591 rows=0 loops=1)

  • Buffers: shared hit=139
254. 0.002 14.575 ↓ 0.0 0 1

Merge Join (cost=335.28..957.92 rows=52 width=24) (actual time=14.575..14.575 rows=0 loops=1)

  • Buffers: shared hit=139
255. 0.000 0.026 ↑ 14,088.0 1 1

Unique (cost=0.29..446.04 rows=14,088 width=8) (actual time=0.026..0.026 rows=1 loops=1)

  • Buffers: shared hit=3
256. 0.026 0.026 ↑ 14,088.0 1 1

Index Only Scan using drivers_pkey on drivers drivers_8 (cost=0.29..410.82 rows=14,088 width=8) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: (drivers_8.id IS NOT NULL)
  • Buffers: shared hit=3
257. 0.012 14.547 ↓ 0.0 0 1

Sort (cost=335..335.13 rows=52 width=24) (actual time=14.547..14.547 rows=0 loops=1)

  • Sort Key: driver_taxonomies_6.driver_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=136
258. 11.905 14.535 ↓ 0.0 0 1

Hash Join (cost=7.42..333.52 rows=52 width=24) (actual time=14.535..14.535 rows=0 loops=1)

  • Buffers: shared hit=136
259. 2.550 2.550 ↑ 1.0 14,078 1

Seq Scan on driver_taxonomies driver_taxonomies_6 (cost=0..272.78 rows=14,078 width=16) (actual time=0.006..2.55 rows=14,078 loops=1)

  • Filter: (NOT driver_taxonomies_6.is_deleted)
  • Buffers: shared hit=132
260. 0.003 0.080 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.08..0.08 rows=1 loops=1)

  • Buffers: shared hit=4
261. 0.077 0.077 ↑ 1.0 1 1

Seq Scan on taxonomies d_taxonomies_6 (cost=0..7.41 rows=1 width=24) (actual time=0.076..0.077 rows=1 loops=1)

  • Filter: ((NOT d_taxonomies_6.is_deleted) AND (d_taxonomies_6.taxonomy_type_id = 37))
  • Buffers: shared hit=4
262. 0.009 16.638 ↓ 0.0 0 1

Materialize (cost=335.28..958.05 rows=52 width=24) (actual time=16.638..16.638 rows=0 loops=1)

  • Buffers: shared hit=139
263. 0.001 16.629 ↓ 0.0 0 1

Merge Join (cost=335.28..957.92 rows=52 width=24) (actual time=16.629..16.629 rows=0 loops=1)

  • Buffers: shared hit=139
264. 0.001 0.026 ↑ 14,088.0 1 1

Unique (cost=0.29..446.04 rows=14,088 width=8) (actual time=0.026..0.026 rows=1 loops=1)

  • Buffers: shared hit=3
265. 0.025 0.025 ↑ 14,088.0 1 1

Index Only Scan using drivers_pkey on drivers drivers_9 (cost=0.29..410.82 rows=14,088 width=8) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: (drivers_9.id IS NOT NULL)
  • Buffers: shared hit=3
266. 0.017 16.602 ↓ 0.0 0 1

Sort (cost=335..335.13 rows=52 width=24) (actual time=16.602..16.602 rows=0 loops=1)

  • Sort Key: driver_taxonomies_5.driver_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=136
267. 2.276 16.585 ↓ 0.0 0 1

Hash Join (cost=7.42..333.52 rows=52 width=24) (actual time=16.585..16.585 rows=0 loops=1)

  • Buffers: shared hit=136
268. 14.239 14.239 ↑ 1.0 14,078 1

Seq Scan on driver_taxonomies driver_taxonomies_5 (cost=0..272.78 rows=14,078 width=16) (actual time=0.006..14.239 rows=14,078 loops=1)

  • Filter: (NOT driver_taxonomies_5.is_deleted)
  • Buffers: shared hit=132
269. 0.002 0.070 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.07..0.07 rows=1 loops=1)

  • Buffers: shared hit=4
270. 0.068 0.068 ↑ 1.0 1 1

Seq Scan on taxonomies d_taxonomies_5 (cost=0..7.41 rows=1 width=24) (actual time=0.067..0.068 rows=1 loops=1)

  • Filter: ((NOT d_taxonomies_5.is_deleted) AND (d_taxonomies_5.taxonomy_type_id = 36))
  • Buffers: shared hit=4
271. 0.007 4.888 ↓ 0.0 0 1

Materialize (cost=335.28..958.05 rows=52 width=24) (actual time=4.888..4.888 rows=0 loops=1)

  • Buffers: shared hit=139
272. 0.002 4.881 ↓ 0.0 0 1

Merge Join (cost=335.28..957.92 rows=52 width=24) (actual time=4.88..4.881 rows=0 loops=1)

  • Buffers: shared hit=139
273. 0.002 0.025 ↑ 14,088.0 1 1

Unique (cost=0.29..446.04 rows=14,088 width=8) (actual time=0.025..0.025 rows=1 loops=1)

  • Buffers: shared hit=3
274. 0.023 0.023 ↑ 14,088.0 1 1

Index Only Scan using drivers_pkey on drivers drivers_10 (cost=0.29..410.82 rows=14,088 width=8) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: (drivers_10.id IS NOT NULL)
  • Buffers: shared hit=3
275. 0.011 4.854 ↓ 0.0 0 1

Sort (cost=335..335.13 rows=52 width=24) (actual time=4.854..4.854 rows=0 loops=1)

  • Sort Key: driver_taxonomies_9.driver_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=136
276. 2.094 4.843 ↓ 0.0 0 1

Hash Join (cost=7.42..333.52 rows=52 width=24) (actual time=4.842..4.843 rows=0 loops=1)

  • Buffers: shared hit=136
277. 2.677 2.677 ↑ 1.0 14,078 1

Seq Scan on driver_taxonomies driver_taxonomies_9 (cost=0..272.78 rows=14,078 width=16) (actual time=0.008..2.677 rows=14,078 loops=1)

  • Filter: (NOT driver_taxonomies_9.is_deleted)
  • Buffers: shared hit=132
278. 0.002 0.072 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.072..0.072 rows=1 loops=1)

  • Buffers: shared hit=4
279. 0.070 0.070 ↑ 1.0 1 1

Seq Scan on taxonomies d_taxonomies_9 (cost=0..7.41 rows=1 width=24) (actual time=0.069..0.07 rows=1 loops=1)

  • Filter: ((NOT d_taxonomies_9.is_deleted) AND (d_taxonomies_9.taxonomy_type_id = 40))
  • Buffers: shared hit=4
280. 0.007 32.203 ↓ 0.0 0 1

Materialize (cost=335.28..958.05 rows=52 width=24) (actual time=32.203..32.203 rows=0 loops=1)

  • Buffers: shared hit=139
281. 0.001 32.196 ↓ 0.0 0 1

Merge Join (cost=335.28..957.92 rows=52 width=24) (actual time=32.196..32.196 rows=0 loops=1)

  • Buffers: shared hit=139
282. 0.001 0.026 ↑ 14,088.0 1 1

Unique (cost=0.29..446.04 rows=14,088 width=8) (actual time=0.026..0.026 rows=1 loops=1)

  • Buffers: shared hit=3
283. 0.025 0.025 ↑ 14,088.0 1 1

Index Only Scan using drivers_pkey on drivers drivers_11 (cost=0.29..410.82 rows=14,088 width=8) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: (drivers_11.id IS NOT NULL)
  • Buffers: shared hit=3
284. 0.010 32.169 ↓ 0.0 0 1

Sort (cost=335..335.13 rows=52 width=24) (actual time=32.169..32.169 rows=0 loops=1)

  • Sort Key: driver_taxonomies_8.driver_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=136
285. 29.553 32.159 ↓ 0.0 0 1

Hash Join (cost=7.42..333.52 rows=52 width=24) (actual time=32.159..32.159 rows=0 loops=1)

  • Buffers: shared hit=136
286. 2.523 2.523 ↑ 1.0 14,078 1

Seq Scan on driver_taxonomies driver_taxonomies_8 (cost=0..272.78 rows=14,078 width=16) (actual time=0.007..2.523 rows=14,078 loops=1)

  • Filter: (NOT driver_taxonomies_8.is_deleted)
  • Buffers: shared hit=132
287. 0.008 0.083 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.083..0.083 rows=1 loops=1)

  • Buffers: shared hit=4
288. 0.075 0.075 ↑ 1.0 1 1

Seq Scan on taxonomies d_taxonomies_8 (cost=0..7.41 rows=1 width=24) (actual time=0.074..0.075 rows=1 loops=1)

  • Filter: ((NOT d_taxonomies_8.is_deleted) AND (d_taxonomies_8.taxonomy_type_id = 39))
  • Buffers: shared hit=4
289. 22.254 69.423 ↑ 1.0 2,927 1

Merge Join (cost=808.19..1,279.93 rows=2,927 width=168) (actual time=38.04..69.423 rows=2,927 loops=1)

  • Buffers: shared hit=200
290. 0.602 46.972 ↑ 1.0 2,927 1

Merge Join (cost=711.31..1,175.71 rows=2,927 width=152) (actual time=37.841..46.972 rows=2,927 loops=1)

  • Buffers: shared hit=179
291. 0.641 46.174 ↑ 1.0 2,927 1

Merge Join (cost=614.42..1,071.49 rows=2,927 width=136) (actual time=37.644..46.174 rows=2,927 loops=1)

  • Buffers: shared hit=158
292. 0.582 45.337 ↑ 1.0 2,927 1

Merge Join (cost=517.54..967.27 rows=2,927 width=120) (actual time=37.447..45.337 rows=2,927 loops=1)

  • Buffers: shared hit=137
293. 0.595 44.526 ↑ 1.0 2,927 1

Merge Join (cost=420.65..863.05 rows=2,927 width=104) (actual time=37.217..44.526 rows=2,927 loops=1)

  • Buffers: shared hit=116
294. 0.562 14.430 ↑ 1.0 2,927 1

Merge Join (cost=323.77..758.83 rows=2,927 width=88) (actual time=7.714..14.43 rows=2,927 loops=1)

  • Buffers: shared hit=95
295. 0.949 13.447 ↑ 1.0 2,927 1

Merge Join (cost=307.31..599.72 rows=2,927 width=72) (actual time=7.294..13.447 rows=2,927 loops=1)

  • Buffers: shared hit=83
296. 0.568 9.839 ↑ 1.0 2,927 1

Merge Join (cost=290.93..440.75 rows=2,927 width=56) (actual time=6.83..9.839 rows=2,927 loops=1)

  • Buffers: shared hit=65
297. 0.522 9.061 ↑ 1.0 2,927 1

Merge Join (cost=194.05..336.53 rows=2,927 width=40) (actual time=6.614..9.061 rows=2,927 loops=1)

  • Buffers: shared hit=44
298. 0.554 5.248 ↑ 1.0 2,927 1

Merge Join (cost=97.16..232.31 rows=2,927 width=24) (actual time=3.321..5.248 rows=2,927 loops=1)

  • Buffers: shared hit=27
299. 0.768 1.455 ↑ 1.0 2,927 1

Unique (cost=0.28..98.82 rows=2,927 width=8) (actual time=0.08..1.455 rows=2,927 loops=1)

  • Buffers: shared hit=10
300. 0.687 0.687 ↑ 1.0 2,927 1

Index Only Scan using associates_pkey on associates associates (cost=0.28..91.5 rows=2,927 width=8) (actual time=0.079..0.687 rows=2,927 loops=1)

  • Index Cond: (associates.id IS NOT NULL)
  • Buffers: shared hit=10
301. 0.008 3.239 ↓ 0.0 0 1

Sort (cost=96.88..96.89 rows=1 width=24) (actual time=3.239..3.239 rows=0 loops=1)

  • Sort Key: associates_1.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=17
302. 0.634 3.231 ↓ 0.0 0 1

Merge Join (cost=22.84..96.87 rows=1 width=24) (actual time=3.231..3.231 rows=0 loops=1)

  • Buffers: shared hit=17
303. 0.010 0.010 ↑ 329.0 1 1

Index Scan using associate_taxonomies_taxonomy_id_idx on associate_taxonomies associate_taxonomies_1 (cost=0.15..24.92 rows=329 width=16) (actual time=0.01..0.01 rows=1 loops=1)

  • Filter: (NOT associate_taxonomies_1.is_deleted)
  • Buffers: shared hit=2
304. 0.735 2.587 ↑ 1.0 2,927 1

Materialize (cost=0.43..184.6 rows=2,927 width=32) (actual time=0.044..2.587 rows=2,927 loops=1)

  • Buffers: shared hit=15
305. 0.460 1.852 ↑ 1.0 2,927 1

Nested Loop (cost=0.43..177.29 rows=2,927 width=32) (actual time=0.041..1.852 rows=2,927 loops=1)

  • Buffers: shared hit=15
306. 0.107 0.107 ↑ 1.0 1 1

Index Scan using taxonomies_pkey on taxonomies a_taxonomies_1 (cost=0.15..19.93 rows=1 width=24) (actual time=0.02..0.107 rows=1 loops=1)

  • Filter: ((NOT a_taxonomies_1.is_deleted) AND (a_taxonomies_1.taxonomy_type_id = 12))
  • Buffers: shared hit=5
307. 0.703 1.285 ↑ 1.0 2,927 1

Unique (cost=0.28..98.82 rows=2,927 width=8) (actual time=0.02..1.285 rows=2,927 loops=1)

  • Buffers: shared hit=10
308. 0.582 0.582 ↑ 1.0 2,927 1

Index Only Scan using associates_pkey on associates associates_1 (cost=0.28..91.5 rows=2,927 width=8) (actual time=0.02..0.582 rows=2,927 loops=1)

  • Index Cond: (associates_1.id IS NOT NULL)
  • Buffers: shared hit=10
309. 0.008 3.291 ↓ 0.0 0 1

Sort (cost=96.88..96.89 rows=1 width=24) (actual time=3.291..3.291 rows=0 loops=1)

  • Sort Key: associates_2.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=17
310. 0.660 3.283 ↓ 0.0 0 1

Merge Join (cost=22.84..96.87 rows=1 width=24) (actual time=3.283..3.283 rows=0 loops=1)

  • Buffers: shared hit=17
311. 0.008 0.008 ↑ 329.0 1 1

Index Scan using associate_taxonomies_taxonomy_id_idx on associate_taxonomies associate_taxonomies (cost=0.15..24.92 rows=329 width=16) (actual time=0.008..0.008 rows=1 loops=1)

  • Filter: (NOT associate_taxonomies.is_deleted)
  • Buffers: shared hit=2
312. 0.718 2.615 ↑ 1.0 2,927 1

Materialize (cost=0.43..184.6 rows=2,927 width=32) (actual time=0.045..2.615 rows=2,927 loops=1)

  • Buffers: shared hit=15
313. 0.509 1.897 ↑ 1.0 2,927 1

Nested Loop (cost=0.43..177.29 rows=2,927 width=32) (actual time=0.043..1.897 rows=2,927 loops=1)

  • Buffers: shared hit=15
314. 0.107 0.107 ↑ 1.0 1 1

Index Scan using taxonomies_pkey on taxonomies a_taxonomies (cost=0.15..19.93 rows=1 width=24) (actual time=0.022..0.107 rows=1 loops=1)

  • Filter: ((NOT a_taxonomies.is_deleted) AND (a_taxonomies.taxonomy_type_id = 11))
  • Buffers: shared hit=5
315. 0.678 1.281 ↑ 1.0 2,927 1

Unique (cost=0.28..98.82 rows=2,927 width=8) (actual time=0.019..1.281 rows=2,927 loops=1)

  • Buffers: shared hit=10
316. 0.603 0.603 ↑ 1.0 2,927 1

Index Only Scan using associates_pkey on associates associates_2 (cost=0.28..91.5 rows=2,927 width=8) (actual time=0.019..0.603 rows=2,927 loops=1)

  • Index Cond: (associates_2.id IS NOT NULL)
  • Buffers: shared hit=10
317. 0.016 0.210 ↓ 0.0 0 1

Sort (cost=96.88..96.89 rows=1 width=24) (actual time=0.21..0.21 rows=0 loops=1)

  • Sort Key: associates_3.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=21
318. 0.039 0.194 ↓ 0.0 0 1

Merge Join (cost=22.84..96.87 rows=1 width=24) (actual time=0.194..0.194 rows=0 loops=1)

  • Buffers: shared hit=21
319. 0.112 0.112 ↑ 1.0 329 1

Index Scan using associate_taxonomies_taxonomy_id_idx on associate_taxonomies associate_taxonomies_4 (cost=0.15..24.92 rows=329 width=16) (actual time=0.008..0.112 rows=329 loops=1)

  • Filter: (NOT associate_taxonomies_4.is_deleted)
  • Buffers: shared hit=16
320. 0.003 0.043 ↑ 2,927.0 1 1

Materialize (cost=0.43..184.6 rows=2,927 width=32) (actual time=0.043..0.043 rows=1 loops=1)

  • Buffers: shared hit=5
321. 0.001 0.040 ↑ 2,927.0 1 1

Nested Loop (cost=0.43..177.29 rows=2,927 width=32) (actual time=0.04..0.04 rows=1 loops=1)

  • Buffers: shared hit=5
322. 0.021 0.021 ↑ 1.0 1 1

Index Scan using taxonomies_pkey on taxonomies a_taxonomies_4 (cost=0.15..19.93 rows=1 width=24) (actual time=0.021..0.021 rows=1 loops=1)

  • Filter: ((NOT a_taxonomies_4.is_deleted) AND (a_taxonomies_4.taxonomy_type_id = 15))
  • Buffers: shared hit=2
323. 0.000 0.018 ↑ 2,927.0 1 1

Unique (cost=0.28..98.82 rows=2,927 width=8) (actual time=0.018..0.018 rows=1 loops=1)

  • Buffers: shared hit=3
324. 0.018 0.018 ↑ 2,927.0 1 1

Index Only Scan using associates_pkey on associates associates_3 (cost=0.28..91.5 rows=2,927 width=8) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: (associates_3.id IS NOT NULL)
  • Buffers: shared hit=3
325. 0.108 2.659 ↓ 65.6 328 1

Materialize (cost=16.37..151.59 rows=5 width=24) (actual time=0.464..2.659 rows=328 loops=1)

  • Buffers: shared hit=18
326. 0.542 2.551 ↓ 65.6 328 1

Merge Join (cost=16.37..151.58 rows=5 width=24) (actual time=0.461..2.551 rows=328 loops=1)

  • Buffers: shared hit=18
327. 0.877 1.505 ↑ 1.0 2,919 1

Unique (cost=0.28..98.82 rows=2,927 width=8) (actual time=0.018..1.505 rows=2,919 loops=1)

  • Buffers: shared hit=10
328. 0.628 0.628 ↑ 1.0 2,919 1

Index Only Scan using associates_pkey on associates associates_4 (cost=0.28..91.5 rows=2,927 width=8) (actual time=0.018..0.628 rows=2,919 loops=1)

  • Index Cond: (associates_4.id IS NOT NULL)
  • Buffers: shared hit=10
329. 0.182 0.504 ↓ 65.6 328 1

Sort (cost=16.09..16.11 rows=5 width=24) (actual time=0.439..0.504 rows=328 loops=1)

  • Sort Key: associate_taxonomies_3.associate_id
  • Sort Method: quicksort Memory: 50kB
  • Buffers: shared hit=8
330. 0.146 0.322 ↓ 65.6 328 1

Hash Join (cost=7.46..16.04 rows=5 width=24) (actual time=0.139..0.322 rows=328 loops=1)

  • Buffers: shared hit=8
331. 0.086 0.086 ↑ 1.0 329 1

Seq Scan on associate_taxonomies associate_taxonomies_3 (cost=0..7.29 rows=329 width=16) (actual time=0.032..0.086 rows=329 loops=1)

  • Filter: (NOT associate_taxonomies_3.is_deleted)
  • Buffers: shared hit=4
332. 0.023 0.090 ↑ 1.0 4 1

Hash (cost=7.41..7.41 rows=4 width=24) (actual time=0.09..0.09 rows=4 loops=1)

  • Buffers: shared hit=4
333. 0.067 0.067 ↑ 1.0 4 1

Seq Scan on taxonomies a_taxonomies_3 (cost=0..7.41 rows=4 width=24) (actual time=0.015..0.067 rows=4 loops=1)

  • Filter: ((NOT a_taxonomies_3.is_deleted) AND (a_taxonomies_3.taxonomy_type_id = 14))
  • Buffers: shared hit=4
334. 0.003 0.421 ↑ 7.0 1 1

Materialize (cost=16.46..151.71 rows=7 width=24) (actual time=0.419..0.421 rows=1 loops=1)

  • Buffers: shared hit=12
335. 0.059 0.418 ↑ 7.0 1 1

Merge Join (cost=16.46..151.69 rows=7 width=24) (actual time=0.416..0.418 rows=1 loops=1)

  • Buffers: shared hit=12
336. 0.090 0.174 ↑ 7.6 385 1

Unique (cost=0.28..98.82 rows=2,927 width=8) (actual time=0.019..0.174 rows=385 loops=1)

  • Buffers: shared hit=4
337. 0.084 0.084 ↑ 7.6 385 1

Index Only Scan using associates_pkey on associates associates_5 (cost=0.28..91.5 rows=2,927 width=8) (actual time=0.019..0.084 rows=385 loops=1)

  • Index Cond: (associates_5.id IS NOT NULL)
  • Buffers: shared hit=4
338. 0.006 0.185 ↑ 7.0 1 1

Sort (cost=16.18..16.2 rows=7 width=24) (actual time=0.185..0.185 rows=1 loops=1)

  • Sort Key: associate_taxonomies_2.associate_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=8
339. 0.057 0.179 ↑ 7.0 1 1

Hash Join (cost=7.49..16.08 rows=7 width=24) (actual time=0.179..0.179 rows=1 loops=1)

  • Buffers: shared hit=8
340. 0.054 0.054 ↑ 1.0 329 1

Seq Scan on associate_taxonomies associate_taxonomies_2 (cost=0..7.29 rows=329 width=16) (actual time=0.003..0.054 rows=329 loops=1)

  • Filter: (NOT associate_taxonomies_2.is_deleted)
  • Buffers: shared hit=4
341. 0.005 0.068 ↑ 1.0 6 1

Hash (cost=7.41..7.41 rows=6 width=24) (actual time=0.068..0.068 rows=6 loops=1)

  • Buffers: shared hit=4
342. 0.063 0.063 ↑ 1.0 6 1

Seq Scan on taxonomies a_taxonomies_2 (cost=0..7.41 rows=6 width=24) (actual time=0.01..0.063 rows=6 loops=1)

  • Filter: ((NOT a_taxonomies_2.is_deleted) AND (a_taxonomies_2.taxonomy_type_id = 13))
  • Buffers: shared hit=4
343. 0.006 29.501 ↓ 0.0 0 1

Sort (cost=96.88..96.89 rows=1 width=24) (actual time=29.501..29.501 rows=0 loops=1)

  • Sort Key: associates_6.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=21
344. 0.057 29.495 ↓ 0.0 0 1

Merge Join (cost=22.84..96.87 rows=1 width=24) (actual time=29.495..29.495 rows=0 loops=1)

  • Buffers: shared hit=21
345. 29.396 29.396 ↑ 1.0 329 1

Index Scan using associate_taxonomies_taxonomy_id_idx on associate_taxonomies associate_taxonomies_7 (cost=0.15..24.92 rows=329 width=16) (actual time=0.008..29.396 rows=329 loops=1)

  • Filter: (NOT associate_taxonomies_7.is_deleted)
  • Buffers: shared hit=16
346. 0.002 0.042 ↑ 2,927.0 1 1

Materialize (cost=0.43..184.6 rows=2,927 width=32) (actual time=0.042..0.042 rows=1 loops=1)

  • Buffers: shared hit=5
347. 0.001 0.040 ↑ 2,927.0 1 1

Nested Loop (cost=0.43..177.29 rows=2,927 width=32) (actual time=0.04..0.04 rows=1 loops=1)

  • Buffers: shared hit=5
348. 0.020 0.020 ↑ 1.0 1 1

Index Scan using taxonomies_pkey on taxonomies a_taxonomies_7 (cost=0.15..19.93 rows=1 width=24) (actual time=0.02..0.02 rows=1 loops=1)

  • Filter: ((NOT a_taxonomies_7.is_deleted) AND (a_taxonomies_7.taxonomy_type_id = 18))
  • Buffers: shared hit=2
349. 0.001 0.019 ↑ 2,927.0 1 1

Unique (cost=0.28..98.82 rows=2,927 width=8) (actual time=0.019..0.019 rows=1 loops=1)

  • Buffers: shared hit=3
350. 0.018 0.018 ↑ 2,927.0 1 1

Index Only Scan using associates_pkey on associates associates_6 (cost=0.28..91.5 rows=2,927 width=8) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: (associates_6.id IS NOT NULL)
  • Buffers: shared hit=3
351. 0.020 0.229 ↓ 0.0 0 1

Sort (cost=96.88..96.89 rows=1 width=24) (actual time=0.229..0.229 rows=0 loops=1)

  • Sort Key: associates_7.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=21
352. 0.039 0.209 ↓ 0.0 0 1

Merge Join (cost=22.84..96.87 rows=1 width=24) (actual time=0.209..0.209 rows=0 loops=1)

  • Buffers: shared hit=21
353. 0.111 0.111 ↑ 1.0 329 1

Index Scan using associate_taxonomies_taxonomy_id_idx on associate_taxonomies associate_taxonomies_6 (cost=0.15..24.92 rows=329 width=16) (actual time=0.008..0.111 rows=329 loops=1)

  • Filter: (NOT associate_taxonomies_6.is_deleted)
  • Buffers: shared hit=16
354. 0.004 0.059 ↑ 2,927.0 1 1

Materialize (cost=0.43..184.6 rows=2,927 width=32) (actual time=0.058..0.059 rows=1 loops=1)

  • Buffers: shared hit=5
355. 0.003 0.055 ↑ 2,927.0 1 1

Nested Loop (cost=0.43..177.29 rows=2,927 width=32) (actual time=0.055..0.055 rows=1 loops=1)

  • Buffers: shared hit=5
356. 0.023 0.023 ↑ 1.0 1 1

Index Scan using taxonomies_pkey on taxonomies a_taxonomies_6 (cost=0.15..19.93 rows=1 width=24) (actual time=0.023..0.023 rows=1 loops=1)

  • Filter: ((NOT a_taxonomies_6.is_deleted) AND (a_taxonomies_6.taxonomy_type_id = 17))
  • Buffers: shared hit=2
357. 0.002 0.029 ↑ 2,927.0 1 1

Unique (cost=0.28..98.82 rows=2,927 width=8) (actual time=0.029..0.029 rows=1 loops=1)

  • Buffers: shared hit=3
358. 0.027 0.027 ↑ 2,927.0 1 1

Index Only Scan using associates_pkey on associates associates_7 (cost=0.28..91.5 rows=2,927 width=8) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: (associates_7.id IS NOT NULL)
  • Buffers: shared hit=3
359. 0.006 0.196 ↓ 0.0 0 1

Sort (cost=96.88..96.89 rows=1 width=24) (actual time=0.196..0.196 rows=0 loops=1)

  • Sort Key: associates_8.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=21
360. 0.044 0.190 ↓ 0.0 0 1

Merge Join (cost=22.84..96.87 rows=1 width=24) (actual time=0.19..0.19 rows=0 loops=1)

  • Buffers: shared hit=21
361. 0.103 0.103 ↑ 1.0 329 1

Index Scan using associate_taxonomies_taxonomy_id_idx on associate_taxonomies associate_taxonomies_5 (cost=0.15..24.92 rows=329 width=16) (actual time=0.007..0.103 rows=329 loops=1)

  • Filter: (NOT associate_taxonomies_5.is_deleted)
  • Buffers: shared hit=16
362. 0.003 0.043 ↑ 2,927.0 1 1

Materialize (cost=0.43..184.6 rows=2,927 width=32) (actual time=0.043..0.043 rows=1 loops=1)

  • Buffers: shared hit=5
363. 0.000 0.040 ↑ 2,927.0 1 1

Nested Loop (cost=0.43..177.29 rows=2,927 width=32) (actual time=0.04..0.04 rows=1 loops=1)

  • Buffers: shared hit=5
364. 0.020 0.020 ↑ 1.0 1 1

Index Scan using taxonomies_pkey on taxonomies a_taxonomies_5 (cost=0.15..19.93 rows=1 width=24) (actual time=0.02..0.02 rows=1 loops=1)

  • Filter: ((NOT a_taxonomies_5.is_deleted) AND (a_taxonomies_5.taxonomy_type_id = 16))
  • Buffers: shared hit=2
365. 0.000 0.020 ↑ 2,927.0 1 1

Unique (cost=0.28..98.82 rows=2,927 width=8) (actual time=0.02..0.02 rows=1 loops=1)

  • Buffers: shared hit=3
366. 0.020 0.020 ↑ 2,927.0 1 1

Index Only Scan using associates_pkey on associates associates_8 (cost=0.28..91.5 rows=2,927 width=8) (actual time=0.02..0.02 rows=1 loops=1)

  • Index Cond: (associates_8.id IS NOT NULL)
  • Buffers: shared hit=3
367. 0.005 0.196 ↓ 0.0 0 1

Sort (cost=96.88..96.89 rows=1 width=24) (actual time=0.196..0.196 rows=0 loops=1)

  • Sort Key: associates_9.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=21
368. 0.044 0.191 ↓ 0.0 0 1

Merge Join (cost=22.84..96.87 rows=1 width=24) (actual time=0.191..0.191 rows=0 loops=1)

  • Buffers: shared hit=21
369. 0.103 0.103 ↑ 1.0 329 1

Index Scan using associate_taxonomies_taxonomy_id_idx on associate_taxonomies associate_taxonomies_9 (cost=0.15..24.92 rows=329 width=16) (actual time=0.006..0.103 rows=329 loops=1)

  • Filter: (NOT associate_taxonomies_9.is_deleted)
  • Buffers: shared hit=16
370. 0.002 0.044 ↑ 2,927.0 1 1

Materialize (cost=0.43..184.6 rows=2,927 width=32) (actual time=0.044..0.044 rows=1 loops=1)

  • Buffers: shared hit=5
371. 0.000 0.042 ↑ 2,927.0 1 1

Nested Loop (cost=0.43..177.29 rows=2,927 width=32) (actual time=0.042..0.042 rows=1 loops=1)

  • Buffers: shared hit=5
372. 0.023 0.023 ↑ 1.0 1 1

Index Scan using taxonomies_pkey on taxonomies a_taxonomies_9 (cost=0.15..19.93 rows=1 width=24) (actual time=0.023..0.023 rows=1 loops=1)

  • Filter: ((NOT a_taxonomies_9.is_deleted) AND (a_taxonomies_9.taxonomy_type_id = 20))
  • Buffers: shared hit=2
373. 0.000 0.019 ↑ 2,927.0 1 1

Unique (cost=0.28..98.82 rows=2,927 width=8) (actual time=0.019..0.019 rows=1 loops=1)

  • Buffers: shared hit=3
374. 0.019 0.019 ↑ 2,927.0 1 1

Index Only Scan using associates_pkey on associates associates_9 (cost=0.28..91.5 rows=2,927 width=8) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (associates_9.id IS NOT NULL)
  • Buffers: shared hit=3
375. 0.004 0.197 ↓ 0.0 0 1

Sort (cost=96.88..96.89 rows=1 width=24) (actual time=0.197..0.197 rows=0 loops=1)

  • Sort Key: associates_10.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=21
376. 0.043 0.193 ↓ 0.0 0 1

Merge Join (cost=22.84..96.87 rows=1 width=24) (actual time=0.193..0.193 rows=0 loops=1)

  • Buffers: shared hit=21
377. 0.105 0.105 ↑ 1.0 329 1

Index Scan using associate_taxonomies_taxonomy_id_idx on associate_taxonomies associate_taxonomies_8 (cost=0.15..24.92 rows=329 width=16) (actual time=0.006..0.105 rows=329 loops=1)

  • Filter: (NOT associate_taxonomies_8.is_deleted)
  • Buffers: shared hit=16
378. 0.002 0.045 ↑ 2,927.0 1 1

Materialize (cost=0.43..184.6 rows=2,927 width=32) (actual time=0.045..0.045 rows=1 loops=1)

  • Buffers: shared hit=5
379. 0.001 0.043 ↑ 2,927.0 1 1

Nested Loop (cost=0.43..177.29 rows=2,927 width=32) (actual time=0.043..0.043 rows=1 loops=1)

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

Index Scan using taxonomies_pkey on taxonomies a_taxonomies_8 (cost=0.15..19.93 rows=1 width=24) (actual time=0.024..0.024 rows=1 loops=1)

  • Filter: ((NOT a_taxonomies_8.is_deleted) AND (a_taxonomies_8.taxonomy_type_id = 19))
  • Buffers: shared hit=2
381. 0.000 0.018 ↑ 2,927.0 1 1

Unique (cost=0.28..98.82 rows=2,927 width=8) (actual time=0.018..0.018 rows=1 loops=1)

  • Buffers: shared hit=3
382. 0.018 0.018 ↑ 2,927.0 1 1

Index Only Scan using associates_pkey on associates associates_10 (cost=0.28..91.5 rows=2,927 width=8) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: (associates_10.id IS NOT NULL)
  • Buffers: shared hit=3
383. 0.001 0.025 ↓ 0.0 0 1

Nested Loop (cost=1.72..155.42 rows=1 width=225) (actual time=0.025..0.025 rows=0 loops=1)

  • Buffers: shared hit=3
384. 0.000 0.024 ↓ 0.0 0 1

Nested Loop (cost=1.43..147.11 rows=1 width=200) (actual time=0.024..0.024 rows=0 loops=1)

  • Buffers: shared hit=3
385. 0.001 0.024 ↓ 0.0 0 1

Nested Loop (cost=1.43..126 rows=1 width=188) (actual time=0.024..0.024 rows=0 loops=1)

  • Buffers: shared hit=3
386. 0.000 0.023 ↓ 0.0 0 1

Nested Loop (cost=1.15..117.69 rows=1 width=163) (actual time=0.023..0.023 rows=0 loops=1)

  • Buffers: shared hit=3
387. 0.000 0.023 ↓ 0.0 0 1

Nested Loop (cost=1.15..96.58 rows=1 width=143) (actual time=0.023..0.023 rows=0 loops=1)

  • Buffers: shared hit=3
388. 0.000 0.023 ↓ 0.0 0 1

Nested Loop (cost=0.86..88.26 rows=1 width=118) (actual time=0.023..0.023 rows=0 loops=1)

  • Buffers: shared hit=3
389. 0.000 0.023 ↓ 0.0 0 1

Nested Loop (cost=0.86..67.15 rows=1 width=98) (actual time=0.023..0.023 rows=0 loops=1)

  • Buffers: shared hit=3
390. 0.000 0.023 ↓ 0.0 0 1

Nested Loop (cost=0.57..58.84 rows=1 width=73) (actual time=0.023..0.023 rows=0 loops=1)

  • Buffers: shared hit=3
391. 0.000 0.023 ↓ 0.0 0 1

Nested Loop (cost=0.57..37.73 rows=1 width=53) (actual time=0.023..0.023 rows=0 loops=1)

  • Buffers: shared hit=3
392. 0.001 0.023 ↓ 0.0 0 1

Nested Loop (cost=0.29..29.42 rows=1 width=28) (actual time=0.023..0.023 rows=0 loops=1)

  • Buffers: shared hit=3
393. 0.017 0.017 ↑ 1.0 1 1

Index Scan using orders_pkey on orders orders_1 (cost=0.29..8.31 rows=1 width=8) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: (orders_1.id = 17720)
  • Filter: (NOT orders_1.is_deleted)
  • Buffers: shared hit=3
394. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on order_assistants assistants1 (cost=0..21.1 rows=1 width=20) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((NOT assistants1.is_deleted) AND (assistants1.order_id = 17720) AND (assistants1.no = 1))
395. 0.000 0.000 ↓ 0.0 0 0

Index Scan using drivers_pkey on drivers drivers1 (cost=0.29..8.3 rows=1 width=41) (never executed)

  • Index Cond: (assistants1.driver_id = drivers1.id)
  • Filter: (NOT drivers1.is_deleted)
396. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on order_assistants assistants2 (cost=0..21.1 rows=1 width=20) (never executed)

  • Filter: ((NOT assistants2.is_deleted) AND (assistants2.order_id = 17720) AND (assistants2.no = 2))
397. 0.000 0.000 ↓ 0.0 0 0

Index Scan using drivers_pkey on drivers drivers2 (cost=0.29..8.3 rows=1 width=41) (never executed)

  • Index Cond: (assistants2.driver_id = drivers2.id)
  • Filter: (NOT drivers2.is_deleted)
398. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on order_assistants assistants3 (cost=0..21.1 rows=1 width=20) (never executed)

  • Filter: ((NOT assistants3.is_deleted) AND (assistants3.order_id = 17720) AND (assistants3.no = 3))
399. 0.000 0.000 ↓ 0.0 0 0

Index Scan using drivers_pkey on drivers drivers3 (cost=0.29..8.3 rows=1 width=41) (never executed)

  • Index Cond: (assistants3.driver_id = drivers3.id)
  • Filter: (NOT drivers3.is_deleted)
400. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on order_assistants assistants4 (cost=0..21.1 rows=1 width=20) (never executed)

  • Filter: ((NOT assistants4.is_deleted) AND (assistants4.order_id = 17720) AND (assistants4.no = 4))
401. 0.000 0.000 ↓ 0.0 0 0

Index Scan using drivers_pkey on drivers drivers4 (cost=0.29..8.3 rows=1 width=41) (never executed)

  • Index Cond: (assistants4.driver_id = drivers4.id)
  • Filter: (NOT drivers4.is_deleted)
402. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on order_assistants assistants5 (cost=0..21.1 rows=1 width=20) (never executed)

  • Filter: ((NOT assistants5.is_deleted) AND (assistants5.order_id = 17720) AND (assistants5.no = 5))
403. 0.000 0.000 ↓ 0.0 0 0

Index Scan using drivers_pkey on drivers drivers5 (cost=0.29..8.3 rows=1 width=41) (never executed)

  • Index Cond: (assistants5.driver_id = drivers5.id)
  • Filter: (NOT drivers5.is_deleted)
404. 0.129 8.365 ↑ 1.0 322 1

Hash Join (cost=439.79..476.96 rows=322 width=168) (actual time=6.912..8.365 rows=322 loops=1)

  • Buffers: shared hit=176
405. 0.099 7.618 ↑ 1.0 322 1

Hash Join (cost=398.24..434.18 rows=322 width=152) (actual time=6.286..7.618 rows=322 loops=1)

  • Buffers: shared hit=159
406. 0.110 7.046 ↑ 1.0 322 1

Hash Join (cost=356.68..391.4 rows=322 width=136) (actual time=5.804..7.046 rows=322 loops=1)

  • Buffers: shared hit=142
407. 0.123 6.274 ↑ 1.0 322 1

Hash Join (cost=313.63..346.82 rows=322 width=120) (actual time=5.132..6.274 rows=322 loops=1)

  • Buffers: shared hit=125
408. 0.150 5.517 ↑ 1.0 322 1

Hash Join (cost=269.43..300.87 rows=322 width=104) (actual time=4.488..5.517 rows=322 loops=1)

  • Buffers: shared hit=108
409. 0.126 4.730 ↑ 1.0 322 1

Hash Join (cost=227.24..257.31 rows=322 width=88) (actual time=3.835..4.73 rows=322 loops=1)

  • Buffers: shared hit=91
410. 0.121 3.912 ↑ 1.0 322 1

Hash Join (cost=184.93..213.63 rows=322 width=72) (actual time=3.128..3.912 rows=322 loops=1)

  • Buffers: shared hit=74
411. 0.130 3.148 ↑ 1.0 322 1

Hash Join (cost=139.49..166.18 rows=322 width=56) (actual time=2.46..3.148 rows=322 loops=1)

  • Buffers: shared hit=57
412. 0.195 2.327 ↑ 1.0 322 1

Hash Join (cost=95.93..121 rows=322 width=40) (actual time=1.759..2.327 rows=322 loops=1)

  • Buffers: shared hit=40
413. 0.114 0.900 ↓ 1.1 244 1

Hash Join (cost=29.06..50.94 rows=232 width=24) (actual time=0.506..0.9 rows=244 loops=1)

  • Buffers: shared hit=17
414. 0.177 0.479 ↓ 1.1 244 1

Hash Join (cost=8.57..27.26 rows=232 width=24) (actual time=0.189..0.479 rows=244 loops=1)

  • Buffers: shared hit=11
415. 0.129 0.129 ↑ 1.0 681 1

Seq Scan on truck_taxonomies truck_taxonomies (cost=0..13.81 rows=681 width=16) (actual time=0.005..0.129 rows=681 loops=1)

  • Filter: (NOT truck_taxonomies.is_deleted)
  • Buffers: shared hit=7
416. 0.033 0.173 ↑ 1.0 93 1

Hash (cost=7.41..7.41 rows=93 width=24) (actual time=0.173..0.173 rows=93 loops=1)

  • Buffers: shared hit=4
417. 0.140 0.140 ↑ 1.0 93 1

Seq Scan on taxonomies t_taxonomies (cost=0..7.41 rows=93 width=24) (actual time=0.013..0.14 rows=93 loops=1)

  • Filter: ((NOT t_taxonomies.is_deleted) AND (t_taxonomies.taxonomy_type_id = 21))
  • Buffers: shared hit=4
418. 0.072 0.307 ↑ 1.0 322 1

Hash (cost=16.46..16.46 rows=322 width=8) (actual time=0.307..0.307 rows=322 loops=1)

  • Buffers: shared hit=6
419. 0.169 0.235 ↑ 1.0 322 1

HashAggregate (cost=10.03..13.25 rows=322 width=8) (actual time=0.18..0.235 rows=322 loops=1)

  • Group Key: trucks_1.id
  • Buffers: shared hit=6
420. 0.066 0.066 ↑ 1.0 322 1

Seq Scan on trucks trucks_1 (cost=0..9.22 rows=322 width=8) (actual time=0.004..0.066 rows=322 loops=1)

  • Filter: (trucks_1.id IS NOT NULL)
  • Buffers: shared hit=6
421. 0.095 1.232 ↑ 1.0 322 1

Hash (cost=62.84..62.84 rows=322 width=24) (actual time=1.232..1.232 rows=322 loops=1)

  • Buffers: shared hit=23
422. 0.136 1.137 ↑ 1.0 322 1

Hash Join (cost=54.58..62.84 rows=322 width=24) (actual time=0.974..1.137 rows=322 loops=1)

  • Buffers: shared hit=23
423. 0.163 0.219 ↑ 1.0 322 1

HashAggregate (cost=10.03..13.25 rows=322 width=8) (actual time=0.173..0.219 rows=322 loops=1)

  • Group Key: trucks_2.id
  • Buffers: shared hit=6
424. 0.056 0.056 ↑ 1.0 322 1

Seq Scan on trucks trucks_2 (cost=0..9.22 rows=322 width=8) (actual time=0.006..0.056 rows=322 loops=1)

  • Filter: (trucks_2.id IS NOT NULL)
  • Buffers: shared hit=6
425. 0.027 0.782 ↓ 1.1 70 1

Hash (cost=43.78..43.78 rows=62 width=24) (actual time=0.782..0.782 rows=70 loops=1)

  • Buffers: shared hit=17
426. 0.094 0.755 ↓ 1.1 70 1

Hash Join (cost=35.51..43.78 rows=62 width=24) (actual time=0.612..0.755 rows=70 loops=1)

  • Buffers: shared hit=17
427. 0.165 0.221 ↑ 1.0 322 1

HashAggregate (cost=10.03..13.25 rows=322 width=8) (actual time=0.159..0.221 rows=322 loops=1)

  • Group Key: trucks_3.id
  • Buffers: shared hit=6
428. 0.056 0.056 ↑ 1.0 322 1

Seq Scan on trucks trucks_3 (cost=0..9.22 rows=322 width=8) (actual time=0.003..0.056 rows=322 loops=1)

  • Filter: (trucks_3.id IS NOT NULL)
  • Buffers: shared hit=6
429. 0.021 0.440 ↓ 1.1 70 1

Hash (cost=24.71..24.71 rows=62 width=24) (actual time=0.44..0.44 rows=70 loops=1)

  • Buffers: shared hit=11
430. 0.154 0.419 ↓ 1.1 70 1

Hash Join (cost=7.72..24.71 rows=62 width=24) (actual time=0.174..0.419 rows=70 loops=1)

  • Buffers: shared hit=11
431. 0.174 0.174 ↑ 1.0 681 1

Seq Scan on truck_taxonomies truck_taxonomies_1 (cost=0..13.81 rows=681 width=16) (actual time=0.068..0.174 rows=681 loops=1)

  • Filter: (NOT truck_taxonomies_1.is_deleted)
  • Buffers: shared hit=7
432. 0.012 0.091 ↑ 1.0 25 1

Hash (cost=7.41..7.41 rows=25 width=24) (actual time=0.091..0.091 rows=25 loops=1)

  • Buffers: shared hit=4
433. 0.079 0.079 ↑ 1.0 25 1

Seq Scan on taxonomies t_taxonomies_1 (cost=0..7.41 rows=25 width=24) (actual time=0.045..0.079 rows=25 loops=1)

  • Filter: ((NOT t_taxonomies_1.is_deleted) AND (t_taxonomies_1.taxonomy_type_id = 22))
  • Buffers: shared hit=4
434. 0.036 0.691 ↓ 1.4 60 1

Hash (cost=43.03..43.03 rows=42 width=24) (actual time=0.691..0.691 rows=60 loops=1)

  • Buffers: shared hit=17
435. 0.075 0.655 ↓ 1.4 60 1

Hash Join (cost=34.96..43.03 rows=42 width=24) (actual time=0.504..0.655 rows=60 loops=1)

  • Buffers: shared hit=17
436. 0.189 0.249 ↑ 1.0 322 1

HashAggregate (cost=10.03..13.25 rows=322 width=8) (actual time=0.163..0.249 rows=322 loops=1)

  • Group Key: trucks_4.id
  • Buffers: shared hit=6
437. 0.060 0.060 ↑ 1.0 322 1

Seq Scan on trucks trucks_4 (cost=0..9.22 rows=322 width=8) (actual time=0.003..0.06 rows=322 loops=1)

  • Filter: (trucks_4.id IS NOT NULL)
  • Buffers: shared hit=6
438. 0.023 0.331 ↓ 1.4 60 1

Hash (cost=24.41..24.41 rows=42 width=24) (actual time=0.331..0.331 rows=60 loops=1)

  • Buffers: shared hit=11
439. 0.122 0.308 ↓ 1.4 60 1

Hash Join (cost=7.62..24.41 rows=42 width=24) (actual time=0.087..0.308 rows=60 loops=1)

  • Buffers: shared hit=11
440. 0.113 0.113 ↑ 1.0 681 1

Seq Scan on truck_taxonomies truck_taxonomies_4 (cost=0..13.81 rows=681 width=16) (actual time=0.003..0.113 rows=681 loops=1)

  • Filter: (NOT truck_taxonomies_4.is_deleted)
  • Buffers: shared hit=7
441. 0.008 0.073 ↑ 1.0 17 1

Hash (cost=7.41..7.41 rows=17 width=24) (actual time=0.073..0.073 rows=17 loops=1)

  • Buffers: shared hit=4
442. 0.065 0.065 ↑ 1.0 17 1

Seq Scan on taxonomies t_taxonomies_4 (cost=0..7.41 rows=17 width=24) (actual time=0.048..0.065 rows=17 loops=1)

  • Filter: ((NOT t_taxonomies_4.is_deleted) AND (t_taxonomies_4.taxonomy_type_id = 25))
  • Buffers: shared hit=4
443. 0.022 0.643 ↑ 1.3 61 1

Hash (cost=44.45..44.45 rows=80 width=24) (actual time=0.643..0.643 rows=61 loops=1)

  • Buffers: shared hit=17
444. 0.076 0.621 ↑ 1.3 61 1

Hash Join (cost=36..44.45 rows=80 width=24) (actual time=0.516..0.621 rows=61 loops=1)

  • Buffers: shared hit=17
445. 0.146 0.210 ↑ 1.0 322 1

HashAggregate (cost=10.03..13.25 rows=322 width=8) (actual time=0.167..0.21 rows=322 loops=1)

  • Group Key: trucks_5.id
  • Buffers: shared hit=6
446. 0.064 0.064 ↑ 1.0 322 1

Seq Scan on trucks trucks_5 (cost=0..9.22 rows=322 width=8) (actual time=0.005..0.064 rows=322 loops=1)

  • Filter: (trucks_5.id IS NOT NULL)
  • Buffers: shared hit=6
447. 0.024 0.335 ↑ 1.3 61 1

Hash (cost=24.98..24.98 rows=80 width=24) (actual time=0.335..0.335 rows=61 loops=1)

  • Buffers: shared hit=11
448. 0.121 0.311 ↑ 1.3 61 1

Hash Join (cost=7.81..24.98 rows=80 width=24) (actual time=0.096..0.311 rows=61 loops=1)

  • Buffers: shared hit=11
449. 0.112 0.112 ↑ 1.0 681 1

Seq Scan on truck_taxonomies truck_taxonomies_3 (cost=0..13.81 rows=681 width=16) (actual time=0.003..0.112 rows=681 loops=1)

  • Filter: (NOT truck_taxonomies_3.is_deleted)
  • Buffers: shared hit=7
450. 0.014 0.078 ↑ 1.0 32 1

Hash (cost=7.41..7.41 rows=32 width=24) (actual time=0.078..0.078 rows=32 loops=1)

  • Buffers: shared hit=4
451. 0.064 0.064 ↑ 1.0 32 1

Seq Scan on taxonomies t_taxonomies_3 (cost=0..7.41 rows=32 width=24) (actual time=0.04..0.064 rows=32 loops=1)

  • Filter: ((NOT t_taxonomies_3.is_deleted) AND (t_taxonomies_3.taxonomy_type_id = 24))
  • Buffers: shared hit=4
452. 0.006 0.692 ↑ 1.1 15 1

Hash (cost=42.09..42.09 rows=17 width=24) (actual time=0.692..0.692 rows=15 loops=1)

  • Buffers: shared hit=17
453. 0.116 0.686 ↑ 1.1 15 1

Hash Join (cost=34.27..42.09 rows=17 width=24) (actual time=0.579..0.686 rows=15 loops=1)

  • Buffers: shared hit=17
454. 0.164 0.217 ↑ 1.0 322 1

HashAggregate (cost=10.03..13.25 rows=322 width=8) (actual time=0.16..0.217 rows=322 loops=1)

  • Group Key: trucks_6.id
  • Buffers: shared hit=6
455. 0.053 0.053 ↑ 1.0 322 1

Seq Scan on trucks trucks_6 (cost=0..9.22 rows=322 width=8) (actual time=0.003..0.053 rows=322 loops=1)

  • Filter: (trucks_6.id IS NOT NULL)
  • Buffers: shared hit=6
456. 0.010 0.353 ↑ 1.1 15 1

Hash (cost=24.03..24.03 rows=17 width=24) (actual time=0.353..0.353 rows=15 loops=1)

  • Buffers: shared hit=11
457. 0.114 0.343 ↑ 1.1 15 1

Hash Join (cost=7.5..24.03 rows=17 width=24) (actual time=0.171..0.343 rows=15 loops=1)

  • Buffers: shared hit=11
458. 0.123 0.123 ↑ 1.0 681 1

Seq Scan on truck_taxonomies truck_taxonomies_2 (cost=0..13.81 rows=681 width=16) (actual time=0.006..0.123 rows=681 loops=1)

  • Filter: (NOT truck_taxonomies_2.is_deleted)
  • Buffers: shared hit=7
459. 0.008 0.106 ↑ 1.0 7 1

Hash (cost=7.41..7.41 rows=7 width=24) (actual time=0.106..0.106 rows=7 loops=1)

  • Buffers: shared hit=4
460. 0.098 0.098 ↑ 1.0 7 1

Seq Scan on taxonomies t_taxonomies_2 (cost=0..7.41 rows=7 width=24) (actual time=0.065..0.098 rows=7 loops=1)

  • Filter: ((NOT t_taxonomies_2.is_deleted) AND (t_taxonomies_2.taxonomy_type_id = 23))
  • Buffers: shared hit=4
461. 0.018 0.637 ↓ 3.1 47 1

Hash (cost=42.01..42.01 rows=15 width=24) (actual time=0.637..0.637 rows=47 loops=1)

  • Buffers: shared hit=17
462. 0.076 0.619 ↓ 3.1 47 1

Hash Join (cost=34.21..42.01 rows=15 width=24) (actual time=0.518..0.619 rows=47 loops=1)

  • Buffers: shared hit=17
463. 0.139 0.200 ↑ 1.0 322 1

HashAggregate (cost=10.03..13.25 rows=322 width=8) (actual time=0.159..0.2 rows=322 loops=1)

  • Group Key: trucks_7.id
  • Buffers: shared hit=6
464. 0.061 0.061 ↑ 1.0 322 1

Seq Scan on trucks trucks_7 (cost=0..9.22 rows=322 width=8) (actual time=0.004..0.061 rows=322 loops=1)

  • Filter: (trucks_7.id IS NOT NULL)
  • Buffers: shared hit=6
465. 0.017 0.343 ↓ 3.1 47 1

Hash (cost=24..24 rows=15 width=24) (actual time=0.343..0.343 rows=47 loops=1)

  • Buffers: shared hit=11
466. 0.115 0.326 ↓ 3.1 47 1

Hash Join (cost=7.49..24 rows=15 width=24) (actual time=0.082..0.326 rows=47 loops=1)

  • Buffers: shared hit=11
467. 0.145 0.145 ↑ 1.0 681 1

Seq Scan on truck_taxonomies truck_taxonomies_7 (cost=0..13.81 rows=681 width=16) (actual time=0.003..0.145 rows=681 loops=1)

  • Filter: (NOT truck_taxonomies_7.is_deleted)
  • Buffers: shared hit=7
468. 0.004 0.066 ↑ 1.0 6 1

Hash (cost=7.41..7.41 rows=6 width=24) (actual time=0.066..0.066 rows=6 loops=1)

  • Buffers: shared hit=4
469. 0.062 0.062 ↑ 1.0 6 1

Seq Scan on taxonomies t_taxonomies_7 (cost=0..7.41 rows=6 width=24) (actual time=0.057..0.062 rows=6 loops=1)

  • Filter: ((NOT t_taxonomies_7.is_deleted) AND (t_taxonomies_7.taxonomy_type_id = 28))
  • Buffers: shared hit=4
470. 0.021 0.634 ↓ 1.1 60 1

Hash (cost=43.51..43.51 rows=55 width=24) (actual time=0.634..0.634 rows=60 loops=1)

  • Buffers: shared hit=17
471. 0.066 0.613 ↓ 1.1 60 1

Hash Join (cost=35.31..43.51 rows=55 width=24) (actual time=0.51..0.613 rows=60 loops=1)

  • Buffers: shared hit=17
472. 0.155 0.209 ↑ 1.0 322 1

HashAggregate (cost=10.03..13.25 rows=322 width=8) (actual time=0.161..0.209 rows=322 loops=1)

  • Group Key: trucks_8.id
  • Buffers: shared hit=6
473. 0.054 0.054 ↑ 1.0 322 1

Seq Scan on trucks trucks_8 (cost=0..9.22 rows=322 width=8) (actual time=0.004..0.054 rows=322 loops=1)

  • Filter: (trucks_8.id IS NOT NULL)
  • Buffers: shared hit=6
474. 0.021 0.338 ↓ 1.1 60 1

Hash (cost=24.6..24.6 rows=55 width=24) (actual time=0.338..0.338 rows=60 loops=1)

  • Buffers: shared hit=11
475. 0.120 0.317 ↓ 1.1 60 1

Hash Join (cost=7.69..24.6 rows=55 width=24) (actual time=0.097..0.317 rows=60 loops=1)

  • Buffers: shared hit=11
476. 0.122 0.122 ↑ 1.0 681 1

Seq Scan on truck_taxonomies truck_taxonomies_6 (cost=0..13.81 rows=681 width=16) (actual time=0.007..0.122 rows=681 loops=1)

  • Filter: (NOT truck_taxonomies_6.is_deleted)
  • Buffers: shared hit=7
477. 0.011 0.075 ↑ 1.0 22 1

Hash (cost=7.41..7.41 rows=22 width=24) (actual time=0.075..0.075 rows=22 loops=1)

  • Buffers: shared hit=4
478. 0.064 0.064 ↑ 1.0 22 1

Seq Scan on taxonomies t_taxonomies_6 (cost=0..7.41 rows=22 width=24) (actual time=0.053..0.064 rows=22 loops=1)

  • Filter: ((NOT t_taxonomies_6.is_deleted) AND (t_taxonomies_6.taxonomy_type_id = 27))
  • Buffers: shared hit=4
479. 0.015 0.662 ↓ 2.0 65 1

Hash (cost=42.65..42.65 rows=32 width=24) (actual time=0.662..0.662 rows=65 loops=1)

  • Buffers: shared hit=17
480. 0.090 0.647 ↓ 2.0 65 1

Hash Join (cost=34.68..42.65 rows=32 width=24) (actual time=0.535..0.647 rows=65 loops=1)

  • Buffers: shared hit=17
481. 0.172 0.226 ↑ 1.0 322 1

HashAggregate (cost=10.03..13.25 rows=322 width=8) (actual time=0.19..0.226 rows=322 loops=1)

  • Group Key: trucks_9.id
  • Buffers: shared hit=6
482. 0.054 0.054 ↑ 1.0 322 1

Seq Scan on trucks trucks_9 (cost=0..9.22 rows=322 width=8) (actual time=0.003..0.054 rows=322 loops=1)

  • Filter: (trucks_9.id IS NOT NULL)
  • Buffers: shared hit=6
483. 0.027 0.331 ↓ 2.0 65 1

Hash (cost=24.26..24.26 rows=32 width=24) (actual time=0.331..0.331 rows=65 loops=1)

  • Buffers: shared hit=11
484. 0.116 0.304 ↓ 2.0 65 1

Hash Join (cost=7.57..24.26 rows=32 width=24) (actual time=0.086..0.304 rows=65 loops=1)

  • Buffers: shared hit=11
485. 0.119 0.119 ↑ 1.0 681 1

Seq Scan on truck_taxonomies truck_taxonomies_5 (cost=0..13.81 rows=681 width=16) (actual time=0.006..0.119 rows=681 loops=1)

  • Filter: (NOT truck_taxonomies_5.is_deleted)
  • Buffers: shared hit=7
486. 0.007 0.069 ↑ 1.0 13 1

Hash (cost=7.41..7.41 rows=13 width=24) (actual time=0.069..0.069 rows=13 loops=1)

  • Buffers: shared hit=4
487. 0.062 0.062 ↑ 1.0 13 1

Seq Scan on taxonomies t_taxonomies_5 (cost=0..7.41 rows=13 width=24) (actual time=0.049..0.062 rows=13 loops=1)

  • Filter: ((NOT t_taxonomies_5.is_deleted) AND (t_taxonomies_5.taxonomy_type_id = 26))
  • Buffers: shared hit=4
488. 0.000 0.473 ↓ 0.0 0 1

Hash (cost=41.53..41.53 rows=2 width=24) (actual time=0.473..0.473 rows=0 loops=1)

  • Buffers: shared hit=17
489. 0.007 0.473 ↓ 0.0 0 1

Hash Join (cost=33.86..41.53 rows=2 width=24) (actual time=0.473..0.473 rows=0 loops=1)

  • Buffers: shared hit=17
490. 0.106 0.162 ↑ 322.0 1 1

HashAggregate (cost=10.03..13.25 rows=322 width=8) (actual time=0.162..0.162 rows=1 loops=1)

  • Group Key: trucks_10.id
  • Buffers: shared hit=6
491. 0.056 0.056 ↑ 1.0 322 1

Seq Scan on trucks trucks_10 (cost=0..9.22 rows=322 width=8) (actual time=0.003..0.056 rows=322 loops=1)

  • Filter: (trucks_10.id IS NOT NULL)
  • Buffers: shared hit=6
492. 0.001 0.304 ↓ 0.0 0 1

Hash (cost=23.81..23.81 rows=2 width=24) (actual time=0.304..0.304 rows=0 loops=1)

  • Buffers: shared hit=11
493. 0.108 0.303 ↓ 0.0 0 1

Hash Join (cost=7.42..23.81 rows=2 width=24) (actual time=0.303..0.303 rows=0 loops=1)

  • Buffers: shared hit=11
494. 0.132 0.132 ↑ 1.0 681 1

Seq Scan on truck_taxonomies truck_taxonomies_9 (cost=0..13.81 rows=681 width=16) (actual time=0.003..0.132 rows=681 loops=1)

  • Filter: (NOT truck_taxonomies_9.is_deleted)
  • Buffers: shared hit=7
495. 0.002 0.063 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.063..0.063 rows=1 loops=1)

  • Buffers: shared hit=4
496. 0.061 0.061 ↑ 1.0 1 1

Seq Scan on taxonomies t_taxonomies_9 (cost=0..7.41 rows=1 width=24) (actual time=0.058..0.061 rows=1 loops=1)

  • Filter: ((NOT t_taxonomies_9.is_deleted) AND (t_taxonomies_9.taxonomy_type_id = 30))
  • Buffers: shared hit=4
497. 0.023 0.618 ↓ 29.5 59 1

Hash (cost=41.53..41.53 rows=2 width=24) (actual time=0.618..0.618 rows=59 loops=1)

  • Buffers: shared hit=17
498. 0.068 0.595 ↓ 29.5 59 1

Hash Join (cost=33.86..41.53 rows=2 width=24) (actual time=0.495..0.595 rows=59 loops=1)

  • Buffers: shared hit=17
499. 0.154 0.207 ↑ 1.0 322 1

HashAggregate (cost=10.03..13.25 rows=322 width=8) (actual time=0.163..0.207 rows=322 loops=1)

  • Group Key: trucks_11.id
  • Buffers: shared hit=6
500. 0.053 0.053 ↑ 1.0 322 1

Seq Scan on trucks trucks_11 (cost=0..9.22 rows=322 width=8) (actual time=0.003..0.053 rows=322 loops=1)

  • Filter: (trucks_11.id IS NOT NULL)
  • Buffers: shared hit=6
501. 0.021 0.320 ↓ 29.5 59 1

Hash (cost=23.81..23.81 rows=2 width=24) (actual time=0.32..0.32 rows=59 loops=1)

  • Buffers: shared hit=11
502. 0.123 0.299 ↓ 29.5 59 1

Hash Join (cost=7.42..23.81 rows=2 width=24) (actual time=0.084..0.299 rows=59 loops=1)

  • Buffers: shared hit=11
503. 0.110 0.110 ↑ 1.0 681 1

Seq Scan on truck_taxonomies truck_taxonomies_8 (cost=0..13.81 rows=681 width=16) (actual time=0.003..0.11 rows=681 loops=1)

  • Filter: (NOT truck_taxonomies_8.is_deleted)
  • Buffers: shared hit=7
504. 0.002 0.066 ↓ 2.0 2 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.066..0.066 rows=2 loops=1)

  • Buffers: shared hit=4
505. 0.064 0.064 ↓ 2.0 2 1

Seq Scan on taxonomies t_taxonomies_8 (cost=0..7.41 rows=1 width=24) (actual time=0.059..0.064 rows=2 loops=1)

  • Filter: ((NOT t_taxonomies_8.is_deleted) AND (t_taxonomies_8.taxonomy_type_id = 29))
  • Buffers: shared hit=4
506. 0.130 29.308 ↑ 1.0 515 1

Merge Join (cost=363.27..737.73 rows=515 width=168) (actual time=24.823..29.308 rows=515 loops=1)

  • Buffers: shared hit=199
507. 0.123 28.654 ↑ 1.0 515 1

Merge Join (cost=327.17..667.48 rows=515 width=152) (actual time=24.296..28.654 rows=515 loops=1)

  • Buffers: shared hit=180
508. 0.140 28.064 ↑ 1.0 515 1

Merge Join (cost=291.07..597.24 rows=515 width=136) (actual time=23.827..28.064 rows=515 loops=1)

  • Buffers: shared hit=161
509. 0.103 27.381 ↑ 1.0 515 1

Merge Join (cost=254.49..526.12 rows=515 width=120) (actual time=23.282..27.381 rows=515 loops=1)

  • Buffers: shared hit=142
510. 0.192 26.697 ↑ 1.0 515 1

Merge Join (cost=218.39..455.88 rows=515 width=104) (actual time=22.699..26.697 rows=515 loops=1)

  • Buffers: shared hit=123
511. 0.171 25.988 ↑ 1.0 515 1

Merge Join (cost=182.29..385.63 rows=515 width=88) (actual time=22.181..25.988 rows=515 loops=1)

  • Buffers: shared hit=104
512. 0.208 6.185 ↑ 1.0 515 1

Merge Join (cost=145.71..314.52 rows=515 width=72) (actual time=2.934..6.185 rows=515 loops=1)

  • Buffers: shared hit=84
513. 0.133 5.111 ↑ 1.0 515 1

Merge Join (cost=109.61..244.27 rows=515 width=56) (actual time=2.125..5.111 rows=515 loops=1)

  • Buffers: shared hit=64
514. 0.361 4.216 ↑ 1.0 515 1

Merge Join (cost=72.48..172.22 rows=515 width=40) (actual time=1.644..4.216 rows=515 loops=1)

  • Buffers: shared hit=44
515. 0.359 2.227 ↑ 1.0 515 1

Merge Join (cost=36.38..101.97 rows=515 width=24) (actual time=0.871..2.227 rows=515 loops=1)

  • Buffers: shared hit=24
516. 0.142 0.243 ↑ 1.0 515 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.024..0.243 rows=515 loops=1)

  • Buffers: shared hit=4
517. 0.101 0.101 ↑ 1.0 515 1

Index Only Scan using customers_pkey on customers customers_12 (cost=0.28..25.29 rows=515 width=8) (actual time=0.023..0.101 rows=515 loops=1)

  • Index Cond: (customers_12.id IS NOT NULL)
  • Buffers: shared hit=4
518. 0.133 1.625 ↓ 128.8 515 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.845..1.625 rows=515 loops=1)

  • Buffers: shared hit=20
519. 0.314 1.492 ↓ 128.8 515 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.843..1.492 rows=515 loops=1)

  • Buffers: shared hit=20
520. 0.161 0.275 ↑ 1.0 515 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.019..0.275 rows=515 loops=1)

  • Buffers: shared hit=4
521. 0.114 0.114 ↑ 1.0 515 1

Index Only Scan using customers_pkey on customers customers_13 (cost=0.28..25.29 rows=515 width=8) (actual time=0.019..0.114 rows=515 loops=1)

  • Index Cond: (customers_13.id IS NOT NULL)
  • Buffers: shared hit=4
522. 0.267 0.903 ↓ 128.8 515 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.821..0.903 rows=515 loops=1)

  • Sort Key: customer_taxonomies_11.customer_id
  • Sort Method: quicksort Memory: 49kB
  • Buffers: shared hit=16
523. 0.309 0.636 ↓ 128.8 515 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.087..0.636 rows=515 loops=1)

  • Buffers: shared hit=16
524. 0.258 0.258 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_11 (cost=0..23.87 rows=1,187 width=16) (actual time=0.005..0.258 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_11.is_deleted)
  • Buffers: shared hit=12
525. 0.005 0.069 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.069..0.069 rows=1 loops=1)

  • Buffers: shared hit=4
526. 0.064 0.064 ↑ 1.0 1 1

Seq Scan on taxonomies b_taxonomies_1 (cost=0..7.41 rows=1 width=24) (actual time=0.007..0.064 rows=1 loops=1)

  • Filter: ((NOT b_taxonomies_1.is_deleted) AND (b_taxonomies_1.taxonomy_type_id = 2))
  • Buffers: shared hit=4
527. 0.135 1.628 ↓ 128.8 515 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.773..1.628 rows=515 loops=1)

  • Buffers: shared hit=20
528. 0.371 1.493 ↓ 128.8 515 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.77..1.493 rows=515 loops=1)

  • Buffers: shared hit=20
529. 0.139 0.268 ↑ 1.0 515 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.022..0.268 rows=515 loops=1)

  • Buffers: shared hit=4
530. 0.129 0.129 ↑ 1.0 515 1

Index Only Scan using customers_pkey on customers customers_14 (cost=0.28..25.29 rows=515 width=8) (actual time=0.022..0.129 rows=515 loops=1)

  • Index Cond: (customers_14.id IS NOT NULL)
  • Buffers: shared hit=4
531. 0.251 0.854 ↓ 128.8 515 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.746..0.854 rows=515 loops=1)

  • Sort Key: customer_taxonomies_10.customer_id
  • Sort Method: quicksort Memory: 49kB
  • Buffers: shared hit=16
532. 0.335 0.603 ↓ 128.8 515 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.081..0.603 rows=515 loops=1)

  • Buffers: shared hit=16
533. 0.204 0.204 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_10 (cost=0..23.87 rows=1,187 width=16) (actual time=0.004..0.204 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_10.is_deleted)
  • Buffers: shared hit=12
534. 0.003 0.064 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.064..0.064 rows=1 loops=1)

  • Buffers: shared hit=4
535. 0.061 0.061 ↑ 1.0 1 1

Seq Scan on taxonomies b_taxonomies (cost=0..7.41 rows=1 width=24) (actual time=0.005..0.061 rows=1 loops=1)

  • Filter: ((NOT b_taxonomies.is_deleted) AND (b_taxonomies.taxonomy_type_id = 1))
  • Buffers: shared hit=4
536. 0.007 0.762 ↑ 3.0 10 1

Materialize (cost=37.13..70.39 rows=30 width=24) (actual time=0.479..0.762 rows=10 loops=1)

  • Buffers: shared hit=20
537. 0.084 0.755 ↑ 3.0 10 1

Merge Join (cost=37.13..70.32 rows=30 width=24) (actual time=0.478..0.755 rows=10 loops=1)

  • Buffers: shared hit=20
538. 0.112 0.214 ↑ 1.0 511 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.02..0.214 rows=511 loops=1)

  • Buffers: shared hit=4
539. 0.102 0.102 ↑ 1.0 511 1

Index Only Scan using customers_pkey on customers customers_15 (cost=0.28..25.29 rows=515 width=8) (actual time=0.019..0.102 rows=511 loops=1)

  • Index Cond: (customers_15.id IS NOT NULL)
  • Buffers: shared hit=4
540. 0.016 0.457 ↑ 3.0 10 1

Sort (cost=36.86..36.93 rows=30 width=24) (actual time=0.456..0.457 rows=10 loops=1)

  • Sort Key: customer_taxonomies_14.customer_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=16
541. 0.183 0.441 ↑ 3.0 10 1

Hash Join (cost=7.5..36.12 rows=30 width=24) (actual time=0.083..0.441 rows=10 loops=1)

  • Buffers: shared hit=16
542. 0.190 0.190 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_14 (cost=0..23.87 rows=1,187 width=16) (actual time=0.004..0.19 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_14.is_deleted)
  • Buffers: shared hit=12
543. 0.005 0.068 ↑ 1.0 7 1

Hash (cost=7.41..7.41 rows=7 width=24) (actual time=0.068..0.068 rows=7 loops=1)

  • Buffers: shared hit=4
544. 0.063 0.063 ↑ 1.0 7 1

Seq Scan on taxonomies b_taxonomies_4 (cost=0..7.41 rows=7 width=24) (actual time=0.006..0.063 rows=7 loops=1)

  • Filter: ((NOT b_taxonomies_4.is_deleted) AND (b_taxonomies_4.taxonomy_type_id = 5))
  • Buffers: shared hit=4
545. 0.010 0.866 ↓ 10.0 40 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.808..0.866 rows=40 loops=1)

  • Buffers: shared hit=20
546. 0.053 0.856 ↓ 10.0 40 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.805..0.856 rows=40 loops=1)

  • Buffers: shared hit=20
547. 0.125 0.254 ↑ 1.0 514 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.019..0.254 rows=514 loops=1)

  • Buffers: shared hit=4
548. 0.129 0.129 ↑ 1.0 514 1

Index Only Scan using customers_pkey on customers customers_16 (cost=0.28..25.29 rows=515 width=8) (actual time=0.019..0.129 rows=514 loops=1)

  • Index Cond: (customers_16.id IS NOT NULL)
  • Buffers: shared hit=4
549. 0.035 0.549 ↓ 10.0 40 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.539..0.549 rows=40 loops=1)

  • Sort Key: customer_taxonomies_13.customer_id
  • Sort Method: quicksort Memory: 28kB
  • Buffers: shared hit=16
550. 0.203 0.514 ↓ 10.0 40 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.454..0.514 rows=40 loops=1)

  • Buffers: shared hit=16
551. 0.201 0.201 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_13 (cost=0..23.87 rows=1,187 width=16) (actual time=0.003..0.201 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_13.is_deleted)
  • Buffers: shared hit=12
552. 0.002 0.110 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.11..0.11 rows=1 loops=1)

  • Buffers: shared hit=4
553. 0.108 0.108 ↑ 1.0 1 1

Seq Scan on taxonomies b_taxonomies_3 (cost=0..7.41 rows=1 width=24) (actual time=0.006..0.108 rows=1 loops=1)

  • Filter: ((NOT b_taxonomies_3.is_deleted) AND (b_taxonomies_3.taxonomy_type_id = 4))
  • Buffers: shared hit=4
554. 0.033 19.632 ↓ 6.3 107 1

Materialize (cost=36.58..69.61 rows=17 width=24) (actual time=19.245..19.632 rows=107 loops=1)

  • Buffers: shared hit=20
555. 0.100 19.599 ↓ 6.3 107 1

Merge Join (cost=36.58..69.57 rows=17 width=24) (actual time=19.24..19.599 rows=107 loops=1)

  • Buffers: shared hit=20
556. 0.170 0.280 ↑ 1.0 515 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.041..0.28 rows=515 loops=1)

  • Buffers: shared hit=4
557. 0.110 0.110 ↑ 1.0 515 1

Index Only Scan using customers_pkey on customers customers_17 (cost=0.28..25.29 rows=515 width=8) (actual time=0.04..0.11 rows=515 loops=1)

  • Index Cond: (customers_17.id IS NOT NULL)
  • Buffers: shared hit=4
558. 18.708 19.219 ↓ 6.3 107 1

Sort (cost=36.3..36.34 rows=17 width=24) (actual time=19.197..19.219 rows=107 loops=1)

  • Sort Key: customer_taxonomies_12.customer_id
  • Sort Method: quicksort Memory: 33kB
  • Buffers: shared hit=16
559. 0.207 0.511 ↓ 6.3 107 1

Hash Join (cost=7.46..35.95 rows=17 width=24) (actual time=0.103..0.511 rows=107 loops=1)

  • Buffers: shared hit=16
560. 0.219 0.219 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_12 (cost=0..23.87 rows=1,187 width=16) (actual time=0.004..0.219 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_12.is_deleted)
  • Buffers: shared hit=12
561. 0.006 0.085 ↑ 1.0 4 1

Hash (cost=7.41..7.41 rows=4 width=24) (actual time=0.085..0.085 rows=4 loops=1)

  • Buffers: shared hit=4
562. 0.079 0.079 ↑ 1.0 4 1

Seq Scan on taxonomies b_taxonomies_2 (cost=0..7.41 rows=4 width=24) (actual time=0.007..0.079 rows=4 loops=1)

  • Filter: ((NOT b_taxonomies_2.is_deleted) AND (b_taxonomies_2.taxonomy_type_id = 3))
  • Buffers: shared hit=4
563. 0.003 0.517 ↓ 0.0 0 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.517..0.517 rows=0 loops=1)

  • Buffers: shared hit=19
564. 0.002 0.514 ↓ 0.0 0 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.514..0.514 rows=0 loops=1)

  • Buffers: shared hit=19
565. 0.000 0.023 ↑ 515.0 1 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.023..0.023 rows=1 loops=1)

  • Buffers: shared hit=3
566. 0.023 0.023 ↑ 515.0 1 1

Index Only Scan using customers_pkey on customers customers_18 (cost=0.28..25.29 rows=515 width=8) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: (customers_18.id IS NOT NULL)
  • Buffers: shared hit=3
567. 0.009 0.489 ↓ 0.0 0 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.489..0.489 rows=0 loops=1)

  • Sort Key: customer_taxonomies_17.customer_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=16
568. 0.187 0.480 ↓ 0.0 0 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.48..0.48 rows=0 loops=1)

  • Buffers: shared hit=16
569. 0.221 0.221 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_17 (cost=0..23.87 rows=1,187 width=16) (actual time=0.013..0.221 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_17.is_deleted)
  • Buffers: shared hit=12
570. 0.003 0.072 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.072..0.072 rows=1 loops=1)

  • Buffers: shared hit=4
571. 0.069 0.069 ↑ 1.0 1 1

Seq Scan on taxonomies b_taxonomies_7 (cost=0..7.41 rows=1 width=24) (actual time=0.013..0.069 rows=1 loops=1)

  • Filter: ((NOT b_taxonomies_7.is_deleted) AND (b_taxonomies_7.taxonomy_type_id = 8))
  • Buffers: shared hit=4
572. 0.002 0.581 ↓ 0.0 0 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.581..0.581 rows=0 loops=1)

  • Buffers: shared hit=19
573. 0.002 0.579 ↓ 0.0 0 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.578..0.579 rows=0 loops=1)

  • Buffers: shared hit=19
574. 0.001 0.087 ↑ 515.0 1 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.087..0.087 rows=1 loops=1)

  • Buffers: shared hit=3
575. 0.086 0.086 ↑ 515.0 1 1

Index Only Scan using customers_pkey on customers customers_19 (cost=0.28..25.29 rows=515 width=8) (actual time=0.086..0.086 rows=1 loops=1)

  • Index Cond: (customers_19.id IS NOT NULL)
  • Buffers: shared hit=3
576. 0.007 0.490 ↓ 0.0 0 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.49..0.49 rows=0 loops=1)

  • Sort Key: customer_taxonomies_16.customer_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=16
577. 0.195 0.483 ↓ 0.0 0 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.482..0.483 rows=0 loops=1)

  • Buffers: shared hit=16
578. 0.218 0.218 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_16 (cost=0..23.87 rows=1,187 width=16) (actual time=0.004..0.218 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_16.is_deleted)
  • Buffers: shared hit=12
579. 0.002 0.070 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.07..0.07 rows=1 loops=1)

  • Buffers: shared hit=4
580. 0.068 0.068 ↑ 1.0 1 1

Seq Scan on taxonomies b_taxonomies_6 (cost=0..7.41 rows=1 width=24) (actual time=0.014..0.068 rows=1 loops=1)

  • Filter: ((NOT b_taxonomies_6.is_deleted) AND (b_taxonomies_6.taxonomy_type_id = 7))
  • Buffers: shared hit=4
581. 0.002 0.543 ↓ 0.0 0 1

Materialize (cost=36.58..69.61 rows=17 width=24) (actual time=0.543..0.543 rows=0 loops=1)

  • Buffers: shared hit=19
582. 0.002 0.541 ↓ 0.0 0 1

Merge Join (cost=36.58..69.57 rows=17 width=24) (actual time=0.541..0.541 rows=0 loops=1)

  • Buffers: shared hit=19
583. 0.000 0.033 ↑ 515.0 1 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.033..0.033 rows=1 loops=1)

  • Buffers: shared hit=3
584. 0.034 0.034 ↑ 515.0 1 1

Index Only Scan using customers_pkey on customers customers_20 (cost=0.28..25.29 rows=515 width=8) (actual time=0.033..0.034 rows=1 loops=1)

  • Index Cond: (customers_20.id IS NOT NULL)
  • Buffers: shared hit=3
585. 0.007 0.506 ↓ 0.0 0 1

Sort (cost=36.3..36.34 rows=17 width=24) (actual time=0.506..0.506 rows=0 loops=1)

  • Sort Key: customer_taxonomies_15.customer_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=16
586. 0.218 0.499 ↓ 0.0 0 1

Hash Join (cost=7.46..35.95 rows=17 width=24) (actual time=0.499..0.499 rows=0 loops=1)

  • Buffers: shared hit=16
587. 0.213 0.213 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_15 (cost=0..23.87 rows=1,187 width=16) (actual time=0.003..0.213 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_15.is_deleted)
  • Buffers: shared hit=12
588. 0.005 0.068 ↑ 1.0 4 1

Hash (cost=7.41..7.41 rows=4 width=24) (actual time=0.068..0.068 rows=4 loops=1)

  • Buffers: shared hit=4
589. 0.063 0.063 ↑ 1.0 4 1

Seq Scan on taxonomies b_taxonomies_5 (cost=0..7.41 rows=4 width=24) (actual time=0.008..0.063 rows=4 loops=1)

  • Filter: ((NOT b_taxonomies_5.is_deleted) AND (b_taxonomies_5.taxonomy_type_id = 6))
  • Buffers: shared hit=4
590. 0.004 0.467 ↓ 0.0 0 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.467..0.467 rows=0 loops=1)

  • Buffers: shared hit=19
591. 0.001 0.463 ↓ 0.0 0 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.463..0.463 rows=0 loops=1)

  • Buffers: shared hit=19
592. 0.000 0.020 ↑ 515.0 1 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.02..0.02 rows=1 loops=1)

  • Buffers: shared hit=3
593. 0.020 0.020 ↑ 515.0 1 1

Index Only Scan using customers_pkey on customers customers_21 (cost=0.28..25.29 rows=515 width=8) (actual time=0.02..0.02 rows=1 loops=1)

  • Index Cond: (customers_21.id IS NOT NULL)
  • Buffers: shared hit=3
594. 0.010 0.442 ↓ 0.0 0 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.442..0.442 rows=0 loops=1)

  • Sort Key: customer_taxonomies_19.customer_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=16
595. 0.178 0.432 ↓ 0.0 0 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.432..0.432 rows=0 loops=1)

  • Buffers: shared hit=16
596. 0.189 0.189 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_19 (cost=0..23.87 rows=1,187 width=16) (actual time=0.004..0.189 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_19.is_deleted)
  • Buffers: shared hit=12
597. 0.004 0.065 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.065..0.065 rows=1 loops=1)

  • Buffers: shared hit=4
598. 0.061 0.061 ↑ 1.0 1 1

Seq Scan on taxonomies b_taxonomies_9 (cost=0..7.41 rows=1 width=24) (actual time=0.009..0.061 rows=1 loops=1)

  • Filter: ((NOT b_taxonomies_9.is_deleted) AND (b_taxonomies_9.taxonomy_type_id = 10))
  • Buffers: shared hit=4
599. 0.002 0.524 ↓ 0.0 0 1

Materialize (cost=36.1..68.91 rows=4 width=24) (actual time=0.524..0.524 rows=0 loops=1)

  • Buffers: shared hit=19
600. 0.000 0.522 ↓ 0.0 0 1

Merge Join (cost=36.1..68.9 rows=4 width=24) (actual time=0.522..0.522 rows=0 loops=1)

  • Buffers: shared hit=19
601. 0.000 0.019 ↑ 515.0 1 1

Unique (cost=0.28..26.58 rows=515 width=8) (actual time=0.019..0.019 rows=1 loops=1)

  • Buffers: shared hit=3
602. 0.019 0.019 ↑ 515.0 1 1

Index Only Scan using customers_pkey on customers customers_22 (cost=0.28..25.29 rows=515 width=8) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (customers_22.id IS NOT NULL)
  • Buffers: shared hit=3
603. 0.007 0.503 ↓ 0.0 0 1

Sort (cost=35.83..35.84 rows=4 width=24) (actual time=0.503..0.503 rows=0 loops=1)

  • Sort Key: customer_taxonomies_18.customer_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=16
604. 0.209 0.496 ↓ 0.0 0 1

Hash Join (cost=7.42..35.79 rows=4 width=24) (actual time=0.496..0.496 rows=0 loops=1)

  • Buffers: shared hit=16
605. 0.223 0.223 ↑ 1.0 1,187 1

Seq Scan on customer_taxonomies customer_taxonomies_18 (cost=0..23.87 rows=1,187 width=16) (actual time=0.003..0.223 rows=1,187 loops=1)

  • Filter: (NOT customer_taxonomies_18.is_deleted)
  • Buffers: shared hit=12
606. 0.004 0.064 ↑ 1.0 1 1

Hash (cost=7.41..7.41 rows=1 width=24) (actual time=0.064..0.064 rows=1 loops=1)

  • Buffers: shared hit=4
607. 0.060 0.060 ↑ 1.0 1 1

Seq Scan on taxonomies b_taxonomies_8 (cost=0..7.41 rows=1 width=24) (actual time=0.008..0.06 rows=1 loops=1)

  • Filter: ((NOT b_taxonomies_8.is_deleted) AND (b_taxonomies_8.taxonomy_type_id = 9))
  • Buffers: shared hit=4
Planning time : 3,666.982 ms
Execution time : 642.297 ms