explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ux8v

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

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

2.          

CTE pair

3. 0.003 422.995 ↑ 2.0 1 1

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

4. 0.015 422.992 ↑ 1.0 2 1

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

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

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

6. 0.002 0.033 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..6.91 rows=1 width=19) (actual time=0.032..0.033 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. 19.458 438.047 ↑ 1.0 1 1

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

  • Workers Planned: 2
  • Workers Launched: 2
10. 265.213 418.589 ↓ 0.0 0 3 / 3

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

  • Hash Cond: ((d_1.deal_pair_fkey)::text = (d2_1.parent_fkey)::text)
11. 153.337 153.337 ↑ 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.009..153.337 rows=1,278,198 loops=3)

12. 0.003 0.039 ↑ 1.0 1 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
13. 0.036 0.036 ↑ 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.035..0.036 rows=1 loops=3)

  • Index Cond: ((bo_document_fkey)::text = 'P_1349840'::text)
Planning time : 55.417 ms
Execution time : 438.179 ms