explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2vx5

Settings
# exclusive inclusive rows x rows loops node
1. 25.088 124.465 ↑ 1.0 1 1

Aggregate (cost=22,826.75..22,826.76 rows=1 width=8) (actual time=124.464..124.465 rows=1 loops=1)

2. 8.089 99.377 ↓ 5.7 67,628 1

Gather (cost=1,275.97..22,796.84 rows=11,966 width=16) (actual time=1.449..99.377 rows=67,628 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 20.341 91.288 ↓ 4.8 33,814 2 / 2

Hash Join (cost=275.97..20,600.24 rows=7,039 width=16) (actual time=1.201..91.288 rows=33,814 loops=2)

  • Hash Cond: (api_currentreport.rule_id = api_rule.id)
4. 17.463 69.825 ↓ 9.3 113,442 2 / 2

Nested Loop (cost=0.86..20,208.87 rows=12,224 width=20) (actual time=0.036..69.825 rows=113,442 loops=2)

5. 3.520 3.520 ↓ 2.2 9,768 2 / 2

Parallel Index Only Scan using api_host_account_system_uuid_stale_warn_at_index on api_host (cost=0.43..1,019.80 rows=4,404 width=16) (actual time=0.022..3.520 rows=9,768 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
6. 48.843 48.843 ↑ 1.4 12 19,537 / 2

Index Only Scan using curreport_system_uuid_rule_id on api_currentreport (cost=0.43..4.19 rows=17 width=20) (actual time=0.003..0.005 rows=12 loops=19,537)

  • Index Cond: (system_uuid = api_host.system_uuid)
  • Heap Fetches: 0
7. 0.137 1.122 ↑ 1.1 695 2 / 2

Hash (cost=265.88..265.88 rows=739 width=4) (actual time=1.122..1.122 rows=695 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
8. 0.217 0.985 ↑ 1.1 695 2 / 2

Hash Anti Join (cost=29.25..265.88 rows=739 width=4) (actual time=0.265..0.985 rows=695 loops=2)

  • Hash Cond: (api_rule.id = api_ack.rule_id)
9. 0.519 0.519 ↑ 1.0 1,017 2 / 2

Seq Scan on api_rule (cost=0.00..215.83 rows=1,017 width=4) (actual time=0.007..0.519 rows=1,017 loops=2)

  • Filter: active
  • Rows Removed by Filter: 266
10. 0.063 0.249 ↑ 1.0 351 2 / 2

Hash (cost=24.86..24.86 rows=351 width=4) (actual time=0.249..0.249 rows=351 loops=2)

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

Seq Scan on api_ack (cost=0.00..24.86 rows=351 width=4) (actual time=0.005..0.186 rows=351 loops=2)

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 758
Planning time : 0.607 ms
Execution time : 124.562 ms