explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hVGf

Settings
# exclusive inclusive rows x rows loops node
1. 0.107 1,712,573.284 ↑ 1.0 400 1

Hash Left Join (cost=17,802,540.48..17,802,614.04 rows=400 width=172) (actual time=1,712,572.708..1,712,573.284 rows=400 loops=1)

  • Output: people.id, people.name, aliases.aliases, date_of_birth.year_born, education.educated_at, occupation.occupation, date_of_death.year_deceased, country_of_citizenship.countries
  • Hash Cond: (people.id = country_of_citizenship.id)
  • Buffers: shared hit=14091 read=3548822
2.          

CTE people

3. 0.035 3.309 ↑ 1.0 400 1

Limit (cost=0.56..5,621.37 rows=400 width=60) (actual time=0.019..3.309 rows=400 loops=1)

  • Output: people_1.source_item_id, names.en_label
  • Buffers: shared hit=2072 read=43
4. 0.178 3.274 ↑ 2,251.2 400 1

Nested Loop (cost=0.56..12,653,651.44 rows=900,486 width=60) (actual time=0.018..3.274 rows=400 loops=1)

  • Output: people_1.source_item_id, names.en_label
  • Buffers: shared hit=2072 read=43
5. 2.296 2.296 ↑ 2,251.2 400 1

Seq Scan on wikidata_20180827.qpq_item_statements people_1 (cost=0.00..6,570,441.48 rows=900,486 width=4) (actual time=0.009..2.296 rows=400 loops=1)

  • Output: people_1.id, people_1.source_item_id, people_1.edge_property_id, people_1.target_item_id, people_1.el_rank
  • Filter: ((people_1.edge_property_id = 31) AND (people_1.target_item_id = 5))
  • Rows Removed by Filter: 9137
  • Buffers: shared hit=92 read=17
6. 0.800 0.800 ↑ 1.0 1 400

Index Scan using item_pkey on wikidata_20180827.item names (cost=0.56..6.75 rows=1 width=60) (actual time=0.002..0.002 rows=1 loops=400)

  • Output: names.id, names.en_label, names.en_label_norm, names.en_description, names.enwiki_title
  • Index Cond: (names.id = people_1.source_item_id)
  • Buffers: shared hit=1980 read=26
7.          

CTE aliases

8. 0.152 4.091 ↑ 1.7 116 1

HashAggregate (cost=12,597.84..12,600.34 rows=200 width=36) (actual time=4.070..4.091 rows=116 loops=1)

  • Output: people_2.id, string_agg(aliases_1.alias_name, '|'::text)
  • Group Key: people_2.id
  • Buffers: shared hit=1301 read=17
9. 0.000 3.939 ↑ 14.5 191 1

Nested Loop (cost=0.43..12,584.01 rows=2,765 width=21) (actual time=1.749..3.939 rows=191 loops=1)

  • Output: people_2.id, aliases_1.alias_name
  • Buffers: shared hit=1301 read=17
10. 0.034 0.034 ↑ 1.0 400 1

CTE Scan on people people_2 (cost=0.00..8.00 rows=400 width=4) (actual time=0.000..0.034 rows=400 loops=1)

  • Output: people_2.id, people_2.name
11. 4.000 4.000 ↓ 0.0 0 400

Index Scan using item_aliases_item_id_idx on wikidata_20180827.item_aliases aliases_1 (cost=0.43..31.37 rows=7 width=21) (actual time=0.009..0.010 rows=0 loops=400)

  • Output: aliases_1.id, aliases_1.item_id, aliases_1.alias_name, aliases_1.alias_name_norm, aliases_1.lang
  • Index Cond: (aliases_1.item_id = people_2.id)
  • Filter: (aliases_1.lang = 'en'::text)
  • Buffers: shared hit=1301 read=17
12.          

CTE date_of_birth

13. 0.255 1,025,286.217 ↓ 4.7 397 1

GroupAggregate (cost=8,229,599.90..8,229,602.45 rows=85 width=8) (actual time=1,025,285.950..1,025,286.217 rows=397 loops=1)

  • Output: raw_statements.source_item_id, min(("substring"(((raw_statements.target_datavalue -> 'value'::text) ->> 'time'::text), 2, 4))::integer)
  • Group Key: raw_statements.source_item_id
  • Buffers: shared hit=2422 read=1973842
