explain.depesz.com

PostgreSQL's explain analyze made readable

Result: anQH

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Delete on miners_telemetry (cost=331,470.81..8,225,245,847.64 rows=652,609 width=6) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on miners_telemetry (cost=331,470.81..8,225,245,847.64 rows=652,609 width=6) (actual rows= loops=)

  • Filter: (NOT (SubPlan 1))
3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=331,470.81..343,745.12 rows=131,412 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=331,470.81..342,574.06 rows=131,412 width=8) (actual rows= loops=)

  • Group Key: miners_telemetry_1.miner_id
6. 0.000 0.000 ↓ 0.0

Sort (cost=331,470.81..334,733.85 rows=1,305,218 width=8) (actual rows= loops=)

  • Sort Key: miners_telemetry_1.miner_id
7. 0.000 0.000 ↓ 0.0

Seq Scan on miners_telemetry miners_telemetry_1 (cost=0.00..181,041.18 rows=1,305,218 width=8) (actual rows= loops=)