explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vTPM

Settings
# exclusive inclusive rows x rows loops node
1. 46.682 764.693 ↑ 1.0 1 1

Aggregate (cost=73,786.98..73,786.99 rows=1 width=72) (actual time=764.693..764.693 rows=1 loops=1)

2. 0.000 718.011 ↓ 8.2 68,847 1

Gather (cost=1,689.30..73,430.45 rows=8,389 width=17) (actual time=16.739..718.011 rows=68,847 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 8.492 726.571 ↓ 6.6 22,949 3 / 3

Hash Join (cost=689.30..71,591.55 rows=3,495 width=17) (actual time=16.288..726.571 rows=22,949 loops=3)

  • Hash Cond: (api_rule.category_id = api_rulecategory.id)
4. 15.844 718.037 ↓ 6.6 22,949 3 / 3

Hash Join (cost=688.21..71,571.56 rows=3,495 width=10) (actual time=16.167..718.037 rows=22,949 loops=3)

  • Hash Cond: (api_currentreport.rule_id = api_rule.id)
5. 233.135 700.499 ↓ 15.8 69,551 3 / 3

Hash Join (cost=460.80..71,332.55 rows=4,408 width=4) (actual time=14.445..700.499 rows=69,551 loops=3)

  • Hash Cond: (api_currentreport.system_uuid = api_host.system_uuid)
6. 453.288 453.556 ↓ 1.5 1,480,203 3 / 3

Parallel Seq Scan on api_currentreport (cost=24.53..68,329.73 rows=977,728 width=20) (actual time=0.454..453.556 rows=1,480,203 loops=3)

  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 84177
7.          

SubPlan (for Parallel Seq Scan)

8. 0.268 0.268 ↑ 1.0 351 3 / 3

Seq Scan on api_ack u2 (cost=0.00..23.65 rows=351 width=4) (actual time=0.016..0.268 rows=351 loops=3)

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 741
9. 5.863 13.808 ↓ 2.5 19,445 3 / 3

Hash (cost=340.95..340.95 rows=7,626 width=16) (actual time=13.808..13.808 rows=19,445 loops=3)

  • Buckets: 32768 (originally 8192) Batches: 1 (originally 1) Memory Usage: 1168kB
10. 7.945 7.945 ↓ 2.5 19,445 3 / 3

Index Only Scan using api_host_account_stale_warn_at_system_uuid_index on api_host (cost=0.43..340.95 rows=7,626 width=16) (actual time=0.065..7.945 rows=19,445 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
11. 0.317 1.694 ↑ 1.0 1,012 3 / 3

Hash (cost=214.76..214.76 rows=1,012 width=10) (actual time=1.694..1.694 rows=1,012 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
12. 1.377 1.377 ↑ 1.0 1,012 3 / 3

Seq Scan on api_rule (cost=0.00..214.76 rows=1,012 width=10) (actual time=0.015..1.377 rows=1,012 loops=3)

  • Filter: active
  • Rows Removed by Filter: 264
13. 0.006 0.042 ↑ 1.0 4 3 / 3

Hash (cost=1.04..1.04 rows=4 width=15) (actual time=0.042..0.042 rows=4 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.036 0.036 ↑ 1.0 4 3 / 3

Seq Scan on api_rulecategory (cost=0.00..1.04 rows=4 width=15) (actual time=0.035..0.036 rows=4 loops=3)

Planning time : 0.814 ms
Execution time : 764.831 ms