explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fF1T

Settings
# exclusive inclusive rows x rows loops node
1. 31.308 171.229 ↑ 1.0 1 1

Aggregate (cost=22,673.89..22,673.90 rows=1 width=8) (actual time=171.228..171.229 rows=1 loops=1)

2. 11.394 139.921 ↓ 5.8 69,129 1

Gather (cost=1,107.36..22,643.93 rows=11,984 width=16) (actual time=1.246..139.921 rows=69,129 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 14.515 128.527 ↓ 4.9 34,564 2 / 2

Hash Anti Join (cost=107.36..20,445.53 rows=7,049 width=16) (actual time=0.875..128.527 rows=34,564 loops=2)

  • Hash Cond: (((api_host.account)::text = (api_ack.account)::text) AND (api_rule.id = api_ack.rule_id))
4. 26.340 113.785 ↓ 4.4 43,081 2 / 2

Hash Join (cost=83.68..20,093.89 rows=9,722 width=27) (actual time=0.625..113.785 rows=43,081 loops=2)

  • Hash Cond: (api_currentreport.rule_id = api_rule.id)
5. 23.115 86.936 ↓ 9.3 113,064 2 / 2

Nested Loop (cost=0.86..19,978.95 rows=12,195 width=27) (actual time=0.060..86.936 rows=113,064 loops=2)

6. 5.459 5.459 ↓ 2.2 9,727 2 / 2

Parallel Index Only Scan using api_host_account_system_uuid_stale_warn_at_index on api_host (cost=0.43..1,038.07 rows=4,375 width=23) (actual time=0.033..5.459 rows=9,727 loops=2)

  • Index Cond: ((account = '729650'::text) AND (stale_warn_at > '2020-05-16 16:16:47.586377+00'::timestamp with time zone))
  • Heap Fetches: 0
7. 58.362 58.362 ↑ 1.3 12 19,454 / 2

Index Only Scan using api_currentreport_system_uuid_rule_id_index on api_currentreport (cost=0.43..4.17 rows=16 width=20) (actual time=0.004..0.006 rows=12 loops=19,454)

  • Index Cond: (system_uuid = api_host.system_uuid)
  • Heap Fetches: 0
8. 0.205 0.509 ↑ 1.0 1,018 2 / 2

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

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
9. 0.304 0.304 ↑ 1.0 1,018 2 / 2

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.017..0.304 rows=1,018 loops=2)

  • Index Cond: (active = true)
  • Filter: active
  • Heap Fetches: 0
10. 0.103 0.227 ↑ 1.0 351 2 / 2

Hash (cost=18.42..18.42 rows=351 width=11) (actual time=0.227..0.227 rows=351 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
11. 0.124 0.124 ↑ 1.0 351 2 / 2

Index Only Scan using api_ack_account_rule_id_index on api_ack (cost=0.28..18.42 rows=351 width=11) (actual time=0.030..0.124 rows=351 loops=2)

  • Index Cond: (account = '729650'::text)
  • Heap Fetches: 0
Planning time : 1.225 ms
Execution time : 171.366 ms