14. 0.166 1,025,285.962 ↓ 4.8 412 1

Sort (cost=8,229,599.90..8,229,600.11 rows=85 width=102) (actual time=1,025,285.930..1,025,285.962 rows=412 loops=1)

  • Output: raw_statements.source_item_id, raw_statements.target_datavalue
  • Sort Key: raw_statements.source_item_id
  • Sort Method: quicksort Memory: 134kB
  • Buffers: shared hit=2422 read=1973842
15. 708.757 1,025,285.796 ↓ 4.8 412 1

Hash Join (cost=65,193.96..8,229,597.17 rows=85 width=102) (actual time=1,661.858..1,025,285.796 rows=412 loops=1)

  • Output: raw_statements.source_item_id, raw_statements.target_datavalue
  • Hash Cond: (raw_statements.source_item_id = people_3.id)
  • Buffers: shared hit=2422 read=1973842
16. 1,023,636.654 1,024,573.543 ↓ 183.8 3,243,005 1

Bitmap Heap Scan on wikidata_20180827.item_statements raw_statements (cost=65,180.96..8,228,656.96 rows=17,645 width=102) (actual time=1,652.324..1,024,573.543 rows=3,243,005 loops=1)

  • Output: raw_statements.id, raw_statements.mainsnak_datatype, raw_statements.datavalue_datatype, raw_statements.source_item_id, raw_statements.edge_property_id, raw_statements.target_datavalue, raw_statements.el_rank
  • Recheck Cond: (raw_statements.edge_property_id = 569)
  • Filter: ("substring"(((raw_statements.target_datavalue -> 'value'::text) ->> 'time'::text), 1, 1) = '+'::text)
  • Rows Removed by Filter: 5345
  • Heap Blocks: exact=1965276
  • Buffers: shared hit=356 read=1973799
17. 936.889 936.889 ↑ 1.1 3,248,350 1

Bitmap Index Scan on item_statements_edge_property_id_idx (cost=0.00..65,176.55 rows=3,529,063 width=0) (actual time=936.889..936.889 rows=3,248,350 loops=1)

  • Index Cond: (raw_statements.edge_property_id = 569)
  • Buffers: shared read=8879
18. 0.066 3.496 ↑ 1.0 400 1

Hash (cost=8.00..8.00 rows=400 width=4) (actual time=3.496..3.496 rows=400 loops=1)

  • Output: people_3.id
  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
  • Buffers: shared hit=2066 read=43
19. 3.430 3.430 ↑ 1.0 400 1

CTE Scan on people people_3 (cost=0.00..8.00 rows=400 width=4) (actual time=0.001..3.430 rows=400 loops=1)

  • Output: people_3.id
  • Buffers: shared hit=2066 read=43
20.          

CTE education

21. 0.079 79,116.004 ↑ 1.4 140 1

GroupAggregate (cost=341,643.69..341,647.85 rows=200 width=36) (actual time=79,115.919..79,116.004 rows=140 loops=1)

  • Output: people_4.id, string_agg(schools.en_label, '|'::text)
  • Group Key: people_4.id
  • Buffers: shared hit=763 read=388580
22. 0.094 79,115.925 ↑ 1.2 190 1

Sort (cost=341,643.69..341,644.24 rows=221 width=60) (actual time=79,115.907..79,115.925 rows=190 loops=1)

  • Output: people_4.id, schools.en_label
  • Sort Key: people_4.id
  • Sort Method: quicksort Memory: 39kB
  • Buffers: shared hit=763 read=388580
23. 0.008 79,115.831 ↑ 1.2 190 1

Nested Loop (cost=1,848.87..341,635.08 rows=221 width=60) (actual time=299.585..79,115.831 rows=190 loops=1)

  • Output: people_4.id, schools.en_label
  • Buffers: shared hit=763 read=388580
24. 146.874 79,021.583 ↑ 1.2 190 1

Hash Join (cost=1,848.30..339,944.49 rows=221 width=8) (actual time=297.977..79,021.583 rows=190 loops=1)

  • Output: people_4.id, education_1.target_item_id
  • Hash Cond: (education_1.source_item_id = people_4.id)
  • Buffers: shared hit=1 read=388392
