explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qp3R

Settings
# exclusive inclusive rows x rows loops node
1. 36.713 176.195 ↑ 1.0 1 1

Aggregate (cost=22,574.25..22,574.26 rows=1 width=8) (actual time=176.194..176.195 rows=1 loops=1)

2. 10.941 139.482 ↓ 5.8 69,129 1

Gather (cost=1,279.23..22,544.41 rows=11,934 width=16) (actual time=2.126..139.482 rows=69,129 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 11.224 128.541 ↓ 4.9 34,564 2 / 2

Hash Anti Join (cost=279.23..20,351.01 rows=7,020 width=16) (actual time=2.129..128.541 rows=34,564 loops=2)

  • Hash Cond: ((api_rule.id = ah.rule_id) AND (api_currentreport.system_uuid = ah.system_uuid))
4. 27.974 117.296 ↓ 4.9 34,564 2 / 2

Hash Join (cost=274.90..20,239.62 rows=7,020 width=20) (actual time=2.045..117.296 rows=34,564 loops=2)

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

Nested Loop (cost=0.86..19,849.87 rows=12,144 width=20) (actual time=0.077..87.457 rows=113,064 loops=2)

6. 4.546 4.546 ↓ 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,019.93 rows=4,346 width=16) (actual time=0.047..4.546 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 curreport_system_uuid_rule_id 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.221 1.865 ↑ 1.1 696 2 / 2

Hash (cost=264.81..264.81 rows=738 width=4) (actual time=1.865..1.865 rows=696 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
9. 0.344 1.644 ↑ 1.1 696 2 / 2

Hash Anti Join (cost=28.18..264.81 rows=738 width=4) (actual time=0.337..1.644 rows=696 loops=2)

  • Hash Cond: (api_rule.id = api_ack.rule_id)
10. 0.987 0.987 ↑ 1.0 1,018 2 / 2

Seq Scan on api_rule (cost=0.00..215.77 rows=1,018 width=4) (actual time=0.016..0.987 rows=1,018 loops=2)

  • Filter: active
  • Rows Removed by Filter: 259
11. 0.087 0.313 ↑ 1.0 351 2 / 2

Hash (cost=23.79..23.79 rows=351 width=4) (actual time=0.313..0.313 rows=351 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
12. 0.226 0.226 ↑ 1.0 351 2 / 2

Seq Scan on api_ack (cost=0.00..23.79 rows=351 width=4) (actual time=0.011..0.226 rows=351 loops=2)

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 752
13. 0.001 0.021 ↓ 0.0 0 2 / 2

Hash (cost=4.30..4.30 rows=2 width=20) (actual time=0.021..0.021 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
14. 0.020 0.020 ↓ 0.0 0 2 / 2

Index Only Scan using api_hostack_account_system_uuid_rule_id_index on api_hostack ah (cost=0.27..4.30 rows=2 width=20) (actual time=0.020..0.020 rows=0 loops=2)

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