explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XvOF

Settings
# exclusive inclusive rows x rows loops node
1. 18.469 170.447 ↑ 1.0 1 1

Aggregate (cost=170,015.98..170,015.99 rows=1 width=8) (actual time=170.447..170.447 rows=1 loops=1)

  • time=0.007..0.016 rows=11 loops=19473)
2. 10.059 151.978 ↓ 8.3 69,181 1

Gather (cost=1,262.03..169,995.22 rows=8,303 width=4) (actual time=1.441..151.978 rows=69,181 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 16.507 141.919 ↓ 6.7 23,060 3 / 3

Hash Join (cost=262.03..168,164.92 rows=3,460 width=4) (actual time=1.148..141.919 rows=23,060 loops=3)

  • Hash Cond: (api_currentreport.rule_id = api_rule.id)
4. 116.698 124.607 ↓ 16.1 69,745 3 / 3

Nested Loop (cost=25.54..167,917.00 rows=4,340 width=4) (actual time=0.324..124.607 rows=69,745 loops=3)

  • -> Index Only Scan using curreport_system_uuid_rule_id on api_currentreport (cost=25.11..53.17 rows=37 width=20) (actual
5. 7.714 7.909 ↓ 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.019..7.909 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: 3011
  • Index Cond: (system_uuid = api_host.system_uuid)
  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 1
  • Heap Fetches: 20131
6.          

SubPlan (for Parallel Index Only Scan)

7. 0.195 0.195 ↑ 1.0 351 3 / 3

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

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 752
8. 0.197 0.805 ↑ 1.0 1,018 3 / 3

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

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

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

  • Filter: active
  • Rows Removed by Filter: 259
Planning time : 0.484 ms
Execution time : 170.558 ms