25. 78,717.443 78,874.603 ↓ 9.1 890,019 1

Bitmap Heap Scan on wikidata_20180827.qpq_item_statements education_1 (cost=1,835.30..334,789.48 rows=97,901 width=8) (actual time=260.313..78,874.603 rows=890,019 loops=1)

  • Output: education_1.id, education_1.source_item_id, education_1.edge_property_id, education_1.target_item_id, education_1.el_rank
  • Recheck Cond: (education_1.edge_property_id = 69)
  • Heap Blocks: exact=385957
  • Buffers: shared hit=1 read=388392
26. 157.160 157.160 ↓ 9.1 890,019 1

Bitmap Index Scan on qpq_item_statements_edge_property_id_idx (cost=0.00..1,810.83 rows=97,901 width=0) (actual time=157.160..157.160 rows=890,019 loops=1)

  • Index Cond: (education_1.edge_property_id = 69)
  • Buffers: shared read=2436
27. 0.056 0.106 ↑ 1.0 400 1

Hash (cost=8.00..8.00 rows=400 width=4) (actual time=0.106..0.106 rows=400 loops=1)

  • Output: people_4.id
  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
28. 0.050 0.050 ↑ 1.0 400 1

CTE Scan on people people_4 (cost=0.00..8.00 rows=400 width=4) (actual time=0.000..0.050 rows=400 loops=1)

  • Output: people_4.id
29. 94.240 94.240 ↑ 1.0 1 190

Index Scan using item_pkey on wikidata_20180827.item schools (cost=0.56..7.64 rows=1 width=60) (actual time=0.496..0.496 rows=1 loops=190)

  • Output: schools.id, schools.en_label, schools.en_label_norm, schools.en_description, schools.enwiki_title
  • Index Cond: (schools.id = education_1.target_item_id)
  • Buffers: shared hit=762 read=188
30.          

CTE occupation

31. 0.206 244.445 ↓ 1.8 356 1

GroupAggregate (cost=2,094,818.72..2,094,890.52 rows=200 width=36) (actual time=244.182..244.445 rows=356 loops=1)

  • Output: people_5.id, string_agg(occupations_labels.en_label, '|'::text)
  • Group Key: people_5.id
  • Buffers: shared hit=5341 read=691
32. 0.285 244.239 ↑ 11.8 785 1

Sort (cost=2,094,818.72..2,094,841.82 rows=9,241 width=60) (actual time=244.170..244.239 rows=785 loops=1)

  • Output: people_5.id, occupations_labels.en_label
  • Sort Key: people_5.id
  • Sort Method: quicksort Memory: 72kB
  • Buffers: shared hit=5341 read=691
33. 0.674 243.954 ↑ 11.8 785 1

Nested Loop (cost=1.14..2,094,210.02 rows=9,241 width=60) (actual time=2.124..243.954 rows=785 loops=1)

  • Output: people_5.id, occupations_labels.en_label
  • Buffers: shared hit=5341 read=691
34. 0.072 7.780 ↑ 11.8 785 1

Nested Loop (cost=0.57..2,033,035.72 rows=9,241 width=8) (actual time=2.102..7.780 rows=785 loops=1)

  • Output: people_5.id, occupations_enc.target_item_id
  • Buffers: shared hit=1899 read=208
35. 0.108 0.108 ↑ 1.0 400 1

CTE Scan on people people_5 (cost=0.00..8.00 rows=400 width=4) (actual time=0.001..0.108 rows=400 loops=1)

  • Output: people_5.id, people_5.name
36. 7.600 7.600 ↑ 11.5 2 400

Index Scan using qpq_item_statements_source_item_id_idx on wikidata_20180827.qpq_item_statements occupations_enc (cost=0.57..5,082.34 rows=23 width=8) (actual time=0.015..0.019 rows=2 loops=400)

  • Output: occupations_enc.id, occupations_enc.source_item_id, occupations_enc.edge_property_id, occupations_enc.target_item_id, occupations_enc.el_rank
  • Index Cond: (occupations_enc.source_item_id = people_5.id)
  • Filter: (occupations_enc.edge_property_id = 106)
  • Rows Removed by Filter: 15
  • Buffers: shared hit=1899 read=208
37. 235.500 235.500 ↑ 1.0 1 785

