explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d3f : Query With I/O Massive kick

Settings
# exclusive inclusive rows x rows loops node
1. 4,793.969 4,843.700 ↓ 12.0 12 1

Bitmap Heap Scan on tv_smartdevicemeasurement_modbus (cost=560.55..23,874.05 rows=1 width=1,801) (actual time=4,580.095..4,843.700 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: 30258
  • Heap Blocks: exact=21356
  • Buffers: shared hit=2 read=21442
2. 49.683 49.683 ↓ 1.0 30,270 1

Bitmap Index Scan on tv_smartdevicemeasurement_modbus_smart_device_id_62c12ed0 (cost=0.00..560.54 rows=29,883 width=0) (actual time=49.683..49.683 rows=30,270 loops=1)

  • Index Cond: (smart_device_id = 6)
  • Buffers: shared hit=1 read=87
3.          

SubPlan (forBitmap Heap Scan)

4. 0.036 0.036 ↑ 1.0 1 12

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

5. 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)

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.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)

36. 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)

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)