explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QgoI

Settings
# exclusive inclusive rows x rows loops node
1. 43.827 883.586 ↑ 1.0 1 1

Aggregate (cost=74,585.43..74,585.44 rows=1 width=8) (actual time=883.586..883.586 rows=1 loops=1)

2. 3.136 839.759 ↓ 8.4 69,129 1

Gather (cost=1,673.70..74,564.86 rows=8,229 width=16) (actual time=17.834..839.759 rows=69,129 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 18.658 836.623 ↓ 6.7 23,043 3 / 3

Hash Join (cost=673.70..72,741.96 rows=3,429 width=16) (actual time=16.525..836.623 rows=23,043 loops=3)

  • Hash Cond: (api_currentreport.rule_id = api_rule.id)
4. 277.492 816.835 ↓ 16.2 69,692 3 / 3

Hash Join (cost=445.20..72,502.14 rows=4,301 width=20) (actual time=15.283..816.835 rows=69,692 loops=3)

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

Parallel Seq Scan on api_currentreport (cost=24.67..69,472.09 rows=994,097 width=20) (actual time=0.420..524.619 rows=1,506,688 loops=3)

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

SubPlan (for Parallel Seq Scan)

7. 0.245 0.245 ↑ 1.0 351 3 / 3

Seq Scan on api_ack u2 (cost=0.00..23.79 rows=351 width=4) (actual time=0.017..0.245 rows=351 loops=3)

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 752
8. 6.528 14.724 ↓ 2.6 19,454 3 / 3

Hash (cost=328.19..328.19 rows=7,388 width=16) (actual time=14.724..14.724 rows=19,454 loops=3)

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

Index Only Scan using api_host_account_stale_warn_at_system_uuid_index on api_host (cost=0.43..328.19 rows=7,388 width=16) (actual time=0.051..8.196 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.251 1.130 ↑ 1.0 1,018 3 / 3

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

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

Seq Scan on api_rule (cost=0.00..215.77 rows=1,018 width=4) (actual time=0.020..0.879 rows=1,018 loops=3)

  • Filter: active
  • Rows Removed by Filter: 259
Planning time : 1.275 ms
Execution time : 883.809 ms