explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S06h

Settings
# exclusive inclusive rows x rows loops node
1. 4.747 149.251 ↓ 5.0 1,246 1

Nested Loop (cost=19,383.45..19,980.44 rows=248 width=577) (actual time=135.066..149.251 rows=1,246 loops=1)

  • Join Filter: (task_control_xprocess.strategy_id = strategy_strategy.id)
  • Rows Removed by Join Filter: 35,329
  • rows=3,885 loops=1)
2. 6.212 139.520 ↑ 1.6 1,246 1

Index Scan Backward using task_control_xprocess_start_time_84757861 on task_control_xprocess (cost=19,383.45..19,806.17 rows=1,942 width=577) (actual time=134.430..139.520 rows=1,246 loops=1)

  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 2,639
3.          

SubPlan (for Index Scan Backward)

4. 128.986 133.308 ↓ 2,639.0 2,639 1

Hash Right Join (cost=378.41..19,383.17 rows=1 width=4) (actual time=132.897..133.308 rows=2,639 loops=1)

  • Hash Cond: (u1.xprocess_id = u0.id)
  • Filter: (u1.id IS NULL)
  • Rows Removed by Filter: 88,832
  • -> Seq Scan on task_result_vulnresult u1 (cost=0.00..18771.32 rows=88,832 width=8) (actual time=0.008..83.717rows=88,832 loops=1)
5. 4.322 4.322 ↑ 1.0 3,885 1

Hash (cost=329.85..329.85 rows=3,885 width=4) (actual time=4.321..4.322 rows=3,885 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 169kB
  • -> Seq Scan on task_control_xprocess u0 (cost=0.00..329.85 rows=3,885 width=4) (actual time=0.123..3.270
6. 4.361 4.984 ↓ 4.8 29 1,246

Materialize (cost=0.00..2.15 rows=6 width=4) (actual time=0.001..0.004 rows=29 loops=1,246)

7. 0.623 0.623 ↓ 6.5 39 1

Seq Scan on strategy_strategy (cost=0.00..2.12 rows=6 width=4) (actual time=0.611..0.623 rows=39 loops=1)

  • Filter: ((NOT hardware_only) AND ((name)::text = ANY ('{basic_web,basic_host,domain_detection,mirror_detection,host_monitor,proxy_web_passive,log_web_passive,mirror_web_passive,mirror_host_passive,specific_service,logic_web}'::text[])))
  • Rows Removed by Filter: 8
Planning time : 7.987 ms
Execution time : 149.483 ms