Index Scan using item_pkey on wikidata_20180827.item occupations_labels (cost=0.56..6.61 rows=1 width=60) (actual time=0.300..0.300 rows=1 loops=785)

  • Output: occupations_labels.id, occupations_labels.en_label, occupations_labels.en_label_norm, occupations_labels.en_description, occupations_labels.enwiki_title
  • Index Cond: (occupations_labels.id = occupations_enc.target_item_id)
  • Buffers: shared hit=3442 read=483
38.          

CTE date_of_death

39. 0.208 607,876.685 ↓ 6.7 288 1

GroupAggregate (cost=5,035,282.47..5,035,283.76 rows=43 width=8) (actual time=607,876.463..607,876.685 rows=288 loops=1)

  • Output: raw_statements_1.source_item_id, max(("substring"(((raw_statements_1.target_datavalue -> 'value'::text) ->> 'time'::text), 2, 4))::integer)
  • Group Key: raw_statements_1.source_item_id
  • Buffers: shared hit=1 read=1185411
40. 0.156 607,876.477 ↓ 7.3 312 1

Sort (cost=5,035,282.47..5,035,282.57 rows=43 width=102) (actual time=607,876.443..607,876.477 rows=312 loops=1)

  • Output: raw_statements_1.source_item_id, raw_statements_1.target_datavalue
  • Sort Key: raw_statements_1.source_item_id
  • Sort Method: quicksort Memory: 107kB
  • Buffers: shared hit=1 read=1185411
41. 407.732 607,876.321 ↓ 7.3 312 1

Hash Join (cost=32,930.13..5,035,281.30 rows=43 width=102) (actual time=944.030..607,876.321 rows=312 loops=1)

  • Output: raw_statements_1.source_item_id, raw_statements_1.target_datavalue
  • Hash Cond: (raw_statements_1.source_item_id = people_6.id)
  • Buffers: shared hit=1 read=1185411
42. 606,993.521 607,468.487 ↓ 183.9 1,638,359 1

Bitmap Heap Scan on wikidata_20180827.item_statements raw_statements_1 (cost=32,917.13..5,034,800.04 rows=8,911 width=102) (actual time=863.104..607,468.487 rows=1,638,359 loops=1)

  • Output: raw_statements_1.id, raw_statements_1.mainsnak_datatype, raw_statements_1.datavalue_datatype, raw_statements_1.source_item_id, raw_statements_1.edge_property_id, raw_statements_1.target_datavalue, raw_statements_1.el_rank
  • Recheck Cond: (raw_statements_1.edge_property_id = 570)
  • Filter: ("substring"(((raw_statements_1.target_datavalue -> 'value'::text) ->> 'time'::text), 1, 1) = '+'::text)
  • Rows Removed by Filter: 5082
  • Heap Blocks: exact=1180918
  • Buffers: shared hit=1 read=1185411
43. 474.966 474.966 ↑ 1.1 1,643,441 1

Bitmap Index Scan on item_statements_edge_property_id_idx (cost=0.00..32,914.90 rows=1,782,177 width=0) (actual time=474.966..474.966 rows=1,643,441 loops=1)

  • Index Cond: (raw_statements_1.edge_property_id = 570)
  • Buffers: shared read=4494
44. 0.044 0.102 ↑ 1.0 400 1

Hash (cost=8.00..8.00 rows=400 width=4) (actual time=0.102..0.102 rows=400 loops=1)

  • Output: people_6.id
  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
45. 0.058 0.058 ↑ 1.0 400 1

CTE Scan on people people_6 (cost=0.00..8.00 rows=400 width=4) (actual time=0.000..0.058 rows=400 loops=1)

  • Output: people_6.id
46.          

CTE country_of_citizenship

47. 0.162 44.272 ↓ 2.0 396 1

GroupAggregate (cost=2,082,805.75..2,082,864.04 rows=200 width=36) (actual time=44.095..44.272 rows=396 loops=1)

  • Output: people_7.id, string_agg(countries_labeled.en_label, '|'::text)
  • Group Key: people_7.id
  • Buffers: shared hit=4257 read=281
48. 0.132 44.110 ↑ 15.3 486 1

