explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2V4A

Settings
# exclusive inclusive rows x rows loops node
1. 9.459 61.834 ↑ 1.0 1,000 1

Limit (cost=0.56..2,712.72 rows=1,000 width=82) (actual time=13.699..61.834 rows=1,000 loops=1)

2. 18.996 52.375 ↑ 123.5 1,000 1

Nested Loop (cost=0.56..334,957.88 rows=123,502 width=82) (actual time=13.689..52.375 rows=1,000 loops=1)

3. 5.379 5.379 ↑ 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=0.023..5.379 rows=1,000 loops=1)

  • Index Cond: (machine_id = 22)
4. 14.357 28.000 ↑ 1.0 1 1,000

Materialize (cost=0.00..1.23 rows=1 width=8) (actual time=0.023..0.028 rows=1 loops=1,000)

5. 13.643 13.643 ↑ 1.0 1 1

Seq Scan on cq_machines m (cost=0.00..1.23 rows=1 width=8) (actual time=13.638..13.643 rows=1 loops=1)

  • Filter: (id = 22)
  • Rows Removed by Filter: 17
Planning time : 52.216 ms
Execution time : 66.927 ms