explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3ENb

Settings
# exclusive inclusive rows x rows loops node
1. 243,889.572 243,889.572 ↑ 13.1 4,741 1

CTE Scan on synthesis (cost=3,840,718.73..3,843,671.51 rows=61,968 width=836) (actual time=243,884.831..243,889.572 rows=4,741 loops=1)

  • Filter: ((length(as_parameter) <> 13) OR ((length(as_parameter) = 13) AND (campaign_id IS NOT NULL)))
  • Rows Removed by Filter: 1,070
2.          

CTE all_data

3. 31.795 243,818.682 ↑ 7.6 8,200 1

GroupAggregate (cost=3,784,007.52..3,793,865.54 rows=62,591 width=451) (actual time=243,768.667..243,818.682 rows=8,200 loops=1)

  • Group Key: (to_char((snapchat_stats.date)::timestamp with time zone, 'YYYY-MM-DD'::text)), abc.as_parameter, as_parameters_1.campaign, snapchat_ads_1.creative_id, snapchat_ads_1.id, snapchat_ads_1.ad_squad_id, snapchat_adsquads_1.campaign_id, snapchat_adsquads_1.name
  • Filter: ((sum(snapchat_stats.spend) > '0'::double precision) OR (sum((COALESCE((sum(ga_gemini_tag.dfp_revenue)), '0'::double precision) + COALESCE((sum(avantis_subid_daily_report.revenue)), '0'::double precision))) > '0'::double precision))
  • Rows Removed by Filter: 33,669
4. 175.209 243,786.887 ↑ 2.6 44,039 1

Sort (cost=3,784,007.52..3,784,289.17 rows=112,663 width=427) (actual time=243,768.645..243,786.887 rows=44,039 loops=1)

  • Sort Key: (to_char((snapchat_stats.date)::timestamp with time zone, 'YYYY-MM-DD'::text)), abc.as_parameter, as_parameters_1.campaign, snapchat_ads_1.creative_id, snapchat_ads_1.id, snapchat_ads_1.ad_squad_id, snapchat_adsquads_1.campaign_id, snapchat_adsquads_1.name
  • Sort Method: external merge Disk: 14,344kB
5. 37.839 243,611.678 ↑ 2.6 44,039 1

Hash Left Join (cost=1,999,962.78..3,761,696.56 rows=112,663 width=427) (actual time=220,896.589..243,611.678 rows=44,039 loops=1)

  • Hash Cond: (snapchat_stats.date = dfp_all.date)
6. 8.016 113,662.017 ↑ 1.1 44,039 1

Merge Left Join (cost=1,771,264.61..3,532,300.76 rows=50,525 width=391) (actual time=90,984.729..113,662.017 rows=44,039 loops=1)

  • Merge Cond: (snapchat_stats.date = avantis_subid_daily_report_1.date)
7. 10.565 109,192.695 ↓ 1.1 44,039 1

Merge Left Join (cost=1,771,264.18..3,448,176.21 rows=39,180 width=383) (actual time=89,742.093..109,192.695 rows=44,039 loops=1)

  • Merge Cond: ((snapchat_stats.date = avantis_subid_daily_report.date) AND (abc.as_parameter = avantis_subid_daily_report.sub_id))
8. 7.924 108,282.892 ↓ 1.1 44,039 1

Merge Left Join (cost=1,721,834.16..3,397,589.12 rows=39,180 width=375) (actual time=88,843.846..108,282.892 rows=44,039 loops=1)

  • Merge Cond: (snapchat_stats.date = ga_gemini_tag_1.date)
9. 15.372 87,574.675 ↓ 1.1 44,039 1

Merge Left Join (cost=1,720,833.59..1,721,175.92 rows=39,180 width=367) (actual time=87,531.408..87,574.675 rows=44,039 loops=1)

  • Merge Cond: ((snapchat_stats.date = ga_gemini_tag.date) AND (abc.as_parameter = ga_gemini_tag.dimension21))
10. 173.192 1,357.437 ↓ 1.1 44,039 1

Sort (cost=44,932.66..45,030.61 rows=39,180 width=359) (actual time=1,334.602..1,357.437 rows=44,039 loops=1)

  • Sort Key: snapchat_stats.date, abc.as_parameter
  • Sort Method: external merge Disk: 12,696kB
