1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
|
Unique (cost=49756390.50..52412720.47 rows=265632997 width=44) (actual rows=16963 loops=1)
Buffers: shared hit=484 read=869278 dirtied=782137 written=782104, temp read=1864338 written=1864338
-> Sort (cost=49756390.50..50420472.99 rows=265632997 width=44) (actual rows=389203091 loops=1)
Sort Key: four.india, four.quebec, four.romeo
Sort Method: external merge Disk: 14914368kB
Buffers: shared hit=484 read=869278 dirtied=782137 written=782104, temp read=1864338 written=1864338
-> Append (cost=1074.72..7801815.20 rows=265632997 width=44) (actual rows=389203091 loops=1)
Buffers: shared hit=475 read=869278 dirtied=782137 written=782104
-> Hash Join (cost=1074.72..5144647.71 rows=265632995 width=28) (actual rows=389203089 loops=1)
Hash Cond: (mike.romeo = four.romeo)
Buffers: shared read=869212 dirtied=782137 written=782104
-> Seq Scan on mike (cost=0.00..1630351.96 rows=76168096 width=4) (actual rows=76329862 loops=1)
Buffers: shared read=868671 dirtied=782137 written=782104
-> Hash (cost=778.21..778.21 rows=23721 width=28) (actual rows=23752 loops=1)
Buckets: 32768 Batches: 1 Memory Usage: 1676kB
Buffers: shared read=541
-> Seq Scan on four (cost=0.00..778.21 rows=23721 width=28) (actual rows=23753 loops=1)
Buffers: shared read=541
-> Seq Scan on four papa (cost=0.00..837.51 rows=2 width=28) (actual rows=2 loops=1)
Filter: ((quebec)::text = 'echo'::text)
Rows Removed by Filter: 23751
Buffers: shared hit=475 read=66
Unique (cost=35743307.84..37168307.40 rows=142499956 width=48) (actual rows=8336122 loops=1)
Buffers: shared hit=10664 read=1223591, temp read=1439499 written=1032459
-> Sort (cost=35743307.84..36099557.73 rows=142499956 width=48) (actual rows=131104186 loops=1)
Sort Key: lima.tango_xray, lima.quebec, lima.xray
Sort Method: external merge Disk: 5874440kB
Buffers: shared hit=10664 read=1223591, temp read=1439499 written=1032459
-> Append (cost=9917231.73..13876757.50 rows=142499956 width=48) (actual rows=131104186 loops=1)
Buffers: shared hit=10664 read=1223591, temp read=705180 written=298140
-> Merge Join (cost=9917231.73..12113535.56 rows=142499955 width=32) (actual rows=131104184 loops=1)
Merge Cond: (lima.xray = tango_mike.xray)
Buffers: shared read=911596, temp read=705180 written=298140
-> Sort (cost=1855656.88..1885891.23 rows=12093737 width=32) (actual rows=12125134 loops=1)
Sort Key: lima.xray
Sort Method: quicksort Memory: 1340493kB
Buffers: shared read=312027
-> Seq Scan on lima (cost=0.00..432964.37 rows=12093737 width=32) (actual rows=12125134 loops=1)
Buffers: shared read=312027
-> Sort (cost=8060359.88..8195110.08 rows=53900080 width=8) (actual rows=131104540 loops=1)
Sort Key: tango_mike.xray
Sort Method: external sort Disk: 1192552kB
Buffers: shared read=599569, temp read=501699 written=298140
-> Seq Scan on tango_mike (cost=0.00..1138569.80 rows=53900080 width=8) (actual rows=55453373 loops=1)
Buffers: shared read=599569
-> Gather (cost=1000.00..338222.39 rows=1 width=32) (actual rows=2 loops=1)
Workers Planned: 6
Workers Launched: 6
Buffers: shared hit=10664 read=311995
-> Parallel Seq Scan on lima golf (cost=0.00..337222.29 rows=1 width=32) (actual rows=0 loops=7)
Filter: ((quebec)::text = 'echo'::text)
Rows Removed by Filter: 1732162
Buffers: shared hit=122 read=311995
Group (cost=4164445.30..4175997.52 rows=385074 width=264) (actual time=206821.675..206875.256 rows=4486 loops=1)
Group Key: echo_whiskey0.kilo_bravo, [...]
Buffers: shared hit=1390631 read=993857 written=40265, local hit=26
I/O Timings: read=1567607.774 write=488.689
-> Sort (cost=4164445.30..4165407.98 rows=385074 width=264) (actual time=206821.611..206872.674 rows=4669 loops=1)
Sort Key: echo_whiskey0.kilo_bravo,[...]
Sort Method: quicksort Memory: 1737kB
Buffers: shared hit=1390631 read=993857 written=40265, local hit=26
I/O Timings: read=1567607.774 write=488.689
-> Hash Semi Join (cost=61200.47..4128720.49 rows=385074 width=264) (actual time=2241.552..206857.688 rows=4669 loops=1)
Hash Cond: ((echo_whiskey0.papa)::text = (golf.hotel)::text)
Buffers: shared hit=1390628 read=993857 written=40265, local hit=26
I/O Timings: read=1567607.774 write=488.689
-> Gather (cost=61043.48..4123268.73 rows=385074 width=232) (actual time=1487.139..206127.826 rows=380948 loops=1)
Workers Planned: 7
Workers Launched: 7
Buffers: shared hit=1390628 read=993857 written=40265
I/O Timings: read=1567607.774 write=488.689
-> Parallel Hash Join (cost=60043.48..4083761.33 rows=55011 width=232) (actual time=1479.129..206052.797 rows=47618 loops=8)
Hash Cond: (echo_whiskey0.victor_romeo = zulu_alpha1.delta)
Buffers: shared hit=1390628 read=993857 written=40265
I/O Timings: read=1567607.774 write=488.689
-> Parallel Hash Join (cost=58129.39..4081317.34 rows=55011 width=202) (actual time=882.995..205409.189 rows=47618 loops=8)
Hash Cond: (echo_whiskey0.romeo = zulu_alpha1kilo_oscar1.delta)
Buffers: shared hit=1390051 read=992531 written=40265
I/O Timings: read=1567535.726 write=488.689
-> Nested Loop (cost=56215.30..4078873.35 rows=55011 width=172) (actual time=880.305..205357.815 rows=47618 loops=8)
Buffers: shared hit=1388344 read=992531 written=40265
I/O Timings: read=1567535.726 write=488.689
-> Hash Join (cost=56214.87..3978622.48 rows=55011 width=176) (actual time=841.911..65184.969 rows=47618 loops=8)
Hash Cond: (echo_whiskey0.charlie_india = whiskey_delta0.charlie_india)
Buffers: shared hit=2842 read=854234 written=34524
I/O Timings: read=499073.802 write=421.296
-> Hash Join (cost=55668.42..3977931.56 rows=55011 width=132) (actual time=789.705..65085.512 rows=47618 loops=8)
Hash Cond: (echo_whiskey0.whiskey_six = juliet01.whiskey_six)
-> Parallel Bitmap Heap Scan on p_fait_radio_qdoc p_fait_radio_qdoc0
Buffers: shared hit=357 read=853879 written=34524
I/O Timings: read=499028.808 write=421.296
-> (cost=55614.03..3976535.39 rows=211114 width=104) (cost=0.00..0.00 rows=0 width=0) (actual time=789.126..64998.813 rows=188462 loops=8)
Recheck Cond: ((kilo_bravo >= 'two'::date) AND (kilo_bravo < 'tango'::date))
Filter: (((charlie_oscar)::text = 'xray'::text) AND ((six_foxtrot)::text = 'november'::text))
Rows Removed by Filter: 140321
Heap Blocks: exact=106838
-> Bitmap Index Scan on p_fait_radio_qdoc_dt_examen_idx
Buffers: shared hit=8 read=853879 written=34524
I/O Timings: read=499028.808 write=421.296
-> (cost=0.00..55244.59 rows=2632802 width=0) (cost=0.00..0.00 rows=0 width=0) (actual time=538.316..538.325 rows=2630265 loops=1)
Index Cond: ((kilo_bravo >= 'two'::date) AND (kilo_bravo < 'tango'::date))
Buffers: shared hit=3 read=7191
I/O Timings: read=87.617
-> Hash (cost=51.99..51.99 rows=191 width=36) (actual time=0.526..0.532 rows=191 loops=8)
Buckets: 1024 Batches: 1 Memory Usage: 23kB
Buffers: shared hit=349
-> Seq Scan on juliet yankee (cost=0.00..51.99 rows=191 width=36) (actual time=0.070..0.492 rows=191 loops=8)
Filter: ((victor_tango)::text = ANY ('{"seven_tango",[...]))
Rows Removed by Filter: 542
Buffers: shared hit=349
-> Hash (cost=440.09..440.09 rows=8509 width=52) (actual time=52.166..52.167 rows=8509 loops=8)
Buckets: 16384 Batches: 1 Memory Usage: 842kB
Buffers: shared hit=2485 read=355
I/O Timings: read=44.994
-> Seq Scan on whiskey_delta kilo_six (cost=0.00..440.09 rows=8509 width=52) (actual time=24.144..50.757 rows=8509 loops=8)
Buffers: shared hit=2485 read=355
I/O Timings: read=44.994
-> Index Only Scan using echo_mike on seven_delta six_yankee (cost=0.43..1.82 rows=1 width=4) (actual time=2.942..2.942 rows=1 loops=380948)
Index Cond: (three = echo_whiskey0.three)
Heap Fetches: 380948
Buffers: shared hit=1385502 read=138297 written=5741
I/O Timings: read=1068461.924 write=67.392
-> Parallel Hash (cost=1799.04..1799.04 rows=9204 width=38) (actual time=2.613..2.614 rows=1956 loops=8)
Buckets: 16384 Batches: 1 Memory Usage: 1376kB
Buffers: shared hit=1707
-> Parallel Seq Scan on oscar zulu_hotel (cost=0.00..1799.04 rows=9204 width=38) (actual time=0.019..1.744 rows=1956 loops=8)
Buffers: shared hit=1707
-> Parallel Hash (cost=1799.04..1799.04 rows=9204 width=38) (actual time=595.923..595.925 rows=1956 loops=8)
Buckets: 16384 Batches: 1 Memory Usage: 1504kB
Buffers: shared hit=381 read=1326
I/O Timings: read=72.048
-> Parallel Seq Scan on oscar quebec (cost=0.00..1799.04 rows=9204 width=38) (actual time=485.918..495.799 rows=1956 loops=8)
Buffers: shared hit=381 read=1326
I/O Timings: read=72.048
-> Hash (cost=84.22..84.22 rows=5822 width=8) (actual time=611.099..611.105 rows=5822 loops=1)
Buckets: 8192 Batches: 1 Memory Usage: 292kB
Buffers: local hit=26
-> Seq Scan on golf (cost=0.00..84.22 rows=5822 width=8) (actual time=0.010..0.317 rows=5822 loops=1)
Buffers: local hit=26
Planning time: 2.748 ms
JIT:
Functions: 361
Options: Expressions true, Deforming true, Optimization true, Inlining true
Timing: Inlining 289.335 ms, Optimization 2473.925 ms, Total 4530.841 ms, Generation 43.386 ms, Emission 1724.195 ms
Execution time: 206882.405 ms
|
