explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f6fL

Settings
# exclusive inclusive rows x rows loops node
1. 0.942 13.833 ↑ 1.0 1,000 1

Limit (cost=0.00..32.81 rows=1,000 width=90) (actual time=4.622..13.833 rows=1,000 loops=1)

2. 1.042 12.891 ↑ 1,153.4 1,000 1

Nested Loop (cost=0.00..37,846.00 rows=1,153,412 width=90) (actual time=4.620..12.891 rows=1,000 loops=1)

3. 0.018 0.018 ↑ 1.0 1 1

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

  • Filter: (id = 22)
  • Rows Removed by Filter: 17
4. 11.831 11.831 ↑ 1,153.4 1,000 1

Seq Scan on cq_operation_data_history o (cost=0.00..26,310.65 rows=1,153,412 width=90) (actual time=4.594..11.831 rows=1,000 loops=1)

  • Filter: (machine_id = 22)