explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JQxY

Settings
# exclusive inclusive rows x rows loops node
1. 6.423 74.773 ↓ 0.0 0 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 24.460 68.350 ↓ 0.0 0 3 / 3

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

  • Hash Cond: (deals.id = company_deals_listing.deal_id)
  • Filter: (company_deals_listing.id IS NULL)
  • Rows Removed by Filter: 101885
3. 9.786 9.786 ↑ 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.044..9.786 rows=50,943 loops=3)

  • Heap Fetches: 67014
4. 21.153 34.104 ↑ 1.3 101,885 3 / 3

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

  • Buckets: 524288 Batches: 1 Memory Usage: 23296kB
5. 12.951 12.951 ↑ 1.3 101,885 3 / 3

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

Planning time : 0.307 ms
Execution time : 74.803 ms