explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZTMk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 64.091 ↓ 0.0 0 1

Limit (cost=7,071.62..10,602.11 rows=1 width=16) (actual time=64.091..64.091 rows=0 loops=1)

2. 6.551 66.604 ↓ 0.0 0 1

Gather (cost=7,071.62..10,602.11 rows=1 width=16) (actual time=64.090..66.604 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 21.697 60.053 ↓ 0.0 0 3 / 3

Parallel Hash Left Join (cost=6,071.62..9,602.01 rows=1 width=16) (actual time=60.053..60.053 rows=0 loops=3)

  • Hash Cond: (deals.id = company_deals_listing.deal_id)
  • Filter: (company_deals_listing.id IS NULL)
  • Rows Removed by Filter: 101,887
4. 8.815 8.815 ↑ 1.2 50,943 3 / 3

Parallel Index Only Scan using deals_pkey on deals (cost=0.42..2,762.99 rows=63,355 width=16) (actual time=0.034..8.815 rows=50,943 loops=3)

  • Heap Fetches: 68,480
5. 18.124 29.541 ↑ 1.3 101,887 3 / 3

Parallel Hash (cost=4,474.98..4,474.98 rows=127,698 width=32) (actual time=29.541..29.541 rows=101,887 loops=3)

  • Buckets: 524,288 Batches: 1 Memory Usage: 23,264kB
6. 11.417 11.417 ↑ 1.3 101,887 3 / 3

Parallel Seq Scan on company_deals_listing (cost=0.00..4,474.98 rows=127,698 width=32) (actual time=0.010..11.417 rows=101,887 loops=3)

Planning time : 0.176 ms
Execution time : 66.628 ms