explain.depesz.com

A tool for finding a real cause for slow queries.

Result: boH

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=3783967.12..3783967.13 rows=1 width=29) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

Append (cost=0.00..3429170.13 rows=35479698 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..70972.62 rows=869041 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..77216.65 rows=945510 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..81080.15 rows=992810 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..79528.16 rows=973811 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..84587.46 rows=1035764 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..78802.95 rows=964930 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..86180.99 rows=1055266 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..83622.10 rows=1023940 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..85867.42 rows=1051428 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..96022.76 rows=1175784 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..95509.49 rows=1169499 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..94661.73 rows=1159115 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..91395.89 rows=1119126 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..91606.73 rows=1121715 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..92526.54 rows=1132969 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..95306.23 rows=1167015 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..95845.21 rows=1173614 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..106824.78 rows=1308052 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..110226.54 rows=1349703 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..117173.67 rows=1434778 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..110513.33 rows=1353222 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..106860.21 rows=1308481 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..108037.49 rows=1322899 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..105885.32 rows=1296555 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..188812.29 rows=1272886 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..196516.35 rows=1324823 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..201432.58 rows=1357972 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..203096.79 rows=1369186 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..204241.58 rows=1376905 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..188813.47 rows=1272898 width=29) (actual time=.. rows= loops=)

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