explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yIOA

Settings
# exclusive inclusive rows x rows loops node
1. 0.098 4.770 ↑ 1.0 1 1

Aggregate (cost=2,732.24..2,732.25 rows=1 width=8) (actual time=4.769..4.770 rows=1 loops=1)

2. 0.236 4.672 ↓ 2.6 337 1

Nested Loop (cost=1.01..2,731.91 rows=131 width=4) (actual time=2.425..4.672 rows=337 loops=1)

  • Join Filter: (integratio0_.workshop_id = workshop1_1_.id)
3. 0.381 2.369 ↓ 1.5 689 1

Nested Loop (cost=0.71..2,518.44 rows=456 width=20) (actual time=0.024..2.369 rows=689 loops=1)

4. 0.610 0.610 ↓ 1.5 689 1

Index Scan using integration_batches_created_date_idx on integration_batches integratio0_ (cost=0.42..137.08 rows=456 width=20) (actual time=0.016..0.610 rows=689 loops=1)

  • Index Cond: ((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))
5. 1.378 1.378 ↑ 1.0 1 689

Index Only Scan using idx_workshops_id on workshops workshop1_ (cost=0.29..5.22 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=689)

  • Index Cond: (id = integratio0_.workshop_id)
  • Heap Fetches: 689
6. 2.067 2.067 ↓ 0.0 0 689

Index Scan using idx_companies_id on companies workshop1_1_ (cost=0.29..0.46 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=689)

  • Index Cond: (id = workshop1_.id)
  • Filter: (account_id = 2)
  • Rows Removed by Filter: 1
Planning time : 2.111 ms
Execution time : 4.825 ms