explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1yTT

Settings
# exclusive inclusive rows x rows loops node
1. 395.858 395.858 ↑ 2.0 1 1

CTE Scan on pair (cost=119,770.55..119,770.59 rows=2 width=64) (actual time=395.856..395.858 rows=1 loops=1)

2.          

CTE pair

3. 0.002 395.856 ↑ 2.0 1 1

Unique (cost=119,770.54..119,770.55 rows=2 width=64) (actual time=395.854..395.856 rows=1 loops=1)

4. 0.012 395.854 ↑ 1.0 2 1

Sort (cost=119,770.54..119,770.54 rows=2 width=64) (actual time=395.853..395.854 rows=2 loops=1)

  • Sort Key: d.bo_document_fkey, d.id
  • Sort Method: quicksort Memory: 25kB
5. 0.000 395.842 ↑ 1.0 2 1

Append (cost=0.86..119,770.53 rows=2 width=64) (actual time=0.033..395.842 rows=2 loops=1)

6. 0.003 0.034 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..6.91 rows=1 width=19) (actual time=0.032..0.034 rows=1 loops=1)

7. 0.018 0.018 ↑ 1.0 1 1

Index Scan using bo_contract_hardwood_deal__bo_document_fkey on bo_contract_hardwood_deal d (cost=0.43..4.45 rows=1 width=28) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: ((bo_document_fkey)::text = 'P_1349840'::text)
8. 0.013 0.013 ↑ 1.0 1 1

Index Only Scan using bo_contract_hardwood_deal_220_parent_fkey_id on bo_contract_hardwood_deal d2 (cost=0.43..2.45 rows=1 width=9) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (parent_fkey = (d.deal_pair_fkey)::text)
  • Heap Fetches: 0
9. 18.518 409.335 ↑ 1.0 1 1

Gather (cost=1,004.46..119,763.60 rows=1 width=19) (actual time=395.703..409.335 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
10. 246.719 390.817 ↓ 0.0 0 3 / 3

Hash Join (cost=4.46..118,763.50 rows=1 width=19) (actual time=271.425..390.817 rows=0 loops=3)

  • Hash Cond: ((d_1.deal_pair_fkey)::text = (d2_1.parent_fkey)::text)
11. 144.058 144.058 ↑ 1.3 1,278,198 3 / 3

Parallel Seq Scan on bo_contract_hardwood_deal d_1 (cost=0.00..112,767.48 rows=1,597,748 width=28) (actual time=0.010..144.058 rows=1,278,198 loops=3)

12. 0.003 0.040 ↑ 1.0 1 3 / 3

Hash (cost=4.45..4.45 rows=1 width=9) (actual time=0.040..0.040 rows=1 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
13. 0.037 0.037 ↑ 1.0 1 3 / 3

Index Scan using bo_contract_hardwood_deal__bo_document_fkey on bo_contract_hardwood_deal d2_1 (cost=0.43..4.45 rows=1 width=9) (actual time=0.037..0.037 rows=1 loops=3)

  • Index Cond: ((bo_document_fkey)::text = 'P_1349840'::text)
Planning time : 56.041 ms
Execution time : 409.460 ms