explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qUBx

Settings
# exclusive inclusive rows x rows loops node
1. 14,494.287 206,395.549 ↓ 1.0 39,239,683 1

Gather (cost=1,000..48,787,309.41 rows=39,214,704 width=32) (actual time=1.234..206,395.549 rows=39,239,683 loops=1)

2. 140,911.563 191,901.262 ↑ 1.2 13,079,894 3

Result (cost=0..44,864,839.01 rows=16,339,462 width=32) (actual time=102.085..191,901.262 rows=13,079,894 loops=3)

3. 0.000 50,989.699 ↑ 1.2 13,079,894 3

Append (cost=0..3,607,697.46 rows=16,339,462 width=13) (actual time=102.005..50,989.699 rows=13,079,894 loops=3)

4. 6,069.934 6,069.934 ↓ 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=13) (actual time=0.019..6,069.934 rows=2,749,367 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
5. 9,603.526 9,603.526 ↓ 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=13) (actual time=305.908..9,603.526 rows=2,855,932 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
6. 25,235.013 25,235.013 ↓ 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=13) (actual time=3,354.778..25,235.013 rows=2,855,141 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
7. 15,734.315 15,734.315 ↓ 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=13) (actual time=7,048.4..15,734.315 rows=2,854,719 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
8. 16,943.277 16,943.277 ↓ 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=13) (actual time=5,806.316..16,943.277 rows=2,853,533 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
9. 20,097.218 20,097.218 ↓ 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=13) (actual time=6,693.903..20,097.218 rows=2,854,052 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
10. 18,605.637 18,605.637 ↓ 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=13) (actual time=4,327.694..18,605.637 rows=2,288,954 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
11. 11,643.366 11,643.366 ↓ 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=13) (actual time=483.611..11,643.366 rows=2,831,285 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
12. 694.424 694.424 ↑ 1.3 879,918 3

Seq Scan on _hyper_3_63_chunk _hyper_3_63_chunk (cost=0..201,525.93 rows=1,106,075 width=13) (actual time=184.5..694.424 rows=879,918 loops=3)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
13. 1,584.857 1,584.857 ↓ 2.4 1,759,307 1

Seq Scan on _hyper_3_17_chunk _hyper_3_17_chunk (cost=0..181,987.82 rows=730,066 width=13) (actual time=196.899..1,584.857 rows=1,759,307 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
14. 1,453.294 1,453.294 ↓ 2.4 1,615,200 1

Seq Scan on _hyper_3_58_chunk _hyper_3_58_chunk (cost=0..167,146.44 rows=675,475 width=13) (actual time=176.74..1,453.294 rows=1,615,200 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
15. 2,044.041 2,044.041 ↓ 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=13) (actual time=313.917..2,044.041 rows=2,853,446 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
16. 1,896.464 1,896.464 ↓ 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=13) (actual time=316.051..1,896.464 rows=2,851,309 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
17. 7,082.584 7,082.584 ↓ 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=13) (actual time=4,113.406..7,082.584 rows=2,531,404 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
18. 3,447.077 3,447.077 ↓ 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=13) (actual time=981.264..3,447.077 rows=594,876 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
19. 2,593.524 2,593.524 ↓ 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=13) (actual time=739.759..2,593.524 rows=450,198 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
20. 2,129.703 2,129.703 ↓ 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=13) (actual time=584.356..2,129.703 rows=372,766 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
21. 488.337 488.337 ↓ 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=13) (actual time=37.069..488.337 rows=337,379 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
22. 516.171 516.171 ↓ 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=13) (actual time=225.95..516.171 rows=566,182 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
23. 461.558 461.558 ↓ 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=13) (actual time=37.158..461.558 rows=356,588 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
24. 72.069 72.069 ↓ 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=13) (actual time=9.102..72.069 rows=83,333 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
25. 39.607 39.607 ↓ 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=13) (actual time=5.559..39.607 rows=46,300 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
26. 8.526 8.526 ↓ 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=13) (actual time=0.304..8.526 rows=18,572 loops=1)

  • Filter: (logtime > '2019-05-31 00:00:00-04'::timestamp with time zone)
27. 6.818 6.818 ↓ 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=13) (actual time=0.22..6.818 rows=15,367 loops=1)

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

Seq Scan on _hyper_3_54_chunk _hyper_3_54_chunk (cost=0..484.69 rows=2,775 width=13) (actual time=0.084..2.049 rows=4,718 loops=1)

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