explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8lgz : Vendor_Summary_Sept

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 449,797.070 ↓ 21,618.0 4,323,599 1

Unique (cost=4,261,369,724,804.00..4,292,373,203,224.20 rows=200 width=158) (actual time=447,427.215..449,797.070 rows=4,323,599 loops=1)

2. 10,220.482 448,771.648 ↑ 1,413,820.2 4,385,774 1

Sort (cost=4,261,369,724,804.00..4,276,871,464,014.10 rows=6,200,695,684,039 width=158) (actual time=447,427.213..448,771.648 rows=4,385,774 loops=1)

  • Sort Key: cdrs_connections37.i_cdrs_connection, (length((dest.prefix)::text)) DESC
  • Sort Method: external sort Disk: 413824kB
3. 276,788.887 438,551.166 ↑ 1,413,820.2 4,385,774 1

Nested Loop (cost=14.54..19,117,120,832.14 rows=6,200,695,684,039 width=158) (actual time=0.706..438,551.166 rows=4,385,774 loops=1)

4. 145,293.008 161,762.279 ↑ 6.3 4,385,774 1

Nested Loop Left Join (cost=14.12..59,805,748.36 rows=27,656,764 width=88) (actual time=0.594..161,762.279 rows=4,385,774 loops=1)

5. 3,071.949 16,469.271 ↓ 1.6 4,323,599 1

Hash Join (cost=13.58..467,041.57 rows=2,766,490 width=80) (actual time=0.259..16,469.271 rows=4,323,599 loops=1)

  • Hash Cond: (cdrs_connections37.i_connection = connections.i_connection)
6. 5,819.815 13,397.322 ↓ 1.0 5,533,645 1

Append (cost=0.42..440,543.21 rows=5,532,979 width=80) (actual time=0.131..13,397.322 rows=5,533,645 loops=1)

7. 173.159 173.159 ↓ 1.0 80,717 1

