explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xu3D

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 88,365.923 ↑ 2.5 80 1

Aggregate (cost=3,935,497.37..3,936,052.54 rows=200 width=72) (actual time=88,364.825..88,365.923 rows=80 loops=1)

2. 0.000 88,366.118 ↑ 2.1 195 1

Gather Merge (cost=3,935,497.37..3,935,544.04 rows=400 width=77) (actual time=88,364.748..88,366.118 rows=195 loops=1)

3. 0.615 264,859.083 ↑ 3.1 65 3

Sort (cost=3,934,497.35..3,934,497.85 rows=200 width=77) (actual time=88,286.356..88,286.361 rows=65 loops=3)

  • Sort Key: ("substring"((_hyper_3_14_chunk.geohash12)::text, 1, 8))
  • Sort Method: quicksort Memory: 35kB
4. 8,400.276 264,858.468 ↑ 3.1 65 3

Aggregate (cost=3,934,486.7..3,934,489.7 rows=200 width=77) (actual time=88,286.137..88,286.156 rows=65 loops=3)

5. 12,673.632 256,458.192 ↑ 1.2 13,079,894 3

Result (cost=0..3,852,789.39 rows=16,339,462 width=53) (actual time=262.866..85,486.064 rows=13,079,894 loops=3)

6. 2,662.989 243,784.560 ↑ 1.2 13,079,894 3

Append (cost=0..3,607,697.46 rows=16,339,462 width=21) (actual time=262.852..81,261.52 rows=13,079,894 loops=3)

7. 37,633.114 37,633.114 ↓ 2.4 2,749,367 1

