explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JXfQ

Settings
# exclusive inclusive rows x rows loops node
1. 15.344 147.516 ↑ 1.0 1 1

Aggregate (cost=99,083.30..99,083.31 rows=1 width=8) (actual time=147.516..147.516 rows=1 loops=1)

2. 12.008 132.172 ↓ 8.3 69,196 1

Gather (cost=1,262.03..99,062.43 rows=8,350 width=4) (actual time=1.373..132.172 rows=69,196 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 16.334 120.164 ↓ 6.6 23,065 3 / 3

Hash Join (cost=262.03..97,227.43 rows=3,479 width=4) (actual time=1.122..120.164 rows=23,065 loops=3)

  • Hash Cond: (api_currentreport.rule_id = api_rule.id)
4. 16.998 103.046 ↓ 16.0 69,760 3 / 3

Nested Loop (cost=25.54..96,979.44 rows=4,364 width=4) (actual time=0.315..103.046 rows=69,760 loops=3)

5. 8.136 8.136 ↓ 2.1 6,493 3 / 3

Parallel Index Only Scan using api_host_account_system_uuid_stale_warn_at_index on api_host (cost=0.43..1,274.99 rows=3,114 width=16) (actual time=0.020..8.136 rows=6,493 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: 640
6. 77.726 77.912 ↑ 3.5 11 19,478 / 3

Index Only Scan using curreport_system_uuid_rule_id on api_currentreport (cost=25.11..30.35 rows=38 width=20) (actual time=0.007..0.012 rows=11 loops=19,478)

  • Index Cond: (system_uuid = api_host.system_uuid)
  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 1
  • Heap Fetches: 2495
7.          

SubPlan (for Index Only Scan)

8. 0.186 0.186 ↑ 1.0 351 3 / 3

Seq Scan on api_ack u2 (cost=0.00..23.68 rows=351 width=4) (actual time=0.007..0.186 rows=351 loops=3)

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 752
9. 0.195 0.784 ↑ 1.0 1,018 3 / 3

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

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

Seq Scan on api_rule (cost=0.00..223.77 rows=1,018 width=4) (actual time=0.006..0.589 rows=1,018 loops=3)

  • Filter: active
  • Rows Removed by Filter: 259
Planning time : 0.487 ms
Execution time : 147.621 ms