11. 61.446 1,184.245 ↓ 1.1 44,039 1

Hash Left Join (cost=34,079.73..38,177.80 rows=39,180 width=359) (actual time=919.310..1,184.245 rows=44,039 loops=1)

  • Hash Cond: (snapchat_ads_1.ad_squad_id = snapchat_adsquads_1.id)
  • Join Filter: ((length(abc.as_parameter) <> 13) OR ((length(abc.as_parameter) = 13) AND (replace(snapchat_adsquads_1.name, ' '::text, ''::text) = replace((as_parameters_1.campaign)::text, ' '::text, ''::text))))
  • Rows Removed by Join Filter: 13,608
12. 14.914 1,120.238 ↓ 1.1 44,039 1

Hash Left Join (cost=34,030.80..36,904.51 rows=39,180 width=267) (actual time=916.732..1,120.238 rows=44,039 loops=1)

  • Hash Cond: (snapchat_stats.id = snapchat_ads_1.id)
13. 190.188 190.188 ↓ 1.0 39,707 1

Index Scan Backward using idx_snapchat_stats_date on snapchat_stats (cost=0.42..2,335.40 rows=39,180 width=57) (actual time=1.586..190.188 rows=39,707 loops=1)

  • Index Cond: (date >= '2020-08-18'::date)
14. 0.301 915.136 ↓ 1.2 975 1

