explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t4P6 : I/O Massive kick

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 4,953.926 ↓ 12.0 12 1

Sort (cost=23,868.61..23,868.62 rows=1 width=1,801) (actual time=4,953.924..4,953.926 rows=12 loops=1)

  • Sort Key: measurement_id
  • Sort Method: quicksort Memory: 49kB
  • Buffers: shared hit=3978 read=17460
2. 4,948.007 4,953.892 ↓ 12.0 12 1

Bitmap Heap Scan on tv_smartdevicemeasurement_modbus (cost=560.49..23,868.60 rows=1 width=1,801) (actual time=4,639.286..4,953.892 rows=12 loops=1)

  • Recheck Cond: (smart_device_id = 6)
  • Filter: ((insert_time > '2019-02-07 12:15:00+01'::timestamp with time zone) AND (insert_time < '2019-02-07 12:31:00+01'::timestamp with time zone))
  • Rows Removed by Filter: 30251
  • Heap Blocks: exact=21350
  • Buffers: shared hit=3978 read=17460
3. 5.849 5.849 ↓ 1.0 30,263 1

Bitmap Index Scan on tv_smartdevicemeasurement_modbus_smart_device_id_62c12ed0 (cost=0.00..560.49 rows=29,876 width=0) (actual time=5.849..5.849 rows=30,263 loops=1)

  • Index Cond: (smart_device_id = 6)
  • Buffers: shared read=88
4.          

SubPlan (forBitmap Heap Scan)

5. 0.024 0.024 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=12)

6. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

7. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

8. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

9. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

10. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

11. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

12. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

13. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

14. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

15. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

16. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

17. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

18. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

19. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

20. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

21. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

22. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

23. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

24. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

25. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

26. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

27. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

28. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

29. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

30. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

31. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

32. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

33. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

34. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

35. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

36. 0.012 0.012 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.001 rows=1 loops=12)

37. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

38. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

39. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

40. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

41. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

42. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)

43. 0.000 0.000 ↑ 1.0 1 12

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=12)