explain.depesz.com

PostgreSQL's explain analyze made readable

Result: raFF

Settings
# exclusive inclusive rows x rows loops node
1. 62.856 10,486.966 ↑ 1.0 300,000 1

Limit (cost=602,642.06..637,644.50 rows=300,000 width=638) (actual time=9,289.932..10,486.966 rows=300,000 loops=1)

2. 1,394.478 10,424.110 ↑ 1.9 600,000 1

Gather Merge (cost=567,639.62..698,168.40 rows=1,118,740 width=638) (actual time=8,769.289..10,424.110 rows=600,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 3,821.756 9,029.632 ↑ 2.8 200,209 3 / 3

Sort (cost=566,639.59..568,038.02 rows=559,370 width=638) (actual time=8,717.706..9,029.632 rows=200,209 loops=3)

  • Sort Key: tax.account_id, i.name
  • Sort Method: external merge Disk: 109,776kB
  • Worker 0: Sort Method: external merge Disk: 118,784kB
  • Worker 1: Sort Method: external merge Disk: 136,288kB
4. 507.086 5,207.876 ↓ 1.5 850,865 3 / 3

Hash Join (cost=52,887.43..195,858.10 rows=559,370 width=638) (actual time=3,547.939..5,207.876 rows=850,865 loops=3)

  • Hash Cond: (t.level = e.level)
5. 2,137.309 4,700.768 ↓ 1.5 850,865 3 / 3

Parallel Hash Join (cost=52,874.28..188,153.61 rows=559,370 width=122) (actual time=3,547.858..4,700.768 rows=850,865 loops=3)

  • Hash Cond: (t.billing_tax_item_id = i.id)
6. 1,179.487 1,179.487 ↑ 1.1 1,244,535 3 / 3

Parallel Seq Scan on plivo_billing_tax_item_detail t (cost=0.00..95,288.48 rows=1,323,772 width=63) (actual time=0.931..1,179.487 rows=1,244,535 loops=3)

  • Filter: (((category)::text <> 'RESERVED'::text) AND ((name)::text <> 'Carrier Cost Recovery (VoIP)'::text))
  • Rows Removed by Filter: 209,463
7. 270.772 1,383.972 ↑ 1.2 310,707 3 / 3

Parallel Hash (cost=44,082.82..44,082.82 rows=362,997 width=67) (actual time=1,383.972..1,383.972 rows=310,707 loops=3)

  • Buckets: 65,536 Batches: 32 Memory Usage: 3,648kB
8. 323.436 1,113.200 ↑ 1.2 310,707 3 / 3

Parallel Hash Join (cost=3,188.20..44,082.82 rows=362,997 width=67) (actual time=239.057..1,113.200 rows=310,707 loops=3)

  • Hash Cond: (i.billing_tax_id = tax.id)
9. 773.634 773.634 ↑ 1.3 686,791 3 / 3

Parallel Seq Scan on plivo_billing_tax_item i (cost=0.00..38,639.46 rows=859,046 width=45) (actual time=0.685..773.634 rows=686,791 loops=3)

10. 7.331 16.130 ↑ 1.8 8,877 3 / 3

Parallel Hash (cost=2,992.39..2,992.39 rows=15,665 width=30) (actual time=16.130..16.130 rows=8,877 loops=3)

  • Buckets: 32,768 Batches: 1 Memory Usage: 2,048kB
11. 8.799 8.799 ↑ 1.8 8,877 3 / 3

Parallel Seq Scan on plivo_billing_tax tax (cost=0.00..2,992.39 rows=15,665 width=30) (actual time=0.299..8.799 rows=8,877 loops=3)

  • Filter: (success AND (g_uuid = '2aa5f084-2a19-43e4-49a6-98706c099456'::uuid))
  • Rows Removed by Filter: 12,130
12. 0.006 0.022 ↑ 35.0 4 3 / 3

Hash (cost=11.40..11.40 rows=140 width=520) (actual time=0.021..0.022 rows=4 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
13. 0.016 0.016 ↑ 35.0 4 3 / 3

Seq Scan on plivo_avalara_scope_exemption e (cost=0.00..11.40 rows=140 width=520) (actual time=0.015..0.016 rows=4 loops=3)