explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iaqZ

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

Finalize Aggregate (cost=55,296.27..55,296.28 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=55,296.06..55,296.27 rows=2 width=8) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=54,296.06..54,296.07 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,860.98..54,295.97 rows=35 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Merge Join (cost=6,860.56..10,034.77 rows=12,220 width=12) (actual rows= loops=)

  • Merge Cond: (workshop1_.id = workshop1_1_.id)
6. 0.000 0.000 ↓ 0.0

Parallel Index Only Scan using idx_workshops_id on workshops workshop1_ (cost=0.29..2,800.44 rows=42,699 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Sort (cost=6,860.06..6,933.74 rows=29,472 width=4) (actual rows= loops=)

  • Sort Key: workshop1_1_.id
8. 0.000 0.000 ↓ 0.0

Seq Scan on companies workshop1_1_ (cost=0.00..4,672.20 rows=29,472 width=4) (actual rows= loops=)

  • Filter: (account_id = 2)
9. 0.000 0.000 ↓ 0.0

Index Scan using idx_integration_batches on integration_batches integratio0_ (cost=0.42..3.61 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (workshop_id = workshop1_.id)
  • Filter: ((created_date >= '2020-07-29 00:00:00'::timestamp without time zone) AND (created_date <= '2020-07-30 00:00:00'::timestamp without time zone))