explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9lS : delete rap

Settings
# exclusive inclusive rows x rows loops node
1. 24,769.796 24,821.569 ↓ 0.0 0 1

Delete on activerogueaplist (cost=1,093.40..1,416.39 rows=9,599 width=32) (actual time=24,821.569..24,821.569 rows=0 loops=1)

2. 18.091 51.773 ↓ 1.3 12,302 1

Hash Join (cost=1,093.40..1,416.39 rows=9,599 width=32) (actual time=25.064..51.773 rows=12,302 loops=1)

  • Hash Cond: (activerogueaplist.detectorap = "ANY_subquery".detectorap)
3. 8.634 8.634 ↓ 1.4 13,668 1

Seq Scan on activerogueaplist (cost=0.00..286.99 rows=9,599 width=8) (actual time=0.007..8.634 rows=13,668 loops=1)

4. 0.511 25.048 ↓ 1.3 1,539 1

Hash (cost=1,078.11..1,078.11 rows=1,223 width=28) (actual time=25.048..25.048 rows=1,539 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 104kB
5. 4.428 24.537 ↓ 1.3 1,539 1

HashAggregate (cost=1,065.88..1,078.11 rows=1,223 width=28) (actual time=24.127..24.537 rows=1,539 loops=1)

  • Group Key: "ANY_subquery".detectorap
6. 4.699 20.109 ↓ 1.3 12,214 1

Subquery Scan on ANY_subquery (cost=921.90..1,041.89 rows=9,599 width=28) (actual time=8.205..20.109 rows=12,214 loops=1)

7. 5.639 15.410 ↓ 1.3 12,214 1

Limit (cost=921.90..945.90 rows=9,599 width=6) (actual time=8.188..15.410 rows=12,214 loops=1)

8. 6.026 9.771 ↓ 1.3 12,214 1

Sort (cost=921.90..945.90 rows=9,599 width=6) (actual time=8.187..9.771 rows=12,214 loops=1)

  • Sort Key: activerogueaplist_1.lastseentime
  • Sort Method: quicksort Memory: 1025kB
9. 3.745 3.745 ↓ 1.4 13,668 1

Seq Scan on activerogueaplist activerogueaplist_1 (cost=0.00..286.99 rows=9,599 width=6) (actual time=0.004..3.745 rows=13,668 loops=1)