explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TCZx

Settings
# exclusive inclusive rows x rows loops node
1. 14.307 156.740 ↑ 1.0 1 1

Aggregate (cost=94,707.62..94,707.63 rows=1 width=8) (actual time=156.739..156.740 rows=1 loops=1)

2. 11.049 142.433 ↓ 5.7 69,181 1

Gather (cost=1,282.91..94,677.52 rows=12,042 width=4) (actual time=1.575..142.433 rows=69,181 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 18.494 131.384 ↓ 4.6 23,060 3 / 3

Hash Join (cost=282.91..92,473.32 rows=5,018 width=4) (actual time=1.342..131.384 rows=23,060 loops=3)

  • Hash Cond: (api_currentreport.rule_id = api_rule.id)
4. 15.387 111.644 ↓ 8.7 75,429 3 / 3

Nested Loop (cost=0.98..92,108.68 rows=8,680 width=4) (actual time=0.038..111.644 rows=75,429 loops=3)

5. 11.874 11.874 ↓ 2.1 6,491 3 / 3

Parallel Index Only Scan using api_host_account_system_uuid_stale_warn_at_index on api_host (cost=0.43..1,296.65 rows=3,112 width=16) (actual time=0.021..11.874 rows=6,491 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: 3,690
6. 84.383 84.383 ↑ 6.2 12 19,473 / 3

Index Only Scan using curreport_system_uuid_rule_id on api_currentreport (cost=0.56..28.43 rows=75 width=20) (actual time=0.007..0.013 rows=12 loops=19,473)

  • Index Cond: (system_uuid = api_host.system_uuid)
  • Heap Fetches: 24,898
7. 0.137 1.246 ↑ 1.1 696 3 / 3

Hash (cost=272.70..272.70 rows=738 width=4) (actual time=1.246..1.246 rows=696 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 33kB
8. 0.214 1.109 ↑ 1.1 696 3 / 3

Hash Anti Join (cost=28.06..272.70 rows=738 width=4) (actual time=0.279..1.109 rows=696 loops=3)

  • Hash Cond: (api_rule.id = api_ack.rule_id)
9. 0.633 0.633 ↑ 1.0 1,018 3 / 3

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

  • Filter: active
  • Rows Removed by Filter: 259
10. 0.065 0.262 ↑ 1.0 351 3 / 3

Hash (cost=23.68..23.68 rows=351 width=4) (actual time=0.262..0.262 rows=351 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 21kB
11. 0.197 0.197 ↑ 1.0 351 3 / 3

Seq Scan on api_ack (cost=0.00..23.68 rows=351 width=4) (actual time=0.008..0.197 rows=351 loops=3)

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 752
Planning time : 0.634 ms
Execution time : 156.843 ms