explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mrsu : 1

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 36,435.189 ↑ 1.0 1 1

Aggregate (cost=15,747,446.75..15,747,446.76 rows=1 width=0) (actual time=36,435.189..36,435.189 rows=1 loops=1)

2. 3.473 36,435.179 ↓ 0.0 0 1

Append (cost=0.00..15,746,475.08 rows=194,334 width=0) (actual time=36,435.179..36,435.179 rows=0 loops=1)

  • -> Index Scan using log_rq2rs_20181201_registered_at_idx on log_rq2rs_20181201 (cost=0.43..6.43 rows=1 width=0) (actual time=0.020..0.020 rows=0 lo
  • -> Index Scan using log_rq2rs_20181202_registered_at_idx on log_rq2rs_20181202 (cost=0.43..8.45 rows=1 width=0) (actual time=0.019..0.019 rows=0 lo
  • -> Index Scan using log_rq2rs_20181203_registered_at_idx on log_rq2rs_20181203 (cost=0.43..6.71 rows=1 width=0) (actual time=0.009..0.009 rows=0 lo
  • -> Index Scan using log_rq2rs_20181204_registered_at_idx on log_rq2rs_20181204 (cost=0.43..4.63 rows=1 width=0) (actual time=0.011..0.011 rows=0 lo
  • -> Index Scan using log_rq2rs_20181205_registered_at_idx on log_rq2rs_20181205 (cost=0.43..4.57 rows=1 width=0) (actual time=0.013..0.013 rows=0 lo
  • -> Index Scan using log_rq2rs_20181206_registered_at_idx on log_rq2rs_20181206 (cost=0.43..4.49 rows=1 width=0) (actual time=0.040..0.040 rows=0 lo
  • -> Index Scan using log_rq2rs_20181207_registered_at_idx on log_rq2rs_20181207 (cost=0.43..4.60 rows=1 width=0) (actual time=0.043..0.043 rows=0 lo
  • -> Index Scan using log_rq2rs_20181208_registered_at_idx on log_rq2rs_20181208 (cost=0.43..4.56 rows=1 width=0) (actual time=0.061..0.061 rows=0 lo
  • -> Index Scan using log_rq2rs_20181209_registered_at_idx on log_rq2rs_20181209 (cost=0.43..4.84 rows=1 width=0) (actual time=0.024..0.024 rows=0 lo
  • -> Index Scan using log_rq2rs_20181210_registered_at_idx on log_rq2rs_20181210 (cost=0.43..4.61 rows=1 width=0) (actual time=0.013..0.013 rows=0 lo
  • -> Index Scan using log_rq2rs_20181211_registered_at_idx on log_rq2rs_20181211 (cost=0.43..4.68 rows=1 width=0) (actual time=0.035..0.035 rows=0 lo
  • -> Index Scan using log_rq2rs_20181212_registered_at_idx on log_rq2rs_20181212 (cost=0.43..4.66 rows=1 width=0) (actual time=0.035..0.035 rows=0 lo
  • -> Index Scan using log_rq2rs_20181213_registered_at_idx on log_rq2rs_20181213 (cost=0.43..4.71 rows=1 width=0) (actual time=0.016..0.016 rows=0 lo
  • -> Index Scan using log_rq2rs_20181214_registered_at_idx on log_rq2rs_20181214 (cost=0.44..4.78 rows=1 width=0) (actual time=0.013..0.013 rows=0 lo
  • -> Index Scan using log_rq2rs_20181215_registered_at_idx on log_rq2rs_20181215 (cost=0.43..4.61 rows=1 width=0) (actual time=0.026..0.026 rows=0 lo
  • -> Index Scan using log_rq2rs_20181216_registered_at_idx on log_rq2rs_20181216 (cost=0.43..5.87 rows=1 width=0) (actual time=0.012..0.012 rows=0 lo
  • -> Index Scan using log_rq2rs_20181217_registered_at_idx on log_rq2rs_20181217 (cost=0.43..4.67 rows=1 width=0) (actual time=0.013..0.013 rows=0 lo
  • -> Index Scan using log_rq2rs_20181218_registered_at_idx on log_rq2rs_20181218 (cost=0.43..4.64 rows=1 width=0) (actual time=0.080..0.080 rows=0 lo
  • -> Index Scan using log_rq2rs_20181219_registered_at_idx on log_rq2rs_20181219 (cost=0.43..4.68 rows=1 width=0) (actual time=0.028..0.028 rows=0 lo
  • -> Index Scan using log_rq2rs_20181220_registered_at_idx on log_rq2rs_20181220 (cost=0.43..4.68 rows=1 width=0) (actual time=0.029..0.029 rows=0 lo
  • -> Index Scan using log_rq2rs_20181221_registered_at_idx on log_rq2rs_20181221 (cost=0.43..4.66 rows=1 width=0) (actual time=0.017..0.017 rows=0 lo
  • -> Index Scan using log_rq2rs_20181222_registered_at_idx on log_rq2rs_20181222 (cost=0.43..4.65 rows=1 width=0) (actual time=0.011..0.011 rows=0 lo
  • -> Index Scan using log_rq2rs_20181223_registered_at_idx on log_rq2rs_20181223 (cost=0.43..4.66 rows=1 width=0) (actual time=1.057..1.057 rows=0 lo
  • -> Index Scan using log_rq2rs_20181224_registered_at_idx on log_rq2rs_20181224 (cost=0.43..4.63 rows=1 width=0) (actual time=0.013..0.013 rows=0 lo
  • -> Index Scan using log_rq2rs_20181225_registered_at_idx on log_rq2rs_20181225 (cost=0.44..4.65 rows=1 width=0) (actual time=0.009..0.009 rows=0 lo
  • -> Index Scan using log_rq2rs_20181226_registered_at_idx on log_rq2rs_20181226 (cost=0.44..4.64 rows=1 width=0) (actual time=0.016..0.016 rows=0 lo
  • -> Index Scan using log_rq2rs_20181227_registered_at_idx on log_rq2rs_20181227 (cost=0.44..4.71 rows=1 width=0) (actual time=0.077..0.077 rows=0 lo
  • -> Index Scan using log_rq2rs_20181228_registered_at_idx on log_rq2rs_20181228 (cost=0.43..4.46 rows=1 width=0) (actual time=0.016..0.016 rows=0 lo
  • -> Index Scan using log_rq2rs_20181229_registered_at_idx on log_rq2rs_20181229 (cost=0.43..4.46 rows=1 width=0) (actual time=0.033..0.033 rows=0 lo
  • -> Index Scan using log_rq2rs_20181230_registered_at_idx on log_rq2rs_20181230 (cost=0.43..4.46 rows=1 width=0) (actual time=0.017..0.017 rows=0 lo
  • -> Index Scan using log_rq2rs_20181231_registered_at_idx on log_rq2rs_20181231 (cost=0.43..4.45 rows=1 width=0) (actual time=0.041..0.041 rows=0 lo
  • -> Index Scan using log_rq2rs_20190101_registered_at_idx on log_rq2rs_20190101 (cost=0.43..4.45 rows=1 width=0) (actual time=0.033..0.033 rows=0 lo
  • -> Index Scan using log_rq2rs_20190102_registered_at_idx on log_rq2rs_20190102 (cost=0.43..4.46 rows=1 width=0) (actual time=0.141..0.141 rows=0 lo
  • -> Index Scan using log_rq2rs_20190103_registered_at_idx on log_rq2rs_20190103 (cost=0.43..4.46 rows=1 width=0) (actual time=0.026..0.026 rows=0 lo
  • -> Index Scan using log_rq2rs_20190104_registered_at_idx on log_rq2rs_20190104 (cost=0.43..4.45 rows=1 width=0) (actual time=0.017..0.017 rows=0 lo
  • -> Index Scan using log_rq2rs_20190105_registered_at_idx on log_rq2rs_20190105 (cost=0.43..4.45 rows=1 width=0) (actual time=0.015..0.015 rows=0 lo
  • -> Index Scan using log_rq2rs_20190106_registered_at_idx on log_rq2rs_20190106 (cost=0.43..4.57 rows=1 width=0) (actual time=0.013..0.013 rows=0 lo
  • -> Index Scan using log_rq2rs_20190107_registered_at_idx on log_rq2rs_20190107 (cost=0.43..4.67 rows=1 width=0) (actual time=0.107..0.107 rows=0 lo
  • -> Index Scan using log_rq2rs_20190108_registered_at_idx on log_rq2rs_20190108 (cost=0.43..4.64 rows=1 width=0) (actual time=0.014..0.014 rows=0 lo
  • -> Index Scan using log_rq2rs_20190109_registered_at_idx on log_rq2rs_20190109 (cost=0.43..4.68 rows=1 width=0) (actual time=0.014..0.014 rows=0 lo
  • -> Index Scan using log_rq2rs_20190110_registered_at_idx on log_rq2rs_20190110 (cost=0.44..4.67 rows=1 width=0) (actual time=0.014..0.014 rows=0 lo
  • -> Index Scan using log_rq2rs_20190111_registered_at_idx on log_rq2rs_20190111 (cost=0.43..4.46 rows=1 width=0) (actual time=0.014..0.014 rows=0 lo
  • -> Index Scan using log_rq2rs_20190112_registered_at_idx on log_rq2rs_20190112 (cost=0.43..4.46 rows=1 width=0) (actual time=0.013..0.013 rows=0 lo
  • -> Index Scan using log_rq2rs_20190113_registered_at_idx on log_rq2rs_20190113 (cost=0.43..4.46 rows=1 width=0) (actual time=0.040..0.040 rows=0 lo
  • -> Index Scan using log_rq2rs_20190114_registered_at_idx on log_rq2rs_20190114 (cost=0.43..4.46 rows=1 width=0) (actual time=0.015..0.015 rows=0 lo
  • -> Index Scan using log_rq2rs_20190115_registered_at_idx on log_rq2rs_20190115 (cost=0.44..4.46 rows=1 width=0) (actual time=0.015..0.015 rows=0 lo
  • -> Index Scan using log_rq2rs_20190116_registered_at_idx on log_rq2rs_20190116 (cost=0.43..4.46 rows=1 width=0) (actual time=0.092..0.092 rows=0 lo
  • -> Index Scan using log_rq2rs_20190117_registered_at_idx on log_rq2rs_20190117 (cost=0.43..4.46 rows=1 width=0) (actual time=0.022..0.022 rows=0 lo
  • -> Index Scan using log_rq2rs_20190118_registered_at_idx on log_rq2rs_20190118 (cost=0.43..4.46 rows=1 width=0) (actual time=0.015..0.015 rows=0 lo
  • -> Index Scan using log_rq2rs_20190119_registered_at_idx on log_rq2rs_20190119 (cost=0.43..7.34 rows=1 width=0) (actual time=0.021..0.021 rows=0 lo
  • -> Index Scan using log_rq2rs_20190120_registered_at_idx on log_rq2rs_20190120 (cost=0.43..4.46 rows=1 width=0) (actual time=0.027..0.027 rows=0 lo
  • -> Index Scan using log_rq2rs_20190121_registered_at_idx on log_rq2rs_20190121 (cost=0.43..4.46 rows=1 width=0) (actual time=0.018..0.018 rows=0 lo
  • -> Index Scan using log_rq2rs_20190122_registered_at_idx on log_rq2rs_20190122 (cost=0.43..4.46 rows=1 width=0) (actual time=0.051..0.051 rows=0 lo
  • -> Index Scan using log_rq2rs_20190123_registered_at_idx on log_rq2rs_20190123 (cost=0.43..4.46 rows=1 width=0) (actual time=0.016..0.016 rows=0 lo
  • -> Index Scan using log_rq2rs_20190124_registered_at_idx on log_rq2rs_20190124 (cost=0.43..4.46 rows=1 width=0) (actual time=0.031..0.031 rows=0 lo
  • -> Index Scan using log_rq2rs_20190125_registered_at_idx on log_rq2rs_20190125 (cost=0.44..4.46 rows=1 width=0) (actual time=0.030..0.030 rows=0 lo
  • -> Index Scan using log_rq2rs_20190126_registered_at_idx on log_rq2rs_20190126 (cost=0.43..4.46 rows=1 width=0) (actual time=0.015..0.015 rows=0 lo
  • -> Index Scan using log_rq2rs_20190127_registered_at_idx on log_rq2rs_20190127 (cost=0.43..4.46 rows=1 width=0) (actual time=0.014..0.014 rows=0 lo
  • -> Index Scan using log_rq2rs_20190128_registered_at_idx on log_rq2rs_20190128 (cost=0.43..4.46 rows=1 width=0) (actual time=0.037..0.037 rows=0 lo
  • -> Index Scan using log_rq2rs_20190129_registered_at_idx on log_rq2rs_20190129 (cost=0.43..6.70 rows=1 width=0) (actual time=0.014..0.014 rows=0 lo
  • -> Index Scan using log_rq2rs_20190130_registered_at_idx on log_rq2rs_20190130 (cost=0.44..4.46 rows=1 width=0) (actual time=0.015..0.015 rows=0 lo
  • -> Index Scan using log_rq2rs_20190131_registered_at_idx on log_rq2rs_20190131 (cost=0.44..4.46 rows=1 width=0) (actual time=0.015..0.015 rows=0 lo
  • -> Index Scan using log_rq2rs_20190306_registered_at_idx on log_rq2rs_20190306 (cost=0.43..4.46 rows=1 width=0) (actual time=0.013..0.013 rows=0 lo
  • -> Index Scan using log_rq2rs_20190201_registered_at_idx on log_rq2rs_20190201 (cost=0.44..4.46 rows=1 width=0) (actual time=0.024..0.024 rows=0 lo
  • -> Index Scan using log_rq2rs_20190202_registered_at_idx on log_rq2rs_20190202 (cost=0.43..4.46 rows=1 width=0) (actual time=0.020..0.020 rows=0 lo
  • -> Index Scan using log_rq2rs_20190203_registered_at_idx on log_rq2rs_20190203 (cost=0.43..4.46 rows=1 width=0) (actual time=0.016..0.016 rows=0 lo
  • -> Index Scan using log_rq2rs_20190204_registered_at_idx on log_rq2rs_20190204 (cost=0.43..4.46 rows=1 width=0) (actual time=0.013..0.013 rows=0 lo
  • -> Index Scan using log_rq2rs_20190205_registered_at_idx on log_rq2rs_20190205 (cost=0.43..4.46 rows=1 width=0) (actual time=0.012..0.012 rows=0 lo
  • -> Index Scan using log_rq2rs_20190206_registered_at_idx on log_rq2rs_20190206 (cost=0.43..4.47 rows=1 width=0) (actual time=0.034..0.034 rows=0 lo
  • -> Index Scan using log_rq2rs_20190207_registered_at_idx on log_rq2rs_20190207 (cost=0.43..4.46 rows=1 width=0) (actual time=0.016..0.016 rows=0 lo
  • -> Index Scan using log_rq2rs_20190208_registered_at_idx on log_rq2rs_20190208 (cost=0.44..4.47 rows=1 width=0) (actual time=0.048..0.048 rows=0 lo
  • -> Index Scan using log_rq2rs_20190209_registered_at_idx on log_rq2rs_20190209 (cost=0.43..6.95 rows=1 width=0) (actual time=0.025..0.025 rows=0 lo
  • -> Index Scan using log_rq2rs_20190210_registered_at_idx on log_rq2rs_20190210 (cost=0.43..4.51 rows=1 width=0) (actual time=0.011..0.011 rows=0 lo
  • -> Index Scan using log_rq2rs_20190211_registered_at_idx on log_rq2rs_20190211 (cost=0.43..4.46 rows=1 width=0) (actual time=0.011..0.011 rows=0 lo
  • -> Index Scan using log_rq2rs_20190212_registered_at_idx on log_rq2rs_20190212 (cost=0.43..4.46 rows=1 width=0) (actual time=0.045..0.045 rows=0 lo
  • -> Index Scan using log_rq2rs_20190213_registered_at_idx on log_rq2rs_20190213 (cost=0.43..4.46 rows=1 width=0) (actual time=0.029..0.029 rows=0 lo
  • -> Index Scan using log_rq2rs_20190214_registered_at_idx on log_rq2rs_20190214 (cost=0.44..4.46 rows=1 width=0) (actual time=0.013..0.013 rows=0 lo
  • -> Index Scan using log_rq2rs_20190215_registered_at_idx on log_rq2rs_20190215 (cost=0.44..4.46 rows=1 width=0) (actual time=0.054..0.054 rows=0 lo
  • -> Index Scan using log_rq2rs_20190216_registered_at_idx on log_rq2rs_20190216 (cost=0.43..4.46 rows=1 width=0) (actual time=0.028..0.028 rows=0 lo
  • -> Index Scan using log_rq2rs_20190217_registered_at_idx on log_rq2rs_20190217 (cost=0.43..4.46 rows=1 width=0) (actual time=0.013..0.013 rows=0 lo
  • -> Index Scan using log_rq2rs_20190218_registered_at_idx on log_rq2rs_20190218 (cost=0.44..4.46 rows=1 width=0) (actual time=0.023..0.023 rows=0 lo
  • -> Index Scan using log_rq2rs_20190219_registered_at_idx on log_rq2rs_20190219 (cost=0.43..4.46 rows=1 width=0) (actual time=0.016..0.016 rows=0 lo
  • -> Index Scan using log_rq2rs_20190220_registered_at_idx on log_rq2rs_20190220 (cost=0.44..4.46 rows=1 width=0) (actual time=0.016..0.016 rows=0 lo
  • -> Index Scan using log_rq2rs_20190221_registered_at_idx on log_rq2rs_20190221 (cost=0.43..6.75 rows=1 width=0) (actual time=0.015..0.015 rows=0 lo
  • -> Index Scan using log_rq2rs_20190222_registered_at_idx on log_rq2rs_20190222 (cost=0.44..6.17 rows=1 width=0) (actual time=0.017..0.017 rows=0 lo
  • -> Index Scan using log_rq2rs_20190228_registered_at_idx on log_rq2rs_20190228 (cost=0.44..4.46 rows=1 width=0) (actual time=0.045..0.045 rows=0 lo
  • -> Index Scan using log_rq2rs_20190301_registered_at_idx on log_rq2rs_20190301 (cost=0.44..4.46 rows=1 width=0) (actual time=0.015..0.015 rows=0 lo
  • -> Index Scan using log_rq2rs_20190302_registered_at_idx on log_rq2rs_20190302 (cost=0.43..4.46 rows=1 width=0) (actual time=0.013..0.013 rows=0 lo
  • -> Index Scan using log_rq2rs_20190304_registered_at_idx on log_rq2rs_20190304 (cost=0.44..4.46 rows=1 width=0) (actual time=0.014..0.014 rows=0 lo
  • -> Index Scan using log_rq2rs_20190303_registered_at_idx on log_rq2rs_20190303 (cost=0.43..4.46 rows=1 width=0) (actual time=0.015..0.015 rows=0 lo
  • -> Index Scan using log_rq2rs_20190305_registered_at_idx on log_rq2rs_20190305 (cost=0.44..4.46 rows=1 width=0) (actual time=0.015..0.015 rows=0 lo
3. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on log_rq2rs (cost=0.00..0.00 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text) AND (registered_at > (now() - '0
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
4. 0.048 0.048 ↓ 0.0 0 1

Bitmap Heap Scan on log_rq2rs_20190307 (cost=186,809.16..2,419,874.94 rows=43,689 width=0) (actual time=0.048..0.048 rows=0 loops=1)

  • Recheck Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • -> Bitmap Index Scan on log_rq2rs_20190307_registered_at_idx (cost=0.00..186798.24 rows=17563439 width=0) (actual time=0.040..0.040 rows=0 lo
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
5. 0.088 0.088 ↓ 0.0 0 1

Bitmap Heap Scan on log_rq2rs_20190308 (cost=118,847.94..1,536,144.46 rows=27,729 width=0) (actual time=0.088..0.088 rows=0 loops=1)

  • Recheck Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • -> Bitmap Index Scan on log_rq2rs_20190308_registered_at_idx (cost=0.00..118841.01 rows=11147276 width=0) (actual time=0.087..0.087 rows=0 lo
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
6. 0.169 0.169 ↓ 0.0 0 1

Bitmap Heap Scan on log_rq2rs_20190309 (cost=156,928.23..2,046,958.33 rows=36,978 width=0) (actual time=0.169..0.169 rows=0 loops=1)

  • Recheck Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • -> Bitmap Index Scan on log_rq2rs_20190309_registered_at_idx (cost=0.00..156918.98 rows=14865405 width=0) (actual time=0.169..0.169 rows=0 lo
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
7. 0.068 0.068 ↓ 0.0 0 1

Bitmap Heap Scan on log_rq2rs_20190310 (cost=184,960.93..2,432,871.91 rows=43,979 width=0) (actual time=0.068..0.068 rows=0 loops=1)

  • Recheck Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • -> Bitmap Index Scan on log_rq2rs_20190310_registered_at_idx (cost=0.00..184949.94 rows=17680199 width=0) (actual time=0.067..0.067 rows=0 lo
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
8. 193.955 193.955 ↓ 0.0 0 1

Bitmap Heap Scan on log_rq2rs_20190311 (cost=104,944.33..1,398,776.49 rows=25,313 width=0) (actual time=193.955..193.955 rows=0 loops=1)

  • Recheck Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Rows Removed by Filter: 26828
  • Heap Blocks: exact=9792
  • -> Bitmap Index Scan on log_rq2rs_20190311_registered_at_idx (cost=0.00..104938.00 rows=10176208 width=0) (actual time=14.434..14.434 rows=64
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
9. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on log_rq2rs_20190312 (cost=0.00..15.60 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text) AND (registered_at > (now() - '0
10. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on log_rq2rs_20190313 (cost=0.00..15.60 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text) AND (registered_at > (now() - '0
11. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on log_rq2rs_20190314 (cost=0.00..15.60 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text) AND (registered_at > (now() - '0
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
12. 4,586.913 4,586.913 ↓ 0.0 0 1

Seq Scan on log_rq2rs_20190223 (cost=0.00..820,323.16 rows=2,313 width=0) (actual time=4,586.913..4,586.913 rows=0 loops=1)

  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text) AND (registered_at > (now() - '0
  • Rows Removed by Filter: 2790108
13. 2,735.732 2,735.732 ↓ 0.0 0 1

Seq Scan on log_rq2rs_20190224 (cost=0.00..788,333.58 rows=2,193 width=0) (actual time=2,735.732..2,735.732 rows=0 loops=1)

  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text) AND (registered_at > (now() - '0
  • Rows Removed by Filter: 2645029
14. 12,764.362 12,764.362 ↓ 0.0 0 1

Seq Scan on log_rq2rs_20190225 (cost=0.00..1,521,254.78 rows=4,212 width=0) (actual time=12,764.362..12,764.362 rows=0 loops=1)

  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text) AND (registered_at > (now() - '0
  • Rows Removed by Filter: 5079789
15. 8,983.369 8,983.369 ↓ 0.0 0 1

Seq Scan on log_rq2rs_20190226 (cost=0.00..1,334,317.14 rows=3,756 width=0) (actual time=8,983.369..8,983.369 rows=0 loops=1)

  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text) AND (registered_at > (now() - '0
  • Rows Removed by Filter: 4529357
16. 7,166.999 7,166.999 ↓ 0.0 0 1

Seq Scan on log_rq2rs_20190227 (cost=0.00..1,447,141.16 rows=4,077 width=0) (actual time=7,166.999..7,166.999 rows=0 loops=1)

  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text) AND (registered_at > (now() - '0
  • Rows Removed by Filter: 4917258
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))
  • Index Cond: (registered_at > (now() - '00:05:00'::interval))
  • Filter: (has_error AND (additional_info IS NOT NULL) AND (queue_name = 'Prod.wb.agreement/card.list.rq'::text))