Sort (cost=2,082,805.75..2,082,824.35 rows=7,438 width=60) (actual time=44.077..44.110 rows=486 loops=1)

  • Output: people_7.id, countries_labeled.en_label
  • Sort Key: people_7.id
  • Sort Method: quicksort Memory: 51kB
  • Buffers: shared hit=4257 read=281
49. 0.000 43.978 ↑ 15.3 486 1

Nested Loop (cost=1.14..2,082,327.46 rows=7,438 width=60) (actual time=2.057..43.978 rows=486 loops=1)

  • Output: people_7.id, countries_labeled.en_label
  • Buffers: shared hit=4257 read=281
50. 0.338 12.406 ↑ 15.3 486 1

Nested Loop (cost=0.57..2,033,019.72 rows=7,438 width=8) (actual time=1.147..12.406 rows=486 loops=1)

  • Output: people_7.id, countries_enc.target_item_id
  • Buffers: shared hit=1900 read=207
51. 0.068 0.068 ↑ 1.0 400 1

CTE Scan on people people_7 (cost=0.00..8.00 rows=400 width=4) (actual time=0.001..0.068 rows=400 loops=1)

  • Output: people_7.id, people_7.name
52. 12.000 12.000 ↑ 19.0 1 400

Index Scan using qpq_item_statements_source_item_id_idx on wikidata_20180827.qpq_item_statements countries_enc (cost=0.57..5,082.34 rows=19 width=8) (actual time=0.027..0.030 rows=1 loops=400)

  • Output: countries_enc.id, countries_enc.source_item_id, countries_enc.edge_property_id, countries_enc.target_item_id, countries_enc.el_rank
  • Index Cond: (countries_enc.source_item_id = people_7.id)
  • Filter: (countries_enc.edge_property_id = 27)
  • Rows Removed by Filter: 16
  • Buffers: shared hit=1900 read=207
53. 31.590 31.590 ↑ 1.0 1 486

Index Scan using item_pkey on wikidata_20180827.item countries_labeled (cost=0.56..6.62 rows=1 width=60) (actual time=0.064..0.065 rows=1 loops=486)

  • Output: countries_labeled.id, countries_labeled.en_label, countries_labeled.en_label_norm, countries_labeled.en_description, countries_labeled.enwiki_title
  • Index Cond: (countries_labeled.id = countries_enc.target_item_id)
  • Buffers: shared hit=2357 read=74
54. 0.113 1,712,528.690 ↑ 1.0 400 1

Hash Left Join (cost=23.66..82.22 rows=400 width=140) (actual time=1,712,528.198..1,712,528.690 rows=400 loops=1)

  • Output: people.id, people.name, date_of_birth.year_born, aliases.aliases, education.educated_at, occupation.occupation, date_of_death.year_deceased
  • Hash Cond: (people.id = date_of_death.id)
  • Buffers: shared hit=9834 read=3548541
55. 0.119 1,104,651.781 ↑ 1.0 400 1

Hash Left Join (cost=22.26..78.46 rows=400 width=136) (actual time=1,104,651.371..1,104,651.781 rows=400 loops=1)

  • Output: people.id, people.name, date_of_birth.year_born, aliases.aliases, education.educated_at, occupation.occupation
  • Hash Cond: (people.id = occupation.id)
  • Buffers: shared hit=9833 read=2363130
56. 0.117 1,104,407.028 ↑ 1.0 400 1

Hash Left Join (cost=15.76..56.96 rows=400 width=104) (actual time=1,104,406.715..1,104,407.028 rows=400 loops=1)

  • Output: people.id, people.name, date_of_birth.year_born, aliases.aliases, education.educated_at
  • Hash Cond: (people.id = education.id)
  • Buffers: shared hit=4492 read=2362439
57. 0.089 1,025,290.831 ↑ 1.0 400 1

Hash Left Join (cost=9.26..35.46 rows=400 width=72) (actual time=1,025,290.609..1,025,290.831 rows=400 loops=1)

  • Output: people.id, people.name, date_of_birth.year_born, aliases.aliases
  • Hash Cond: (people.id = aliases.id)
  • Buffers: shared hit=3729 read=1973859
58. 0.123 1,025,286.583 ↑ 1.0 400 1

Hash Left Join (cost=2.76..13.96 rows=400 width=40) (actual time=1,025,286.433..1,025,286.583 rows=400 loops=1)

  • Output: people.id, people.name, date_of_birth.year_born
  • Hash Cond: (people.id = date_of_birth.id)
  • Buffers: shared hit=2428 read=1973842
