explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wq7a

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

Custom Scan (Citus Real-Time) (cost=0.00..0.00 rows=0 width=0) (actual rows= loops=)

  • Task Count: 32
  • Tasks Shown: One of 32
  • -> Task
  • Node: host=localhost port=9701 dbname=postgres
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=34.08..71.22 rows=1,200 width=88) (actual rows= loops=)

  • Hash Cond: (departments.company_id = companies.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on departments_102653 departments (cost=0.00..22.00 rows=1,200 width=40) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=20.70..20.70 rows=1,070 width=48) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on companies_102621 companies (cost=0.00..20.70 rows=1,070 width=48) (actual rows= loops=)