explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MUAQ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 87.336 572.739 ↓ 1.0 14,473 1

Sort (cost=39,456.52..39,492.37 rows=14,341 width=208) (actual time=544.380..572.739 rows=14,473 loops=1)

  • Sort Key: zags_az.az_date DESC
  • Sort Method: quicksort Memory: 4119kB
2. 81.677 485.403 ↓ 1.0 14,473 1

Gather (cost=2,098.95..38,466.43 rows=14,341 width=208) (actual time=106.774..485.403 rows=14,473 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 40.111 403.726 ↑ 1.2 7,236 2

Hash Join (cost=1,098.95..36,032.33 rows=8,436 width=208) (actual time=103.332..403.726 rows=7,236 loops=2)

  • Hash Cond: (doc_management_request_az.zags_list_azkind_id = zags_list_azkind.zags_list_azkind_id)
4. 129.010 363.459 ↑ 1.2 7,236 2

Nested Loop (cost=1,097.79..35,935.36 rows=8,436 width=184) (actual time=102.809..363.459 rows=7,236 loops=2)

5. 46.911 234.439 ↑ 1.2 7,236 2

Hash Join (cost=1,097.37..4,907.61 rows=8,436 width=36) (actual time=102.710..234.439 rows=7,236 loops=2)

  • Hash Cond: (zags_az.zags_az_id = doc_management_request_az.zags_az_id)
6. 85.350 85.350 ↑ 1.2 8,624 2

Parallel Seq Scan on zags_az (cost=0.00..2,894.76 rows=10,076 width=28) (actual time=0.070..85.350 rows=8,624 loops=2)

7. 45.347 102.178 ↓ 1.0 14,473 2

Hash (cost=918.10..918.10 rows=14,341 width=24) (actual time=102.178..102.178 rows=14,473 loops=2)

  • Buckets: 16384 Batches: 1 Memory Usage: 920kB
8. 56.831 56.831 ↓ 1.0 14,473 2

Index Scan using doc_management_request_request_id on doc_management_request_az (cost=0.42..918.10 rows=14,341 width=24) (actual time=0.335..56.831 rows=14,473 loops=2)

  • Index Cond: (doc_management_request_id = 550)
  • Filter: az_is_found
9. 0.010 0.010 ↑ 1.0 1 14,473

Index Scan using government_list_body_pkey on government_list_body (cost=0.42..3.68 rows=1 width=164) (actual time=0.010..0.010 rows=1 loops=14,473)

  • Index Cond: (government_list_body_id = zags_az.az_first_gov_list_body_id)
10. 0.078 0.156 ↑ 1.0 7 2

Hash (cost=1.07..1.07 rows=7 width=40) (actual time=0.156..0.156 rows=7 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.078 0.078 ↑ 1.0 7 2

Seq Scan on zags_list_azkind (cost=0.00..1.07 rows=7 width=40) (actual time=0.058..0.078 rows=7 loops=2)