59. 0.070 0.070 ↑ 1.0 400 1

CTE Scan on people (cost=0.00..8.00 rows=400 width=36) (actual time=0.020..0.070 rows=400 loops=1)

  • Output: people.id, people.name
  • Buffers: shared hit=6
60. 0.062 1,025,286.390 ↓ 4.7 397 1

Hash (cost=1.70..1.70 rows=85 width=8) (actual time=1,025,286.390..1,025,286.390 rows=397 loops=1)

  • Output: date_of_birth.year_born, date_of_birth.id
  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
  • Buffers: shared hit=2422 read=1973842
61. 1,025,286.328 1,025,286.328 ↓ 4.7 397 1

CTE Scan on date_of_birth (cost=0.00..1.70 rows=85 width=8) (actual time=1,025,285.953..1,025,286.328 rows=397 loops=1)

  • Output: date_of_birth.year_born, date_of_birth.id
  • Buffers: shared hit=2422 read=1973842
62. 0.024 4.159 ↑ 1.7 116 1

Hash (cost=4.00..4.00 rows=200 width=36) (actual time=4.159..4.159 rows=116 loops=1)

  • Output: aliases.aliases, aliases.id
  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=1301 read=17
63. 4.135 4.135 ↑ 1.7 116 1

CTE Scan on aliases (cost=0.00..4.00 rows=200 width=36) (actual time=4.073..4.135 rows=116 loops=1)

  • Output: aliases.aliases, aliases.id
  • Buffers: shared hit=1301 read=17
64. 0.045 79,116.080 ↑ 1.4 140 1

Hash (cost=4.00..4.00 rows=200 width=36) (actual time=79,116.080..79,116.080 rows=140 loops=1)

  • Output: education.educated_at, education.id
  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
  • Buffers: shared hit=763 read=388580
65. 79,116.035 79,116.035 ↑ 1.4 140 1

CTE Scan on education (cost=0.00..4.00 rows=200 width=36) (actual time=79,115.922..79,116.035 rows=140 loops=1)

  • Output: education.educated_at, education.id
  • Buffers: shared hit=763 read=388580
66. 0.075 244.634 ↓ 1.8 356 1

Hash (cost=4.00..4.00 rows=200 width=36) (actual time=244.634..244.634 rows=356 loops=1)

  • Output: occupation.occupation, occupation.id
  • Buckets: 1024 Batches: 1 Memory Usage: 31kB
  • Buffers: shared hit=5341 read=691
67. 244.559 244.559 ↓ 1.8 356 1

CTE Scan on occupation (cost=0.00..4.00 rows=200 width=36) (actual time=244.185..244.559 rows=356 loops=1)

  • Output: occupation.occupation, occupation.id
  • Buffers: shared hit=5341 read=691
68. 0.049 607,876.796 ↓ 6.7 288 1

Hash (cost=0.86..0.86 rows=43 width=8) (actual time=607,876.796..607,876.796 rows=288 loops=1)

  • Output: date_of_death.year_deceased, date_of_death.id
  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
  • Buffers: shared hit=1 read=1185411
69. 607,876.747 607,876.747 ↓ 6.7 288 1

CTE Scan on date_of_death (cost=0.00..0.86 rows=43 width=8) (actual time=607,876.466..607,876.747 rows=288 loops=1)

  • Output: date_of_death.year_deceased, date_of_death.id
  • Buffers: shared hit=1 read=1185411
70. 0.089 44.487 ↓ 2.0 396 1

Hash (cost=4.00..4.00 rows=200 width=36) (actual time=44.487..44.487 rows=396 loops=1)

  • Output: country_of_citizenship.countries, country_of_citizenship.id
  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
  • Buffers: shared hit=4257 read=281
71. 44.398 44.398 ↓ 2.0 396 1

CTE Scan on country_of_citizenship (cost=0.00..4.00 rows=200 width=36) (actual time=44.097..44.398 rows=396 loops=1)

  • Output: country_of_citizenship.countries, country_of_citizenship.id
  • Buffers: shared hit=4257 read=281
Planning time : 1.345 ms
Execution time : 1,712,573.702 ms