Seq Scan on _hyper_3_14_chunk _hyper_3_14_chunk (cost=0..341,224.01 rows=1,135,521 width=21) (actual time=0.02..37,633.114 rows=2,749,367 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
8. 2,899.574 2,899.574 ↓ 2.4 2,855,932 1

Seq Scan on _hyper_3_19_chunk _hyper_3_19_chunk (cost=0..295,431.58 rows=1,185,566 width=21) (actual time=788.455..2,899.574 rows=2,855,932 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
9. 7,783.028 7,783.028 ↓ 2.4 2,855,141 1

Seq Scan on _hyper_3_16_chunk _hyper_3_16_chunk (cost=0..295,401.04 rows=1,189,363 width=21) (actual time=5,658.527..7,783.028 rows=2,855,141 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
10. 20,323.743 20,323.743 ↓ 2.4 2,854,719 1

Seq Scan on _hyper_3_15_chunk _hyper_3_15_chunk (cost=0..295,400.81 rows=1,192,625 width=21) (actual time=290.634..20,323.743 rows=2,854,719 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
11. 34,131.618 34,131.618 ↓ 2.4 2,853,533 1

Seq Scan on _hyper_3_20_chunk _hyper_3_20_chunk (cost=0..295,233.98 rows=1,188,638 width=21) (actual time=297.591..34,131.618 rows=2,853,533 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
12. 1,877.356 1,877.356 ↓ 2.4 2,854,052 1

Seq Scan on _hyper_3_21_chunk _hyper_3_21_chunk (cost=0..295,184.47 rows=1,180,598 width=21) (actual time=299.972..1,877.356 rows=2,854,052 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
13. 1,715.572 1,715.572 ↓ 2.4 2,288,954 1

Seq Scan on _hyper_3_18_chunk _hyper_3_18_chunk (cost=0..236,856.52 rows=956,281 width=21) (actual time=408.701..1,715.572 rows=2,288,954 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
14. 1,977.959 1,977.959 ↓ 2.4 2,831,285 1

Seq Scan on _hyper_3_62_chunk _hyper_3_62_chunk (cost=0..222,136.89 rows=1,178,311 width=21) (actual time=313.12..1,977.959 rows=2,831,285 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
15. 27,737.187 27,737.187 ↓ 2.4 2,639,755 1

Seq Scan on _hyper_3_63_chunk _hyper_3_63_chunk (cost=0..201,525.93 rows=1,106,075 width=21) (actual time=14,033.128..27,737.187 rows=2,639,755 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
16. 30,364.443 30,364.443 ↑ 1.2 586,436 3

Seq Scan on _hyper_3_17_chunk _hyper_3_17_chunk (cost=0..181,987.82 rows=730,066 width=21) (actual time=4,516.865..10,121.481 rows=586,436 loops=3)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
17. 30,802.896 30,802.896 ↓ 1.2 807,600 2

Seq Scan on _hyper_3_58_chunk _hyper_3_58_chunk (cost=0..167,146.44 rows=675,475 width=21) (actual time=2,224.626..15,401.448 rows=807,600 loops=2)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
18. 14,349.552 14,349.552 ↓ 2.4 2,853,446 1

Seq Scan on _hyper_3_66_chunk _hyper_3_66_chunk (cost=0..152,540.4 rows=1,187,552 width=21) (actual time=6,013.361..14,349.552 rows=2,853,446 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
19. 21,158.553 21,158.553 ↓ 2.4 2,851,309 1

Seq Scan on _hyper_3_67_chunk _hyper_3_67_chunk (cost=0..152,475.02 rows=1,190,562 width=21) (actual time=8,123.91..21,158.553 rows=2,851,309 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
20. 6,328.293 6,328.293 ↓ 2.4 2,531,404 1

Seq Scan on _hyper_3_64_chunk _hyper_3_64_chunk (cost=0..135,342.73 rows=1,055,019 width=21) (actual time=265.197..6,328.293 rows=2,531,404 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
21. 390.903 390.903 ↓ 2.4 594,876 1

Seq Scan on _hyper_3_22_chunk _hyper_3_22_chunk (cost=0..61,554.34 rows=248,348 width=21) (actual time=61.461..390.903 rows=594,876 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
22. 295.780 295.780 ↓ 2.4 450,198 1

Seq Scan on _hyper_3_23_chunk _hyper_3_23_chunk (cost=0..46,599.74 rows=189,179 width=21) (actual time=47.422..295.78 rows=450,198 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
23. 258.751 258.751 ↓ 2.4 372,766 1

Seq Scan on _hyper_3_28_chunk _hyper_3_28_chunk (cost=0..38,567.25 rows=155,220 width=21) (actual time=43.048..258.751 rows=372,766 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
24. 244.056 244.056 ↓ 2.4 337,379 1

Seq Scan on _hyper_3_57_chunk _hyper_3_57_chunk (cost=0..34,905.68 rows=140,454 width=21) (actual time=46.551..244.056 rows=337,379 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
25. 295.050 295.050 ↓ 2.4 566,182 1

Seq Scan on _hyper_3_65_chunk _hyper_3_65_chunk (cost=0..30,270.86 rows=235,909 width=21) (actual time=100.465..295.05 rows=566,182 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
26. 445.059 445.059 ↓ 2.4 356,588 1

Seq Scan on _hyper_3_61_chunk _hyper_3_61_chunk (cost=0..28,831.23 rows=148,578 width=21) (actual time=43.569..445.059 rows=356,588 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
27. 59.298 59.298 ↓ 2.4 83,333 1

Seq Scan on _hyper_3_59_chunk _hyper_3_59_chunk (cost=0..8,622.03 rows=34,722 width=21) (actual time=10.634..59.298 rows=83,333 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
28. 38.703 38.703 ↓ 2.4 46,300 1

Seq Scan on _hyper_3_60_chunk _hyper_3_60_chunk (cost=0..4,790.15 rows=19,292 width=21) (actual time=5.497..38.703 rows=46,300 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
29. 5.343 5.343 ↓ 1.7 18,572 1

Seq Scan on _hyper_3_55_chunk _hyper_3_55_chunk (cost=0..1,908.56 rows=10,925 width=21) (actual time=0.227..5.343 rows=18,572 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
30. 4.263 4.263 ↓ 1.7 15,367 1

Seq Scan on _hyper_3_56_chunk _hyper_3_56_chunk (cost=0..1,577.99 rows=9,039 width=21) (actual time=0.175..4.263 rows=15,367 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
31. 1.477 1.477 ↓ 1.7 4,718 1

Seq Scan on _hyper_3_54_chunk _hyper_3_54_chunk (cost=0..484.69 rows=2,775 width=21) (actual time=0.078..1.477 rows=4,718 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)