explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LcZw

Settings
# exclusive inclusive rows x rows loops node
1. 30.500 771.502 ↑ 1.0 1 1

Aggregate (cost=74,426.40..74,426.41 rows=1 width=8) (actual time=771.501..771.502 rows=1 loops=1)

2. 5.222 741.002 ↓ 8.5 69,129 1

Gather (cost=1,520.90..74,405.98 rows=8,169 width=16) (actual time=16.834..741.002 rows=69,129 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 15.950 735.780 ↓ 6.8 23,043 3 / 3

Hash Join (cost=520.90..72,589.08 rows=3,404 width=16) (actual time=14.661..735.780 rows=23,043 loops=3)

  • Hash Cond: (api_currentreport.rule_id = api_rule.id)
4. 245.368 719.169 ↓ 16.3 69,692 3 / 3

Hash Join (cost=438.08..72,495.02 rows=4,270 width=20) (actual time=13.915..719.169 rows=69,692 loops=3)

  • Hash Cond: (api_currentreport.system_uuid = api_host.system_uuid)
5. 460.118 460.251 ↓ 1.5 1,506,688 3 / 3

Parallel Seq Scan on api_currentreport (cost=19.30..69,466.72 rows=994,097 width=20) (actual time=0.271..460.251 rows=1,506,688 loops=3)

  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 83860
6.          

SubPlan (for Parallel Seq Scan)

7. 0.133 0.133 ↑ 1.0 351 3 / 3

Index Only Scan using api_ack_account_rule_id_index on api_ack u2 (cost=0.28..18.42 rows=351 width=4) (actual time=0.052..0.133 rows=351 loops=3)

  • Index Cond: (account = '729650'::text)
  • Heap Fetches: 0
8. 6.129 13.550 ↓ 2.7 19,454 3 / 3

Hash (cost=327.11..327.11 rows=7,334 width=16) (actual time=13.550..13.550 rows=19,454 loops=3)

  • Buckets: 32768 (originally 8192) Batches: 1 (originally 1) Memory Usage: 1168kB
9. 7.421 7.421 ↓ 2.7 19,454 3 / 3

Index Only Scan using api_host_account_stale_warn_at_system_uuid_index on api_host (cost=0.43..327.11 rows=7,334 width=16) (actual time=0.031..7.421 rows=19,454 loops=3)

  • Index Cond: ((account = '729650'::text) AND (stale_warn_at > '2020-05-16 16:16:47.586377+00'::timestamp with time zone))
  • Heap Fetches: 0
10. 0.263 0.661 ↑ 1.0 1,018 3 / 3

Hash (cost=70.09..70.09 rows=1,018 width=4) (actual time=0.661..0.661 rows=1,018 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
11. 0.398 0.398 ↑ 1.0 1,018 3 / 3

Index Only Scan using api_rule_active_id_rule_id_index2 on api_rule (cost=0.28..70.09 rows=1,018 width=4) (actual time=0.028..0.398 rows=1,018 loops=3)

  • Index Cond: (active = true)
  • Filter: active
  • Heap Fetches: 0
Planning time : 1.149 ms
Execution time : 771.630 ms