explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J5Oh

Settings
# exclusive inclusive rows x rows loops node
1. 10,906.584 31,727.822 ↑ 1.0 128,786 1

GroupAggregate (cost=671,243.81..748,973.21 rows=131,312 width=932) (actual time=19,021.279..31,727.822 rows=128,786 loops=1)

  • Group Key: ((mango_events_summaries.raw ->> 'entry_id'::text)), ((mango_events_summaries.raw ->> 'call_direction'::text)), (((mango_events_summaries.raw -> 'from'::text) ->> 'number'::text)), (((mango_events_summaries.raw -> 'from'::text) ->> 'extension'::text)), (((mango_events_summaries.raw -> 'to'::text) ->> 'number'::text)), (((mango_events_summaries.raw -> 'to'::text) ->> 'extension'::text)), ((mango_events_summaries.raw ->> 'line_number'::text)), ((mango_events_summaries.raw ->> 'entry_result'::text)), ((mango_events_summaries.raw ->> 'create_time'::text)), ((mango_events_summaries.raw ->> 'forward_time'::text)), ((mango_events_summaries.raw ->> 'talk_time'::text)), ((mango_events_summaries.raw ->> 'end_time'::text)), ((mango_events_summaries.raw ->> 'disconnect_reason'::text)), mango_events_summaries.id
2. 14,721.456 20,821.238 ↓ 3.6 2,940,060 1

Sort (cost=671,243.81..673,293.28 rows=819,788 width=836) (actual time=19,021.138..20,821.238 rows=2,940,060 loops=1)

  • Sort Key: ((mango_events_summaries.raw ->> 'entry_id'::text)), ((mango_events_summaries.raw ->> 'call_direction'::text)), (((mango_events_summaries.raw -> 'from'::text) ->> 'number'::text)), (((mango_events_summaries.raw -> 'from'::text) ->> 'extension'::text)), (((mango_events_summaries.raw -> 'to'::text) ->> 'number'::text)), (((mango_events_summaries.raw -> 'to'::text) ->> 'extension'::text)), ((mango_events_summaries.raw ->> 'line_number'::text)), ((mango_events_summaries.raw ->> 'entry_result'::text)), ((mango_events_summaries.raw ->> 'create_time'::text)), ((mango_events_summaries.raw ->> 'forward_time'::text)), ((mango_events_summaries.raw ->> 'talk_time'::text)), ((mango_events_summaries.raw ->> 'end_time'::text)), ((mango_events_summaries.raw ->> 'disconnect_reason'::text)), mango_events_summaries.id
  • Sort Method: external merge Disk: 893592kB
3. 1,808.382 6,099.782 ↓ 3.6 2,940,060 1

