explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GzaI

Settings
# exclusive inclusive rows x rows loops node
1. 9.682 137.357 ↑ 1.0 1,000 1

Limit (cost=0.56..2,700.21 rows=1,000 width=82) (actual time=108.966..137.357 rows=1,000 loops=1)

2. 127.675 127.675 ↑ 123.5 1,000 1

Index Scan using cq_operation_data_history_index01 on cq_operation_data_history o (cost=0.56..333,412.88 rows=123,502 width=82) (actual time=108.942..127.675 rows=1,000 loops=1)

  • Index Cond: (machine_id = 22)