explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lUyn

Settings
# exclusive inclusive rows x rows loops node
1. 1.369 469.517 ↑ 3.2 39 1

Hash Join (cost=633.27..25,030.69 rows=124 width=121) (actual time=8.314..469.517 rows=39 loops=1)

  • Hash Cond: (files_delete_road_20190601.collection_id = rc.id)
2.          

CTE rc

3. 6.424 6.424 ↓ 2.4 1,096 1

Index Scan using collections_2_tsrange_idx on collections (cost=0.42..471.44 rows=458 width=53) (actual time=0.178..6.424 rows=1,096 loops=1)

  • Index Cond: (tsrange(data_start, data_end, '[]'::text) && '["2019-07-24 17:09:25","2019-07-24 17:09:45"]'::tsrange)
4.          

Initplan (forHash Join)

5. 0.096 0.187 ↑ 1.0 1 1

Aggregate (cost=10.30..10.31 rows=1 width=8) (actual time=0.187..0.187 rows=1 loops=1)

6. 0.091 0.091 ↓ 2.4 1,096 1

CTE Scan on rc rc_1 (cost=0.00..9.16 rows=458 width=8) (actual time=0.000..0.091 rows=1,096 loops=1)

7. 0.099 0.197 ↑ 1.0 1 1

Aggregate (cost=10.30..10.31 rows=1 width=8) (actual time=0.197..0.197 rows=1 loops=1)

8. 0.098 0.098 ↓ 2.4 1,096 1

CTE Scan on rc rc_2 (cost=0.00..9.16 rows=458 width=8) (actual time=0.001..0.098 rows=1,096 loops=1)

9. 0.721 460.449 ↓ 84.7 4,572 1

Nested Loop (cost=126.32..24,511.82 rows=54 width=161) (actual time=0.966..460.449 rows=4,572 loops=1)

10. 0.017 0.017 ↑ 1.0 1 1

Seq Scan on catalogs (cost=0.00..1.06 rows=1 width=34) (actual time=0.014..0.017 rows=1 loops=1)

  • Filter: (id = 1)
  • Rows Removed by Filter: 4
11. 18.081 459.711 ↓ 84.7 4,572 1

Hash Join (cost=126.32..24,510.21 rows=54 width=131) (actual time=0.948..459.711 rows=4,572 loops=1)

  • Hash Cond: (files_delete_road_20190601.partition_id = partitions.id)
12. 24.260 441.247 ↓ 31.4 212,207 1

Nested Loop (cost=0.84..24,366.98 rows=6,768 width=87) (actual time=0.510..441.247 rows=212,207 loops=1)

13. 0.055 0.055 ↑ 1.0 2 1

Index Scan using datasets_name_idx on datasets (cost=0.28..4.53 rows=2 width=76) (actual time=0.031..0.055 rows=2 loops=1)

  • Index Cond: (name = ANY ('{/delays,/metadata}'::text[]))
14. 17.238 416.932 ↓ 9.2 106,104 2

Append (cost=0.56..12,065.28 rows=11,594 width=19) (actual time=0.237..208.466 rows=106,104 loops=2)

15. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190601_dataset_id_collection_time_idx on files_delete_road_20190601 (cost=0.56..209.11 rows=202 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190602_dataset_id_collection_time_idx on files_delete_road_20190602 (cost=0.56..200.89 rows=194 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190603_dataset_id_collection_time_idx on files_delete_road_20190603 (cost=0.56..223.50 rows=216 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190604_dataset_id_collection_time_idx on files_delete_road_20190604 (cost=0.56..220.41 rows=213 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190605_dataset_id_collection_time_idx on files_delete_road_20190605 (cost=0.56..116.64 rows=112 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190606_dataset_id_collection_time_idx on files_delete_road_20190606 (cost=0.56..138.22 rows=133 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190607_dataset_id_collection_time_idx on files_delete_road_20190607 (cost=0.56..207.06 rows=200 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190608_dataset_id_collection_time_idx on files_delete_road_20190608 (cost=0.56..218.30 rows=211 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190609_dataset_id_collection_time_idx on files_delete_road_20190609 (cost=0.56..210.14 rows=203 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190610_dataset_id_collection_time_idx on files_delete_road_20190610 (cost=0.56..195.76 rows=189 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190611_dataset_id_collection_time_idx on files_delete_road_20190611 (cost=0.56..178.29 rows=172 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190612_dataset_id_collection_time_idx on files_delete_road_20190612 (cost=0.56..199.87 rows=193 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
27. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190613_dataset_id_collection_time_idx on files_delete_road_20190613 (cost=0.56..224.53 rows=217 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
28. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190614_dataset_id_collection_time_idx on files_delete_road_20190614 (cost=0.56..186.51 rows=180 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
29. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190615_dataset_id_collection_time_idx on files_delete_road_20190615 (cost=0.56..189.59 rows=183 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
30. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190616_dataset_id_collection_time_idx on files_delete_road_20190616 (cost=0.56..240.97 rows=233 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
31. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190617_dataset_id_collection_time_idx on files_delete_road_20190617 (cost=0.56..236.81 rows=229 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
32. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190618_dataset_id_collection_time_idx on files_delete_road_20190618 (cost=0.56..239.92 rows=232 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
33. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190619_dataset_id_collection_time_idx on files_delete_road_20190619 (cost=0.56..247.14 rows=239 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
34. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190620_dataset_id_collection_time_idx on files_delete_road_20190620 (cost=0.56..237.89 rows=230 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190621_dataset_id_collection_time_idx on files_delete_road_20190621 (cost=0.56..270.74 rows=261 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
36. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190622_dataset_id_collection_time_idx on files_delete_road_20190622 (cost=0.56..249.19 rows=241 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
37. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190623_dataset_id_collection_time_idx on files_delete_road_20190623 (cost=0.56..192.66 rows=186 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
38. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190624_dataset_id_collection_time_idx on files_delete_road_20190624 (cost=0.56..203.98 rows=197 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
39. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190625_dataset_id_collection_time_idx on files_delete_road_20190625 (cost=0.56..226.58 rows=219 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
40. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190626_dataset_id_collection_time_idx on files_delete_road_20190626 (cost=0.56..211.13 rows=204 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
41. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190627_dataset_id_collection_time_idx on files_delete_road_20190627 (cost=0.56..188.57 rows=182 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
42. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190628_dataset_id_collection_time_idx on files_delete_road_20190628 (cost=0.56..205.01 rows=198 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
43. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190629_dataset_id_collection_time_idx on files_delete_road_20190629 (cost=0.56..209.10 rows=202 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
44. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190630_dataset_id_collection_time_idx on files_delete_road_20190630 (cost=0.56..181.38 rows=175 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
45. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190701_dataset_id_collection_time_idx on files_delete_road_20190701 (cost=0.56..201.92 rows=195 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
46. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190702_dataset_id_collection_time_idx on files_delete_road_20190702 (cost=0.56..220.42 rows=213 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
47. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190703_dataset_id_collection_time_idx on files_delete_road_20190703 (cost=0.56..226.57 rows=219 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
48. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190704_dataset_id_collection_time_idx on files_delete_road_20190704 (cost=0.57..381.71 rows=369 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
49. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190705_dataset_id_collection_time_idx on files_delete_road_20190705 (cost=0.57..382.74 rows=370 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
50. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190706_dataset_id_collection_time_idx on files_delete_road_20190706 (cost=0.56..275.86 rows=266 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
51. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190707_dataset_id_collection_time_idx on files_delete_road_20190707 (cost=0.56..185.49 rows=179 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
52. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190708_dataset_id_collection_time_idx on files_delete_road_20190708 (cost=0.56..186.51 rows=180 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
53. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190709_dataset_id_collection_time_idx on files_delete_road_20190709 (cost=0.56..211.17 rows=204 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
54. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190710_dataset_id_collection_time_idx on files_delete_road_20190710 (cost=0.56..209.12 rows=202 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
55. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190711_dataset_id_collection_time_idx on files_delete_road_20190711 (cost=0.56..208.09 rows=201 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
56. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190712_dataset_id_collection_time_idx on files_delete_road_20190712 (cost=0.56..205.01 rows=198 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
57. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190713_dataset_id_collection_time_idx on files_delete_road_20190713 (cost=0.56..208.09 rows=201 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
58. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190714_dataset_id_collection_time_idx on files_delete_road_20190714 (cost=0.56..211.17 rows=204 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
59. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190715_dataset_id_collection_time_idx on files_delete_road_20190715 (cost=0.56..193.70 rows=187 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
60. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190716_dataset_id_collection_time_idx on files_delete_road_20190716 (cost=0.56..208.09 rows=201 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
61. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190717_dataset_id_collection_time_idx on files_delete_road_20190717 (cost=0.56..227.61 rows=220 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
62. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190718_dataset_id_collection_time_idx on files_delete_road_20190718 (cost=0.56..214.25 rows=207 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
63. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190719_dataset_id_collection_time_idx on files_delete_road_20190719 (cost=0.56..212.19 rows=205 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
64. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190720_dataset_id_collection_time_idx on files_delete_road_20190720 (cost=0.56..208.09 rows=201 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
65. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190721_dataset_id_collection_time_idx on files_delete_road_20190721 (cost=0.56..184.46 rows=178 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
66. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190722_dataset_id_collection_time_idx on files_delete_road_20190722 (cost=0.56..194.73 rows=188 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
67. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190723_dataset_id_collection_time_idx on files_delete_road_20190723 (cost=0.56..202.95 rows=196 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
68. 399.694 399.694 ↓ 500.5 106,104 2

Index Scan using files_delete_road_20190724_dataset_id_collection_time_idx on files_delete_road_20190724 (cost=0.56..219.39 rows=212 width=19) (actual time=0.032..199.847 rows=106,104 loops=2)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
69. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190725_dataset_id_collection_time_idx on files_delete_road_20190725 (cost=0.56..228.64 rows=221 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
70. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190726_dataset_id_collection_time_idx on files_delete_road_20190726 (cost=0.56..131.03 rows=126 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
71. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190727_dataset_id_collection_time_idx on files_delete_road_20190727 (cost=0.15..1.68 rows=1 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
72. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190728_dataset_id_collection_time_idx on files_delete_road_20190728 (cost=0.15..1.68 rows=1 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
73. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190729_dataset_id_collection_time_idx on files_delete_road_20190729 (cost=0.15..1.68 rows=1 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
74. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190730_dataset_id_collection_time_idx on files_delete_road_20190730 (cost=0.15..1.68 rows=1 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
75. 0.000 0.000 ↓ 0.0 0

Index Scan using files_delete_road_20190731_dataset_id_collection_time_idx on files_delete_road_20190731 (cost=0.15..1.68 rows=1 width=19) (never executed)

  • Index Cond: ((dataset_id = datasets.id) AND (collection_time >= $1) AND (collection_time <= $2) AND (collection_time > '2019-06-01 00:00:00'::timestamp without time zone))
  • Filter: (catalog_id = 1)
76. 0.035 0.383 ↑ 1.0 171 1

Hash (cost=123.33..123.33 rows=171 width=52) (actual time=0.382..0.383 rows=171 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
77. 0.348 0.348 ↑ 1.0 171 1

Index Scan using partitions_vin_id_idx on partitions (cost=0.29..123.33 rows=171 width=52) (actual time=0.026..0.348 rows=171 loops=1)

  • Index Cond: (vin = '5G21A6P01L4100015'::text)
78. 0.213 7.315 ↓ 2.4 1,096 1

Hash (cost=9.16..9.16 rows=458 width=56) (actual time=7.315..7.315 rows=1,096 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 102kB
79. 7.102 7.102 ↓ 2.4 1,096 1

CTE Scan on rc (cost=0.00..9.16 rows=458 width=56) (actual time=0.181..7.102 rows=1,096 loops=1)

Planning time : 64.892 ms
Execution time : 470.759 ms