Hash (cost=34,020.23..34,020.23 rows=812 width=247) (actual time=915.135..915.136 rows=975 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 231kB
15. 0.549 914.835 ↓ 1.2 975 1

Hash Right Join (cost=439.30..34,020.23 rows=812 width=247) (actual time=781.791..914.835 rows=975 loops=1)

  • Hash Cond: (abc.creative_id = snapchat_ads_1.creative_id)
16. 112.212 912.769 ↓ 130.2 1,302 1

Nested Loop Left Join (cost=389.03..33,969.72 rows=10 width=168) (actual time=47.013..912.769 rows=1,302 loops=1)

  • Join Filter: (split_part((as_parameters_1.asparam)::text, '='::text, 2) = abc.as_parameter)
  • Rows Removed by Join Filter: 442,686
17. 0.981 28.471 ↓ 130.2 1,302 1

Group (cost=388.47..388.57 rows=10 width=96) (actual time=26.947..28.471 rows=1,302 loops=1)

  • Group Key: abc.creative_id, abc.as_parameter, abc.campaign_name
18.          

CTE asparam_assoc

19. 0.975 2.325 ↑ 1.3 482 1

HashAggregate (cost=212.55..232.14 rows=603 width=274) (actual time=1.648..2.325 rows=482 loops=1)

  • Group Key: snapchat_creatives_1.ad_account_id, snapchat_creatives_1.headline, snapchat_creatives_1.url, split_part(split_part(snapchat_creatives_1.url, 'as='::text, 2), '&'::text, 1), snapchat_creatives_1.type, snapchat_creatives_1.created_at
20. 0.819 1.350 ↑ 1.4 632 1

Hash Join (cost=99.05..199.30 rows=883 width=242) (actual time=0.344..1.350 rows=632 loops=1)

  • Hash Cond: (snapchat_creatives_1.headline = snapchat_creatives_2.headline)
21. 0.201 0.201 ↓ 1.1 1,018 1

Seq Scan on snapchat_creatives snapchat_creatives_1 (cost=0.00..93.24 rows=933 width=210) (actual time=0.004..0.201 rows=1,018 loops=1)

  • Filter: ((review_status = 'APPROVED'::text) OR (review_status = 'DISAPPROVED'::text))
  • Rows Removed by Filter: 198
22. 0.003 0.330 ↑ 7.8 9 1

Hash (cost=98.18..98.18 rows=70 width=18) (actual time=0.330..0.330 rows=9 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
23. 0.040 0.327 ↑ 7.8 9 1

HashAggregate (cost=96.78..97.48 rows=70 width=18) (actual time=0.325..0.327 rows=9 loops=1)

  • Group Key: snapchat_creatives_2.headline
24. 0.287 0.287 ↑ 1.0 197 1

Seq Scan on snapchat_creatives snapchat_creatives_2 (cost=0.00..96.28 rows=199 width=18) (actual time=0.026..0.287 rows=197 loops=1)

  • Filter: ((url = 'nan'::text) AND ((review_status = 'APPROVED'::text) OR (review_status = 'DISAPPROVED'::text)))
  • Rows Removed by Filter: 1,019
25.          

CTE full_creatives

26. 3.402 3.402 ↑ 1.0 1,216 1

Seq Scan on snapchat_creatives snapchat_creatives_1_1 (cost=0.00..108.44 rows=1,216 width=461) (actual time=0.487..3.402 rows=1,216 loops=1)

27.          

CTE abc

28. 12.341 20.098 ↓ 363.0 4,356 1

Hash Right Join (cost=30.58..47.43 rows=12 width=96) (actual time=6.829..20.098 rows=4,356 loops=1)

  • Hash Cond: ((asparam_assoc.ad_account_id = full_creatives.ad_account_id) AND (asparam_assoc.headline = full_creatives.headline))
  • Join Filter: ((full_creatives.type <> asparam_assoc.type) AND (full_creatives.created_at > (asparam_assoc.created_at - '00:05:00'::interval)) AND (full_creatives.created_at < (asparam_assoc.created_at + '00:05:00'::interval)))
  • Rows Removed by Join Filter: 55,429
29. 2.599 2.599 ↑ 1.3 482 1

CTE Scan on asparam_assoc (cost=0.00..12.06 rows=603 width=168) (actual time=1.650..2.599 rows=482 loops=1)

30. 0.385 5.158 ↓ 84.8 1,018 1

Hash (cost=30.40..30.40 rows=12 width=232) (actual time=5.158..5.158 rows=1,018 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 331kB
31. 4.773 4.773 ↓ 84.8 1,018 1

CTE Scan on full_creatives (cost=0.00..30.40 rows=12 width=232) (actual time=0.491..4.773 rows=1,018 loops=1)

  • Filter: ((review_status = 'APPROVED'::text) OR (review_status = 'DISAPPROVED'::text))
  • Rows Removed by Filter: 198
32. 5.952 27.490 ↓ 379.0 3,790 1

Sort (cost=0.47..0.49 rows=10 width=96) (actual time=26.944..27.490 rows=3,790 loops=1)

  • Sort Key: abc.creative_id, abc.as_parameter, abc.campaign_name
  • Sort Method: quicksort Memory: 677kB
33. 21.538 21.538 ↓ 379.0 3,790 1

CTE Scan on abc (cost=0.00..0.30 rows=10 width=96) (actual time=6.831..21.538 rows=3,790 loops=1)

  • Filter: ((as_parameter IS NOT NULL) AND (campaign_name IS NOT NULL) AND (as_parameter <> ''::text) AND (campaign_name <> '//'::text))
  • Rows Removed by Filter: 566
34. 20.069 772.086 ↓ 2.1 341 1,302

Materialize (cost=0.55..33,553.44 rows=160 width=120) (actual time=0.010..0.593 rows=341 loops=1,302)

35. 752.017 752.017 ↓ 2.1 341 1

Index Scan using idx_1495027_inx on as_parameters as_parameters_1 (cost=0.55..33,552.64 rows=160 width=120) (actual time=12.561..752.017 rows=341 loops=1)

  • Index Cond: ((channel)::text = 'Snapchat'::text)
36. 0.139 1.517 ↑ 1.0 812 1

Hash (cost=40.12..40.12 rows=812 width=111) (actual time=1.517..1.517 rows=812 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 122kB
37. 1.378 1.378 ↑ 1.0 812 1

Seq Scan on snapchat_ads snapchat_ads_1 (cost=0.00..40.12 rows=812 width=111) (actual time=0.357..1.378 rows=812 loops=1)

38. 0.072 2.561 ↑ 1.0 339 1

Hash (cost=44.69..44.69 rows=339 width=129) (actual time=2.561..2.561 rows=339 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 62kB
39. 0.095 2.489 ↑ 1.0 339 1

Hash Left Join (cost=12.64..44.69 rows=339 width=129) (actual time=1.294..2.489 rows=339 loops=1)

  • Hash Cond: (snapchat_adsquads_1.campaign_id = snapchat_campaigns_1.id)
40. 1.542 1.542 ↑ 1.0 339 1

Seq Scan on snapchat_adsquads snapchat_adsquads_1 (cost=0.00..27.39 rows=339 width=129) (actual time=0.437..1.542 rows=339 loops=1)

41. 0.032 0.852 ↑ 1.0 206 1

Hash (cost=10.06..10.06 rows=206 width=37) (actual time=0.852..0.852 rows=206 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
42. 0.820 0.820 ↑ 1.0 206 1

Seq Scan on snapchat_campaigns snapchat_campaigns_1 (cost=0.00..10.06 rows=206 width=37) (actual time=0.007..0.820 rows=206 loops=1)

43. 0.766 86,201.866 ↓ 2.9 1,247 1

Finalize GroupAggregate (cost=1,675,900.92..1,675,940.48 rows=428 width=31) (actual time=86,196.797..86,201.866 rows=1,247 loops=1)

  • Group Key: ga_gemini_tag.date, ga_gemini_tag.dimension21
44. 5.986 86,201.100 ↓ 7.3 1,846 1

Gather Merge (cost=1,675,900.92..1,675,934.31 rows=252 width=31) (actual time=86,196.776..86,201.100 rows=1,846 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
45. 2.184 86,195.114 ↓ 3.7 923 2 / 2

Partial GroupAggregate (cost=1,674,900.91..1,674,905.95 rows=252 width=31) (actual time=86,191.966..86,195.114 rows=923 loops=2)

  • Group Key: ga_gemini_tag.date, ga_gemini_tag.dimension21
46. 19.606 86,192.930 ↓ 53.5 13,480 2 / 2

Sort (cost=1,674,900.91..1,674,901.54 rows=252 width=31) (actual time=86,191.949..86,192.930 rows=13,480 loops=2)

  • Sort Key: ga_gemini_tag.date, ga_gemini_tag.dimension21
  • Sort Method: quicksort Memory: 1,425kB
  • Worker 0: Sort Method: quicksort Memory: 1,449kB
47. 86,173.324 86,173.324 ↓ 53.5 13,480 2 / 2

Parallel Index Scan using idx_17910449_date on ga_gemini_tag (cost=0.57..1,674,890.86 rows=252 width=31) (actual time=37.910..86,173.324 rows=13,480 loops=2)

  • Index Cond: (date >= '2020-08-18'::date)
  • Filter: (dimension21 ~~ '211%%'::text)
  • Rows Removed by Filter: 2,270,662
48. 0.112 20,700.293 ↑ 5.5 60 1

Finalize GroupAggregate (cost=1,000.58..1,675,927.54 rows=328 width=12) (actual time=1,312.433..20,700.293 rows=60 loops=1)

  • Group Key: ga_gemini_tag_1.date
49. 0.000 20,700.181 ↑ 3.7 69 1

Gather Merge (cost=1,000.58..1,675,923.00 rows=252 width=12) (actual time=1,263.227..20,700.181 rows=69 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
50. 2.445 83,561.303 ↑ 7.4 34 2 / 2

Partial GroupAggregate (cost=0.57..1,674,894.64 rows=252 width=12) (actual time=794.325..83,561.303 rows=34 loops=2)

  • Group Key: ga_gemini_tag_1.date
51. 83,558.858 83,558.858 ↓ 53.5 13,480 2 / 2

Parallel Index Scan using idx_17910449_date on ga_gemini_tag ga_gemini_tag_1 (cost=0.57..1,674,890.86 rows=252 width=12) (actual time=173.157..83,558.858 rows=13,480 loops=2)

  • Index Cond: (date >= '2020-08-18'::date)
  • Filter: (dimension21 ~~ '211%%'::text)
  • Rows Removed by Filter: 2,270,662
52. 1.351 899.238 ↑ 2.6 3,172 1

Finalize GroupAggregate (cost=49,430.02..50,217.05 rows=8,353 width=33) (actual time=896.131..899.238 rows=3,172 loops=1)

  • Group Key: avantis_subid_daily_report.date, avantis_subid_daily_report.sub_id
53. 4.284 897.887 ↑ 1.6 3,172 1

Gather Merge (cost=49,430.02..50,095.83 rows=5,025 width=33) (actual time=896.121..897.887 rows=3,172 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
54. 0.799 893.603 ↑ 3.2 1,586 2 / 2

Partial GroupAggregate (cost=48,430.01..48,530.51 rows=5,025 width=33) (actual time=892.649..893.603 rows=1,586 loops=2)

  • Group Key: avantis_subid_daily_report.date, avantis_subid_daily_report.sub_id
55. 4.521 892.804 ↑ 3.1 1,619 2 / 2

Sort (cost=48,430.01..48,442.57 rows=5,025 width=33) (actual time=892.640..892.804 rows=1,619 loops=2)

  • Sort Key: avantis_subid_daily_report.date, avantis_subid_daily_report.sub_id
  • Sort Method: quicksort Memory: 174kB
  • Worker 0: Sort Method: quicksort Memory: 174kB
56. 888.283 888.283 ↑ 3.1 1,619 2 / 2

Parallel Seq Scan on avantis_subid_daily_report (cost=0.00..48,121.10 rows=5,025 width=33) (actual time=0.247..888.283 rows=1,619 loops=2)

  • Filter: (""left""(sub_id, 3) = '211'::text)
  • Rows Removed by Filter: 854,910
57. 1.021 4,461.306 ↑ 1.5 287 1

GroupAggregate (cost=0.43..83,515.95 rows=432 width=12) (actual time=27.637..4,461.306 rows=287 loops=1)

  • Group Key: avantis_subid_daily_report_1.date
58. 4,460.285 4,460.285 ↑ 2.6 3,238 1

Index Scan using idx_17243_date on avantis_subid_daily_report avantis_subid_daily_report_1 (cost=0.43..83,468.92 rows=8,543 width=12) (actual time=21.885..4,460.285 rows=3,238 loops=1)

  • Filter: (""left""(sub_id, 3) = '211'::text)
  • Rows Removed by Filter: 1,709,820
59. 0.019 129,911.822 ↑ 12.4 60 1

Hash (cost=228,688.84..228,688.84 rows=747 width=12) (actual time=129,911.822..129,911.822 rows=60 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
60. 0.010 129,911.803 ↑ 12.4 60 1

Subquery Scan on dfp_all (cost=228,584.26..228,688.84 rows=747 width=12) (actual time=129,911.741..129,911.803 rows=60 loops=1)

61. 0.000 129,911.793 ↑ 12.4 60 1

Finalize GroupAggregate (cost=228,584.26..228,681.37 rows=747 width=12) (actual time=129,911.739..129,911.793 rows=60 loops=1)

  • Group Key: dfp_ad_unit_device_flaf.date
62. 3.513 129,911.794 ↑ 6.5 115 1

Gather Merge (cost=228,584.26..228,670.16 rows=747 width=12) (actual time=129,911.732..129,911.794 rows=115 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
63. 0.031 129,908.281 ↑ 12.9 58 2 / 2

Sort (cost=227,584.25..227,586.11 rows=747 width=12) (actual time=129,908.277..129,908.281 rows=58 loops=2)

  • Sort Key: dfp_ad_unit_device_flaf.date
  • Sort Method: quicksort Memory: 27kB
  • Worker 0: Sort Method: quicksort Memory: 27kB
64. 4.605 129,908.250 ↑ 12.9 58 2 / 2

Partial HashAggregate (cost=227,541.13..227,548.60 rows=747 width=12) (actual time=129,908.234..129,908.250 rows=58 loops=2)

  • Group Key: dfp_ad_unit_device_flaf.date
65. 346.256 129,903.645 ↑ 4.9 25,585 2 / 2

Hash Join (cost=8.96..226,917.92 rows=124,642 width=12) (actual time=116.551..129,903.645 rows=25,585 loops=2)

  • Hash Cond: (dfp_ad_unit_device_flaf.flaf_id = flaf.pid)
66. 129,556.875 129,556.875 ↑ 1.2 1,760,990 2 / 2

Parallel Index Scan using idx_684476_date on dfp_ad_unit_device_flaf (cost=0.57..220,079.67 rows=2,073,600 width=20) (actual time=1.297..129,556.875 rows=1,760,990 loops=2)

  • Index Cond: (date >= '2020-08-18'::date)
67. 0.005 0.514 ↑ 1.0 11 2 / 2

Hash (cost=8.25..8.25 rows=11 width=8) (actual time=0.514..0.514 rows=11 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
68. 0.009 0.509 ↑ 1.0 11 2 / 2

HashAggregate (cost=8.14..8.25 rows=11 width=8) (actual time=0.507..0.509 rows=11 loops=2)

  • Group Key: flaf.pid
69. 0.500 0.500 ↑ 1.0 11 2 / 2

Seq Scan on flaf (cost=0.00..8.11 rows=11 width=8) (actual time=0.468..0.500 rows=11 loops=2)

  • Filter: (sub_channel = 'snapchat'::text)
  • Rows Removed by Filter: 318
70.          

CTE swipes_by_campaign_date

71. 3.370 4.380 ↑ 4.0 1,557 1

HashAggregate (cost=1,877.73..1,955.97 rows=6,259 width=128) (actual time=3.930..4.380 rows=1,557 loops=1)

  • Group Key: all_data.date, all_data.campaign_id, all_data.as_parameter
72. 1.010 1.010 ↑ 7.6 8,200 1

CTE Scan on all_data (cost=0.00..1,251.82 rows=62,591 width=104) (actual time=0.001..1.010 rows=8,200 loops=1)

73.          

CTE xyz

74. 7.780 243,858.662 ↑ 7.6 8,200 1

Merge Left Join (cost=20,042.20..21,357.10 rows=62,591 width=852) (actual time=243,849.728..243,858.662 rows=8,200 loops=1)

  • Merge Cond: ((all_data_1.date = swipes_by_campaign_date.date) AND (all_data_1.campaign_id = swipes_by_campaign_date.campaign_id) AND (all_data_1.as_parameter = swipes_by_campaign_date.as_parameter))
75. 17.725 243,841.682 ↑ 7.6 8,200 1

Sort (cost=19,522.34..19,678.82 rows=62,591 width=820) (actual time=243,840.946..243,841.682 rows=8,200 loops=1)

  • Sort Key: all_data_1.date, all_data_1.campaign_id, all_data_1.as_parameter
  • Sort Method: quicksort Memory: 4,745kB
76. 243,823.957 243,823.957 ↑ 7.6 8,200 1

CTE Scan on all_data all_data_1 (cost=0.00..1,251.82 rows=62,591 width=820) (actual time=243,768.671..243,823.957 rows=8,200 loops=1)

77. 4.325 9.200 ↓ 1.1 7,120 1

Sort (cost=519.86..535.51 rows=6,259 width=128) (actual time=8.767..9.200 rows=7,120 loops=1)

  • Sort Key: swipes_by_campaign_date.date, swipes_by_campaign_date.campaign_id, swipes_by_campaign_date.as_parameter
  • Sort Method: quicksort Memory: 246kB
78. 4.875 4.875 ↑ 4.0 1,557 1

CTE Scan on swipes_by_campaign_date (cost=0.00..125.18 rows=6,259 width=128) (actual time=3.932..4.875 rows=1,557 loops=1)

79.          

CTE synthesis

80. 11.196 243,885.189 ↑ 10.7 5,811 1

Sort (cost=23,384.42..23,540.12 rows=62,278 width=844) (actual time=243,884.813..243,885.189 rows=5,811 loops=1)

  • Sort Key: xyz.date DESC, xyz.as_parameter
  • Sort Method: quicksort Memory: 3,429kB
81. 243,873.993 243,873.993 ↑ 10.7 5,811 1

CTE Scan on xyz (cost=0.00..4,833.59 rows=62,278 width=844) (actual time=243,849.756..243,873.993 rows=5,811 loops=1)

  • Filter: (impressions <> 0)
  • Rows Removed by Filter: 2,389
Planning time : 38.131 ms