explain.depesz.com

A tool for finding a real cause for slow queries.

Result: gra

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=3,783,967.12..3,783,967.13 rows=1 width=29) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

Append (cost=0.00..3,429,170.13 rows=35,479,698 width=29) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using stat_appnexus_jour_bulk_jour_idx on stat_appnexus_jour_bulk adx (cost=0.00..2.67 rows=1 width=47) (actual time=.. rows= loops=)

  • Index Cond: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
4. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120401 adx (cost=0.00..70,972.62 rows=869,041 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
5. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120402 adx (cost=0.00..77,216.65 rows=945,510 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
6. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120403 adx (cost=0.00..81,080.15 rows=992,810 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
7. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120404 adx (cost=0.00..79,528.16 rows=973,811 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
8. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120405 adx (cost=0.00..84,587.46 rows=1,035,764 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
9. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120406 adx (cost=0.00..78,802.95 rows=964,930 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
10. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120407 adx (cost=0.00..86,180.99 rows=1,055,266 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
11. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120408 adx (cost=0.00..83,622.10 rows=1,023,940 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
12. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120409 adx (cost=0.00..85,867.42 rows=1,051,428 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
13. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120410 adx (cost=0.00..96,022.76 rows=1,175,784 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
14. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120411 adx (cost=0.00..95,509.49 rows=1,169,499 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
15. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120412 adx (cost=0.00..94,661.73 rows=1,159,115 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
16. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120413 adx (cost=0.00..91,395.89 rows=1,119,126 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
17. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120414 adx (cost=0.00..91,606.73 rows=1,121,715 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
18. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120415 adx (cost=0.00..92,526.54 rows=1,132,969 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
19. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120416 adx (cost=0.00..95,306.23 rows=1,167,015 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
20. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120417 adx (cost=0.00..95,845.21 rows=1,173,614 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
21. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120418 adx (cost=0.00..106,824.78 rows=1,308,052 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
22. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120419 adx (cost=0.00..110,226.54 rows=1,349,703 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
23. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120420 adx (cost=0.00..117,173.67 rows=1,434,778 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
24. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120421 adx (cost=0.00..110,513.33 rows=1,353,222 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
25. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120422 adx (cost=0.00..106,860.21 rows=1,308,481 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
26. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120423 adx (cost=0.00..108,037.49 rows=1,322,899 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
27. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120424 adx (cost=0.00..105,885.32 rows=1,296,555 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
28. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120425 adx (cost=0.00..188,812.29 rows=1,272,886 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
29. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120426 adx (cost=0.00..196,516.35 rows=1,324,823 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
30. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120427 adx (cost=0.00..201,432.58 rows=1,357,972 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
31. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120428 adx (cost=0.00..203,096.79 rows=1,369,186 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
32. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120429 adx (cost=0.00..204,241.58 rows=1,376,905 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))
33. 0.000 0.000 ↓ 0.0

Seq Scan on stat_appnexus_jour_bulk_20120430 adx (cost=0.00..188,813.47 rows=1,272,898 width=29) (actual time=.. rows= loops=)

  • Filter: ((jour <= '2012-04-30'::date) AND (jour >= '2012-04-01'::date))