Index Scan using cdrs_connections37_call_setup_time on cdrs_connections37 (cost=0.42..6,379.75 rows=80,376 width=80) (actual time=0.129..173.159 rows=80,717 loops=1)

  • Index Cond: ((call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
  • Filter: (duration > '0'::double precision)
8. 337.560 337.560 ↓ 1.0 150,346 1

Index Scan using cdrs_connections55_i_call on cdrs_connections55 (cost=0.42..12,021.16 rows=150,331 width=80) (actual time=0.067..337.560 rows=150,346 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
9. 279.978 279.978 ↓ 1.0 126,751 1

Index Scan using cdrs_connections56_i_call on cdrs_connections56 (cost=0.42..10,174.08 rows=126,738 width=80) (actual time=0.061..279.978 rows=126,751 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
10. 290.309 290.309 ↓ 1.0 135,889 1

Index Scan using cdrs_connections57_i_call on cdrs_connections57 (cost=0.42..10,867.36 rows=135,875 width=80) (actual time=0.064..290.309 rows=135,889 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
11. 421.036 421.036 ↓ 1.0 177,718 1

Index Scan using cdrs_connections58_i_call on cdrs_connections58 (cost=0.42..14,174.26 rows=177,700 width=80) (actual time=0.064..421.036 rows=177,718 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
12. 552.468 552.468 ↓ 1.0 238,850 1

Index Scan using cdrs_connections21_i_call on cdrs_connections21 (cost=0.42..18,893.21 rows=238,826 width=80) (actual time=0.067..552.468 rows=238,850 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
13. 314.135 314.135 ↓ 1.0 141,692 1

Index Scan using cdrs_connections51_i_call on cdrs_connections51 (cost=0.42..11,294.07 rows=141,678 width=80) (actual time=0.070..314.135 rows=141,692 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
14. 267.473 267.473 ↓ 1.0 127,519 1

Index Scan using cdrs_connections59_i_call on cdrs_connections59 (cost=0.42..10,219.68 rows=127,506 width=80) (actual time=0.072..267.473 rows=127,519 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
15. 645.536 645.536 ↓ 1.0 256,512 1

Index Scan using cdrs_connections60_i_call on cdrs_connections60 (cost=0.42..20,133.79 rows=256,486 width=80) (actual time=0.069..645.536 rows=256,512 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
16. 654.972 654.972 ↓ 1.0 283,896 1

Index Scan using cdrs_connections61_i_call on cdrs_connections61 (cost=0.42..22,362.31 rows=283,868 width=80) (actual time=0.073..654.972 rows=283,896 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
17. 820.152 820.152 ↓ 1.0 334,290 1

Index Scan using cdrs_connections11_i_call on cdrs_connections11 (cost=0.42..26,240.97 rows=334,257 width=80) (actual time=0.083..820.152 rows=334,290 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
18. 751.379 751.379 ↓ 1.0 320,560 1

Index Scan using cdrs_connections54_i_call on cdrs_connections54 (cost=0.42..25,240.35 rows=320,528 width=80) (actual time=0.077..751.379 rows=320,560 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
19. 607.313 607.313 ↓ 1.0 274,180 1

Index Scan using cdrs_connections62_i_call on cdrs_connections62 (cost=0.42..21,888.95 rows=274,153 width=80) (actual time=0.074..607.313 rows=274,180 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
20. 746.968 746.968 ↓ 1.0 332,338 1

Index Scan using cdrs_connections63_i_call on cdrs_connections63 (cost=0.42..26,277.79 rows=332,305 width=80) (actual time=0.071..746.968 rows=332,338 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
21. 715.069 715.069 ↓ 1.0 308,887 1

Index Scan using cdrs_connections2_i_call on cdrs_connections2 (cost=0.42..24,144.09 rows=308,856 width=80) (actual time=0.079..715.069 rows=308,887 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timest
22. 0.000 744.279 ↓ 1.0 312,327 1

Index Scan using cdrs_connections64_i_call on cdrs_connections64 (cost=0.42..24,582.61 rows=312,296 width=80) (actual time=0.076..744.279 rows=312,327 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
23. 672.725 672.725 ↓ 1.0 268,430 1

Index Scan using cdrs_connections120_i_call on cdrs_connections120 (cost=0.42..21,236.39 rows=268,403 width=80) (actual time=0.072..672.725 rows=268,430 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
24. 555.009 555.009 ↓ 1.0 249,284 1

Index Scan using cdrs_connections65_i_call on cdrs_connections65 (cost=0.42..19,668.31 rows=249,259 width=80) (actual time=0.077..555.009 rows=249,284 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
25. 478.762 478.762 ↓ 1.0 215,819 1

Index Scan using cdrs_connections66_i_call on cdrs_connections66 (cost=0.42..17,096.04 rows=215,797 width=80) (actual time=0.072..478.762 rows=215,819 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
26. 275.093 275.093 ↓ 1.0 130,525 1

Index Scan using cdrs_connections26_i_call on cdrs_connections26 (cost=0.42..10,492.89 rows=130,512 width=80) (actual time=0.080..275.093 rows=130,525 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
27. 228.563 228.563 ↓ 1.0 106,680 1

Index Scan using cdrs_connections1_i_call on cdrs_connections1 (cost=0.42..8,799.71 rows=106,669 width=80) (actual time=0.074..228.563 rows=106,680 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
28. 208.690 208.690 ↓ 1.0 90,206 1

Index Scan using cdrs_connections119_i_call on cdrs_connections119 (cost=0.29..7,251.80 rows=90,197 width=80) (actual time=0.060..208.690 rows=90,206 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
29. 221.938 221.938 ↓ 1.0 95,766 1

Index Scan using cdrs_connections12_i_call on cdrs_connections12 (cost=0.29..7,952.88 rows=95,756 width=80) (actual time=0.063..221.938 rows=95,766 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
30. 286.274 286.274 ↓ 1.0 129,308 1

Index Scan using cdrs_connections121_i_call on cdrs_connections121 (cost=0.42..10,330.80 rows=129,295 width=80) (actual time=0.082..286.274 rows=129,308 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
31. 174.890 174.890 ↓ 1.0 81,340 1

Index Scan using cdrs_connections122_i_call on cdrs_connections122 (cost=0.29..6,820.51 rows=81,332 width=80) (actual time=0.060..174.890 rows=81,340 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
32. 219.043 219.043 ↓ 1.0 98,839 1

Index Scan using cdrs_connections123_i_call on cdrs_connections123 (cost=0.29..8,326.37 rows=98,829 width=80) (actual time=0.067..219.043 rows=98,839 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
33. 310.703 310.703 ↓ 1.0 142,457 1

Index Scan using cdrs_connections124_i_call on cdrs_connections124 (cost=0.42..11,358.53 rows=142,443 width=80) (actual time=0.074..310.703 rows=142,457 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
34. 96.958 96.958 ↓ 1.0 48,167 1

Index Scan using cdrs_connections125_i_call on cdrs_connections125 (cost=0.29..3,951.79 rows=48,162 width=80) (actual time=0.056..96.958 rows=48,167 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
35. 196.374 196.374 ↓ 1.0 93,105 1

Index Scan using cdrs_connections116_i_call on cdrs_connections116 (cost=0.29..7,511.28 rows=93,096 width=80) (actual time=0.061..196.374 rows=93,105 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
36. 235.763 235.763 ↓ 1.0 114,696 1

Index Scan using cdrs_connections117_i_call on cdrs_connections117 (cost=0.42..9,196.08 rows=114,685 width=80) (actual time=0.070..235.763 rows=114,696 loops=1)

  • Filter: ((duration > '0'::double precision) AND (call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
37. 140.508 140.508 ↑ 1.0 66,551 1

Index Scan using cdrs_connections126_call_setup_time on cdrs_connections126 (cost=0.29..5,655.41 rows=66,765 width=80) (actual time=0.063..140.508 rows=66,551 loops=1)

  • Index Cond: ((call_setup_time >= '2019-09-01 00:00:00+00'::timestamp with time zone) AND (call_setup_time <= '2019-10-01 00:00:00+00'::timestamp with time zone))
  • Filter: (duration > '0'::double precision)
38. 0.020 0.108 ↑ 1.0 31 1

Hash (cost=12.78..12.78 rows=31 width=8) (actual time=0.108..0.108 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
39. 0.049 0.088 ↑ 1.0 31 1

Bitmap Heap Scan on connections (cost=4.39..12.78 rows=31 width=8) (actual time=0.054..0.088 rows=31 loops=1)

  • Recheck Cond: (i_vendor = '12'::bigint)
  • Heap Blocks: exact=7
40. 0.039 0.039 ↑ 1.0 31 1

Bitmap Index Scan on connections_i_vendor (cost=0.00..4.38 rows=31 width=0) (actual time=0.039..0.039 rows=31 loops=1)

  • Index Cond: (i_vendor = '12'::bigint)
41. 0.000 64,853.985 ↑ 10.0 1 4,323,599

Index Only Scan using destinations_prefix2 on destinations dest (cost=0.54..21.35 rows=10 width=8) (actual time=0.011..0.015 rows=1 loops=4,323,599)

  • Index Cond: (prefix = ANY ((prefixes(cdrs_connections37.prefix))::text[]))
  • Heap Fetches: 0
42. 0.000 263,146.440 ↑ 31.0 1 4,385,774

Append (cost=0.42..128.25 rows=31 width=8) (actual time=0.029..0.060 rows=1 loops=4,385,774)

43. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls37_pkey on calls37 (cost=0.42..4.13 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 59524
44. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls55_pkey on calls55 (cost=0.42..4.13 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 100956
45. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls56_pkey on calls56 (cost=0.43..4.14 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 84845
46. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls57_pkey on calls57 (cost=0.43..4.14 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 90372
47. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls58_pkey on calls58 (cost=0.43..4.14 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 138110
48. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls21_pkey on calls21 (cost=0.43..4.14 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 196107
49. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls51_pkey on calls51 (cost=0.43..4.13 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 105518
50. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls59_pkey on calls59 (cost=0.43..4.13 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 91354
51. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls60_pkey on calls60 (cost=0.43..4.14 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 208554
52. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls61_pkey on calls61 (cost=0.43..4.14 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 223033
53. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls11_pkey on calls11 (cost=0.43..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 272993
54. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls54_pkey on calls54 (cost=0.43..4.14 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 263641
55. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls62_pkey on calls62 (cost=0.43..4.14 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 203952
56. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls63_pkey on calls63 (cost=0.43..4.15 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 253254
57. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls2_pkey on calls2 (cost=0.43..4.15 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 269726
58. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls64_pkey on calls64 (cost=0.43..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 260667
59. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls120_pkey on calls120 (cost=0.43..4.18 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 219311
60. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls65_pkey on calls65 (cost=0.43..4.14 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 210849
61. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls66_pkey on calls66 (cost=0.43..4.14 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 176186
62. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls26_pkey on calls26 (cost=0.42..4.13 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 93047
63. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls1_pkey on calls1 (cost=0.42..4.13 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 79048
64. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls119_pkey on calls119 (cost=0.42..4.12 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 74387
65. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls12_pkey on calls12 (cost=0.42..4.13 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 83482
66. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls121_pkey on calls121 (cost=0.42..4.13 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 107292
67. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls122_pkey on calls122 (cost=0.42..4.12 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 59498
68. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls123_pkey on calls123 (cost=0.43..4.13 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 74896
69. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls124_pkey on calls124 (cost=0.43..4.13 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 118846
70. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls125_pkey on calls125 (cost=0.42..4.12 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 40108
71. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls116_pkey on calls116 (cost=0.42..4.13 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 77337
72. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls117_pkey on calls117 (cost=0.42..4.13 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 93133
73. 8,771.548 8,771.548 ↓ 0.0 0 4,385,774

Index Only Scan using calls126_pkey on calls126 (cost=0.42..4.13 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,385,774)

  • Index Cond: (i_call = cdrs_connections37.i_call)
  • Heap Fetches: 55748
Planning time : 57.412 ms
Execution time : 452,852.860 ms