explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Ffi

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 261.521 ↓ 0.0 0 1

Delete on exploitation_engine_result (cost=32,735.76..33,260.14 rows=448,300 width=34) (actual time=261.521..261.521 rows=0 loops=1)

2. 0.000 261.519 ↓ 0.0 0 1

Nested Loop (cost=32,735.76..33,260.14 rows=448,300 width=34) (actual time=261.519..261.519 rows=0 loops=1)

3. 0.002 261.519 ↓ 0.0 0 1

HashAggregate (cost=32,735.34..32,737.34 rows=200 width=32) (actual time=261.519..261.519 rows=0 loops=1)

  • Group Key: "ANY_subquery".unnest
4. 0.001 261.517 ↓ 0.0 0 1

Subquery Scan on ANY_subquery (cost=32,692.73..32,729.34 rows=2,400 width=32) (actual time=261.517..261.517 rows=0 loops=1)

5. 0.001 261.516 ↓ 0.0 0 1

Subquery Scan on duplicates (cost=32,692.73..32,705.34 rows=2,400 width=36) (actual time=261.516..261.516 rows=0 loops=1)

6. 0.002 261.515 ↓ 0.0 0 1

HashAggregate (cost=32,692.73..32,693.10 rows=24 width=32) (actual time=261.515..261.515 rows=0 loops=1)

  • Group Key: horanet_operation."time", horanet_operation.activity_id, horanet_operation.infrastructure_id, horanet_operation.partner_id, horanet_operation.tag_id, horanet_operation.device_id
  • Filter: (count(*) > 1)
7. 261.513 261.513 ↓ 0.0 0 1

Seq Scan on horanet_operation (cost=0.00..32,691.47 rows=56 width=32) (actual time=261.513..261.513 rows=0 loops=1)

  • Filter: (("time" > '2020-08-01 00:00:00'::timestamp without time zone) AND (action_id = 8))
  • Rows Removed by Filter: 896,121
8. 0.000 0.000 ↓ 0.0 0

Index Scan using exploitation_engine_result_trigger_operation on exploitation_engine_result (cost=0.42..2.60 rows=1 width=10) (never executed)

  • Index Cond: (trigger_operation_id = "ANY_subquery".unnest)
Planning time : 0.246 ms
Execution time : 261.618 ms