explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ozpk

Settings
# exclusive inclusive rows x rows loops node
1. 1,896,237.298 1,896,237.298 ↑ 11.0 10,054,537 1

Seq Scan on message_report_buckets message_report_buckets (cost=0..51,544,687.96 rows=110,993,866 width=85) (actual time=5,987.039..1,896,237.298 rows=10,054,537 loops=1)

  • Filter: ((bucket_hour_count = 1) AND ((bucket_hour >= 440166) OR (bucket_hour < 438648)))
Planning time : 2.787 ms
Execution time : 1,896,661.565 ms