Gather (cost=60,807.32..236,222.28 rows=819,788 width=836) (actual time=1,305.491..6,099.782 rows=2,940,060 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 2,285.100 4,291.400 ↓ 2.9 980,020 3

Hash Left Join (cost=59,807.32..132,919.55 rows=341,578 width=836) (actual time=1,295.087..4,291.400 rows=980,020 loops=3)

  • Hash Cond: (ppn_line.person_id = person_line.id)
5. 397.234 1,935.579 ↓ 2.9 980,020 3

Hash Left Join (cost=54,861.47..108,775.72 rows=337,370 width=777) (actual time=1,223.747..1,935.579 rows=980,020 loops=3)

  • Hash Cond: ((mango_events_summaries.raw ->> 'line_number'::text) = (pn_line.normalized_number)::text)
6. 23.854 1,505.692 ↑ 3.3 93,489 3

Hash Left Join (cost=51,879.08..88,663.35 rows=305,695 width=773) (actual time=1,190.816..1,505.692 rows=93,489 loops=3)

  • Hash Cond: (client_from.id = order_client_from.client_id)
7. 28.316 1,464.952 ↑ 3.3 92,490 3

Hash Left Join (cost=50,509.29..82,349.54 rows=301,930 width=773) (actual time=1,173.710..1,464.952 rows=92,490 loops=3)

  • Hash Cond: (person_from.id = employee_from.person_id)
8. 68.208 1,426.410 ↑ 3.3 92,490 3

Hash Left Join (cost=49,527.28..78,947.36 rows=301,930 width=765) (actual time=1,163.334..1,426.410 rows=92,490 loops=3)

  • Hash Cond: (((mango_events_summaries.raw -> 'from'::text) ->> 'number'::text) = (pn_from.normalized_number)::text)
9. 27.590 1,286.218 ↑ 3.2 86,811 3

Hash Left Join (cost=43,896.50..52,172.47 rows=273,582 width=729) (actual time=1,091.190..1,286.218 rows=86,811 loops=3)

  • Hash Cond: (person_to.id = employee_to.person_id)
10. 73.151 1,229.645 ↑ 3.2 86,811 3

Merge Left Join (cost=42,914.49..48,997.53 rows=273,582 width=721) (actual time=1,062.170..1,229.645 rows=86,811 loops=3)

  • Merge Cond: (((mango_events_summaries.raw ->> 'entry_id'::text)) = ((mango_events_recordings.raw ->> 'entry_id'::text)))
11. 358.176 564.586 ↓ 1.4 85,856 3

Sort (cost=31,943.70..32,096.54 rows=61,136 width=437) (actual time=504.816..564.586 rows=85,856 loops=3)

  • Sort Key: ((mango_events_summaries.raw ->> 'entry_id'::text))
  • Sort Method: external merge Disk: 37512kB
12. 53.450 206.410 ↓ 1.4 85,856 3

Hash Left Join (cost=7,063.09..19,984.32 rows=61,136 width=437) (actual time=110.918..206.410 rows=85,856 loops=3)

  • Hash Cond: (((mango_events_summaries.raw -> 'to'::text) ->> 'number'::text) = (pn_to.normalized_number)::text)
13. 42.316 42.316 ↑ 1.3 42,929 3

Parallel Seq Scan on mango_events_summaries (cost=0.00..8,685.13 rows=54,713 width=401) (actual time=0.043..42.316 rows=42,929 loops=3)

14. 10.010 110.644 ↓ 1.0 31,824 3

Hash (cost=6,672.58..6,672.58 rows=31,241 width=47) (actual time=110.644..110.644 rows=31,824 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 2691kB
15. 8.460 100.634 ↓ 1.0 32,571 3

Hash Left Join (cost=4,785.34..6,672.58 rows=31,241 width=47) (actual time=65.737..100.634 rows=32,571 loops=3)

  • Hash Cond: (person_to.id = client_to.person_id)
16. 10.153 65.606 ↓ 1.0 32,347 3

Hash Left Join (cost=2,737.01..4,365.99 rows=30,856 width=43) (actual time=39.058..65.606 rows=32,347 loops=3)

  • Hash Cond: (ppn_to.person_id = person_to.id)
17. 11.280 38.385 ↓ 1.0 32,347 3

Hash Right Join (cost=1,357.26..2,596.69 rows=30,856 width=15) (actual time=21.776..38.385 rows=32,347 loops=3)

  • Hash Cond: (ppn_to.phone_number_id = pn_to.id)
18. 5.566 5.566 ↑ 1.0 31,774 3

Seq Scan on person_phone_numbers ppn_to (cost=0.00..830.17 rows=32,417 width=8) (actual time=0.021..5.566 rows=31,774 loops=3)

19. 10.456 21.539 ↓ 1.0 32,347 3

Hash (cost=971.56..971.56 rows=30,856 width=15) (actual time=21.539..21.539 rows=32,347 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1764kB
20. 11.083 11.083 ↓ 1.0 32,347 3

Seq Scan on phone_numbers pn_to (cost=0.00..971.56 rows=30,856 width=15) (actual time=0.020..11.083 rows=32,347 loops=3)

21. 9.982 17.068 ↓ 1.0 33,678 3

Hash (cost=974.89..974.89 rows=32,389 width=32) (actual time=17.068..17.068 rows=33,678 loops=3)

  • Buckets: 65536 (originally 32768) Batches: 1 (originally 1) Memory Usage: 2648kB
22. 7.086 7.086 ↓ 1.0 33,678 3

Seq Scan on people person_to (cost=0.00..974.89 rows=32,389 width=32) (actual time=0.015..7.086 rows=33,678 loops=3)

23. 2.899 26.568 ↑ 1.0 14,823 3

Hash (cost=1,861.28..1,861.28 rows=14,964 width=8) (actual time=26.568..26.568 rows=14,823 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 707kB
24. 4.081 23.669 ↑ 1.0 14,823 3

Hash Right Join (cost=490.12..1,861.28 rows=14,964 width=8) (actual time=5.162..23.669 rows=14,823 loops=3)

  • Hash Cond: (order_client_to.client_id = client_to.id)
25. 5.225 14.651 ↑ 1.1 14,678 3

Merge Left Join (cost=0.57..1,176.00 rows=15,504 width=8) (actual time=0.083..14.651 rows=14,678 loops=3)

  • Merge Cond: (order_client_to.order_id = order_to.id)
26. 4.165 4.165 ↑ 1.1 14,678 3

Index Scan using index_crm_order_clients_on_order_id on crm_order_clients order_client_to (cost=0.29..455.44 rows=15,504 width=8) (actual time=0.029..4.165 rows=14,678 loops=3)

27. 5.261 5.261 ↓ 1.0 16,780 3

Index Only Scan using crm_orders_pkey on crm_orders order_to (cost=0.29..515.52 rows=16,533 width=4) (actual time=0.051..5.261 rows=16,780 loops=3)

  • Heap Fetches: 11992
28. 2.577 4.937 ↑ 1.0 14,650 3

Hash (cost=304.80..304.80 rows=14,780 width=8) (actual time=4.937..4.937 rows=14,650 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 701kB
29. 2.360 2.360 ↑ 1.0 14,650 3

Seq Scan on crm_clients client_to (cost=0.00..304.80 rows=14,780 width=8) (actual time=0.019..2.360 rows=14,650 loops=3)

30. 430.534 591.908 ↓ 99.4 88,939 3

Sort (cost=10,970.79..10,973.02 rows=895 width=284) (actual time=557.344..591.908 rows=88,939 loops=3)

  • Sort Key: ((mango_events_recordings.raw ->> 'entry_id'::text))
  • Sort Method: external sort Disk: 28752kB
31. 161.374 161.374 ↓ 98.3 87,985 3

Seq Scan on mango_events_recordings (cost=0.00..10,926.90 rows=895 width=284) (actual time=0.036..161.374 rows=87,985 loops=3)

  • Filter: ((raw ->> 'recording_state'::text) = 'Completed'::text)
  • Rows Removed by Filter: 88494
32. 2.409 28.983 ↓ 1.0 13,859 3

Hash (cost=809.31..809.31 rows=13,816 width=12) (actual time=28.983..28.983 rows=13,859 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 673kB
33. 2.802 26.574 ↓ 1.0 13,859 3

Hash Left Join (cost=162.52..809.31 rows=13,816 width=12) (actual time=2.269..26.574 rows=13,859 loops=3)

  • Hash Cond: (employee_to.id = hrm_employee_contracts.employee_id)
34. 22.093 22.093 ↓ 1.0 13,859 3

Seq Scan on hrm_employees employee_to (cost=0.00..582.16 rows=13,816 width=8) (actual time=0.578..22.093 rows=13,859 loops=3)

35. 0.186 1.679 ↓ 1.0 1,300 3

Hash (cost=146.49..146.49 rows=1,282 width=8) (actual time=1.679..1.679 rows=1,300 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 65kB
36. 0.315 1.493 ↓ 1.0 1,300 3

Hash Left Join (cost=110.89..146.49 rows=1,282 width=8) (actual time=0.910..1.493 rows=1,300 loops=3)

  • Hash Cond: (hrm_employee_contracts.job_id = jobs_to.id)
37. 0.200 1.081 ↓ 1.0 1,300 3

Unique (cost=106.38..113.03 rows=1,282 width=85) (actual time=0.806..1.081 rows=1,300 loops=3)

38. 0.537 0.881 ↓ 1.0 1,353 3

Sort (cost=106.38..109.71 rows=1,331 width=85) (actual time=0.805..0.881 rows=1,353 loops=3)

  • Sort Key: hrm_employee_contracts.employee_id DESC, hrm_employee_contracts.date_of_joining DESC
  • Sort Method: quicksort Memory: 154kB
39. 0.344 0.344 ↓ 1.0 1,353 3

Seq Scan on hrm_employee_contracts (cost=0.00..37.31 rows=1,331 width=85) (actual time=0.018..0.344 rows=1,353 loops=3)

40. 0.012 0.097 ↓ 1.1 71 3

Hash (cost=3.67..3.67 rows=67 width=8) (actual time=0.097..0.097 rows=71 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
41. 0.085 0.085 ↓ 1.1 71 3

Seq Scan on hrm_jobs jobs_to (cost=0.00..3.67 rows=67 width=8) (actual time=0.066..0.085 rows=71 loops=3)

42. 9.142 71.984 ↓ 1.0 31,608 3

Hash (cost=5,245.08..5,245.08 rows=30,856 width=47) (actual time=71.984..71.984 rows=31,608 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 2669kB
43. 7.815 62.842 ↓ 1.0 32,347 3

Hash Left Join (cost=3,226.56..5,245.08 rows=30,856 width=47) (actual time=30.987..62.842 rows=32,347 loops=3)

  • Hash Cond: (person_from.id = client_from.person_id)
44. 9.842 50.636 ↓ 1.0 32,347 3

Hash Left Join (cost=2,737.01..4,365.99 rows=30,856 width=43) (actual time=26.573..50.636 rows=32,347 loops=3)

  • Hash Cond: (ppn_from.person_id = person_from.id)
45. 10.854 26.234 ↓ 1.0 32,347 3

Hash Right Join (cost=1,357.26..2,596.69 rows=30,856 width=15) (actual time=11.839..26.234 rows=32,347 loops=3)

  • Hash Cond: (ppn_from.phone_number_id = pn_from.id)
46. 3.718 3.718 ↑ 1.0 31,774 3

Seq Scan on person_phone_numbers ppn_from (cost=0.00..830.17 rows=32,417 width=8) (actual time=0.008..3.718 rows=31,774 loops=3)

47. 6.064 11.662 ↓ 1.0 32,347 3

Hash (cost=971.56..971.56 rows=30,856 width=15) (actual time=11.662..11.662 rows=32,347 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1764kB
48. 5.598 5.598 ↓ 1.0 32,347 3

Seq Scan on phone_numbers pn_from (cost=0.00..971.56 rows=30,856 width=15) (actual time=0.007..5.598 rows=32,347 loops=3)

49. 8.298 14.560 ↓ 1.0 33,678 3

Hash (cost=974.89..974.89 rows=32,389 width=32) (actual time=14.560..14.560 rows=33,678 loops=3)

  • Buckets: 65536 (originally 32768) Batches: 1 (originally 1) Memory Usage: 2648kB
50. 6.262 6.262 ↓ 1.0 33,678 3

Seq Scan on people person_from (cost=0.00..974.89 rows=32,389 width=32) (actual time=0.006..6.262 rows=33,678 loops=3)

51. 2.356 4.391 ↑ 1.0 14,650 3

Hash (cost=304.80..304.80 rows=14,780 width=8) (actual time=4.391..4.391 rows=14,650 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 701kB
52. 2.035 2.035 ↑ 1.0 14,650 3

Seq Scan on crm_clients client_from (cost=0.00..304.80 rows=14,780 width=8) (actual time=0.010..2.035 rows=14,650 loops=3)

53. 2.897 10.226 ↓ 1.0 13,859 3

Hash (cost=809.31..809.31 rows=13,816 width=12) (actual time=10.226..10.226 rows=13,859 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 673kB
54. 3.213 7.329 ↓ 1.0 13,859 3

Hash Left Join (cost=162.52..809.31 rows=13,816 width=12) (actual time=1.803..7.329 rows=13,859 loops=3)

  • Hash Cond: (employee_from.id = hrm_employee_contracts_1.employee_id)
55. 2.332 2.332 ↓ 1.0 13,859 3

Seq Scan on hrm_employees employee_from (cost=0.00..582.16 rows=13,816 width=8) (actual time=0.010..2.332 rows=13,859 loops=3)

56. 0.257 1.784 ↓ 1.0 1,300 3

Hash (cost=146.49..146.49 rows=1,282 width=8) (actual time=1.784..1.784 rows=1,300 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 65kB
57. 0.307 1.527 ↓ 1.0 1,300 3

Hash Left Join (cost=110.89..146.49 rows=1,282 width=8) (actual time=0.955..1.527 rows=1,300 loops=3)

  • Hash Cond: (hrm_employee_contracts_1.job_id = jobs_from.id)
58. 0.201 1.180 ↓ 1.0 1,300 3

Unique (cost=106.38..113.03 rows=1,282 width=85) (actual time=0.899..1.180 rows=1,300 loops=3)

59. 0.674 0.979 ↓ 1.0 1,353 3

Sort (cost=106.38..109.71 rows=1,331 width=85) (actual time=0.898..0.979 rows=1,353 loops=3)

  • Sort Key: hrm_employee_contracts_1.employee_id DESC, hrm_employee_contracts_1.date_of_joining DESC
  • Sort Method: quicksort Memory: 154kB
60. 0.305 0.305 ↓ 1.0 1,353 3

Seq Scan on hrm_employee_contracts hrm_employee_contracts_1 (cost=0.00..37.31 rows=1,331 width=85) (actual time=0.007..0.305 rows=1,353 loops=3)

61. 0.017 0.040 ↓ 1.1 71 3

Hash (cost=3.67..3.67 rows=67 width=8) (actual time=0.040..0.040 rows=71 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
62. 0.023 0.023 ↓ 1.1 71 3

Seq Scan on hrm_jobs jobs_from (cost=0.00..3.67 rows=67 width=8) (actual time=0.008..0.023 rows=71 loops=3)

63. 2.836 16.886 ↑ 1.1 14,678 3

Hash (cost=1,176.00..1,176.00 rows=15,504 width=8) (actual time=16.886..16.886 rows=14,678 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 702kB
64. 5.297 14.050 ↑ 1.1 14,678 3

Merge Left Join (cost=0.57..1,176.00 rows=15,504 width=8) (actual time=0.055..14.050 rows=14,678 loops=3)

  • Merge Cond: (order_client_from.order_id = order_from.id)
65. 3.685 3.685 ↑ 1.1 14,678 3

Index Scan using index_crm_order_clients_on_order_id on crm_order_clients order_client_from (cost=0.29..455.44 rows=15,504 width=8) (actual time=0.021..3.685 rows=14,678 loops=3)

66. 5.068 5.068 ↓ 1.0 16,780 3

Index Only Scan using crm_orders_pkey on crm_orders order_from (cost=0.29..515.52 rows=16,533 width=4) (actual time=0.031..5.068 rows=16,780 loops=3)

  • Heap Fetches: 11992
67. 7.457 32.653 ↓ 1.0 31,608 3

Hash (cost=2,596.69..2,596.69 rows=30,856 width=15) (actual time=32.653..32.653 rows=31,608 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1736kB
68. 9.530 25.196 ↓ 1.0 32,347 3

Hash Right Join (cost=1,357.26..2,596.69 rows=30,856 width=15) (actual time=12.809..25.196 rows=32,347 loops=3)

  • Hash Cond: (ppn_line.phone_number_id = pn_line.id)
69. 3.149 3.149 ↑ 1.0 31,774 3

Seq Scan on person_phone_numbers ppn_line (cost=0.00..830.17 rows=32,417 width=8) (actual time=0.008..3.149 rows=31,774 loops=3)

70. 6.992 12.517 ↓ 1.0 32,347 3

Hash (cost=971.56..971.56 rows=30,856 width=15) (actual time=12.517..12.517 rows=32,347 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1764kB
71. 5.525 5.525 ↓ 1.0 32,347 3

Seq Scan on phone_numbers pn_line (cost=0.00..971.56 rows=30,856 width=15) (actual time=0.008..5.525 rows=32,347 loops=3)

72. 10.691 70.721 ↓ 1.0 33,851 3

Hash (cost=4,535.94..4,535.94 rows=32,793 width=44) (actual time=70.721..70.721 rows=33,851 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 2825kB
73. 8.768 60.030 ↓ 1.0 33,851 3

Hash Left Join (cost=3,030.33..4,535.94 rows=32,793 width=44) (actual time=36.507..60.030 rows=33,851 loops=3)

  • Hash Cond: (person_line.id = client_line.person_id)
74. 11.035 24.608 ↓ 1.0 33,678 3

Hash Left Join (cost=982.01..2,216.52 rows=32,389 width=40) (actual time=9.687..24.608 rows=33,678 loops=3)

  • Hash Cond: (person_line.id = employee_line.person_id)
75. 4.067 4.067 ↓ 1.0 33,678 3

Seq Scan on people person_line (cost=0.00..974.89 rows=32,389 width=32) (actual time=0.008..4.067 rows=33,678 loops=3)

76. 2.847 9.506 ↓ 1.0 13,859 3

Hash (cost=809.31..809.31 rows=13,816 width=12) (actual time=9.506..9.506 rows=13,859 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 673kB
77. 2.581 6.659 ↓ 1.0 13,859 3

Hash Left Join (cost=162.52..809.31 rows=13,816 width=12) (actual time=1.813..6.659 rows=13,859 loops=3)

  • Hash Cond: (employee_line.id = hrm_employee_contracts_2.employee_id)
78. 2.301 2.301 ↓ 1.0 13,859 3

Seq Scan on hrm_employees employee_line (cost=0.00..582.16 rows=13,816 width=8) (actual time=0.008..2.301 rows=13,859 loops=3)

79. 0.244 1.777 ↓ 1.0 1,300 3

Hash (cost=146.49..146.49 rows=1,282 width=8) (actual time=1.777..1.777 rows=1,300 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 65kB
80. 0.304 1.533 ↓ 1.0 1,300 3

Hash Left Join (cost=110.89..146.49 rows=1,282 width=8) (actual time=0.965..1.533 rows=1,300 loops=3)

  • Hash Cond: (hrm_employee_contracts_2.job_id = jobs_line.id)
81. 0.200 1.183 ↓ 1.0 1,300 3

Unique (cost=106.38..113.03 rows=1,282 width=85) (actual time=0.906..1.183 rows=1,300 loops=3)

82. 0.679 0.983 ↓ 1.0 1,353 3

Sort (cost=106.38..109.71 rows=1,331 width=85) (actual time=0.905..0.983 rows=1,353 loops=3)

  • Sort Key: hrm_employee_contracts_2.employee_id DESC, hrm_employee_contracts_2.date_of_joining DESC
  • Sort Method: quicksort Memory: 154kB
83. 0.304 0.304 ↓ 1.0 1,353 3

Seq Scan on hrm_employee_contracts hrm_employee_contracts_2 (cost=0.00..37.31 rows=1,331 width=85) (actual time=0.008..0.304 rows=1,353 loops=3)

84. 0.024 0.046 ↓ 1.1 71 3

Hash (cost=3.67..3.67 rows=67 width=8) (actual time=0.046..0.046 rows=71 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
85. 0.022 0.022 ↓ 1.1 71 3

Seq Scan on hrm_jobs jobs_line (cost=0.00..3.67 rows=67 width=8) (actual time=0.007..0.022 rows=71 loops=3)

86. 3.029 26.654 ↑ 1.0 14,823 3

Hash (cost=1,861.28..1,861.28 rows=14,964 width=8) (actual time=26.654..26.654 rows=14,823 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 707kB
87. 3.984 23.625 ↑ 1.0 14,823 3

Hash Right Join (cost=490.12..1,861.28 rows=14,964 width=8) (actual time=5.104..23.625 rows=14,823 loops=3)

  • Hash Cond: (order_client_line.client_id = client_line.id)
88. 5.247 14.763 ↑ 1.1 14,678 3

Merge Left Join (cost=0.57..1,176.00 rows=15,504 width=8) (actual time=0.075..14.763 rows=14,678 loops=3)

  • Merge Cond: (order_client_line.order_id = order_line.id)
89. 4.307 4.307 ↑ 1.1 14,678 3

Index Scan using index_crm_order_clients_on_order_id on crm_order_clients order_client_line (cost=0.29..455.44 rows=15,504 width=8) (actual time=0.026..4.307 rows=14,678 loops=3)

90. 5.209 5.209 ↓ 1.0 16,780 3

Index Only Scan using crm_orders_pkey on crm_orders order_line (cost=0.29..515.52 rows=16,533 width=4) (actual time=0.045..5.209 rows=16,780 loops=3)

  • Heap Fetches: 11992
91. 2.843 4.878 ↑ 1.0 14,650 3

Hash (cost=304.80..304.80 rows=14,780 width=8) (actual time=4.878..4.878 rows=14,650 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 701kB
92. 2.035 2.035 ↑ 1.0 14,650 3

Seq Scan on crm_clients client_line (cost=0.00..304.80 rows=14,780 width=8) (actual time=0.008..2.035 rows=14,650 loops=3)

Planning time : 14.089 ms
Execution time : 31,904.652 ms