explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i1h1

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

inalize Aggregate (cost=2,684,564,053,637.09..2,684,564,053,637.10 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=2,684,564,053,636.88..2,684,564,053,637.08 rows=2 width=8) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=2,684,564,052,636.88..2,684,564,052,636.88 rows=1 width=8) (actual rows= loops=)

  • -> Parallel Index Only Scan using index_listings_on_source_id on listings
  • (cost=0.56..2684564041656.88 rows=4391999 width=0)
  • Filter: (NOT (SubPlan 1))
4.          

SubPlan (for Partial Aggregate)

5. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..607,553.21 rows=1,474,540 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on products (cost=0.00..594,420.51 rows=1,474,540 width=4) (actual rows= loops=)

  • Filter: ((site_id IS NOT NULL) AND (item_id IS NOT NULL))