explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XTCZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.056 ↓ 0.0 0 1

Nested Loop (cost=4.90..5.19 rows=1 width=632) (actual time=0.055..0.056 rows=0 loops=1)

2. 0.004 0.048 ↑ 1.0 1 1

HashAggregate (cost=4.76..4.77 rows=1 width=32) (actual time=0.046..0.048 rows=1 loops=1)

  • Group Key: companies.id
3. 0.018 0.044 ↑ 1.0 1 1

Hash Semi Join (cost=0.16..4.76 rows=1 width=32) (actual time=0.035..0.044 rows=1 loops=1)

  • Hash Cond: (companies.id = flows.r_company)
4. 0.018 0.018 ↑ 1.3 37 1

Seq Scan on companies (cost=0.00..4.47 rows=47 width=16) (actual time=0.009..0.018 rows=37 loops=1)

5. 0.003 0.008 ↑ 1.0 1 1

Hash (cost=0.14..0.14 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
6. 0.001 0.005 ↑ 1.0 1 1

Limit (cost=0.00..0.13 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=1)

7. 0.004 0.004 ↑ 404.0 1 1

Seq Scan on flows (cost=0.00..54.04 rows=404 width=16) (actual time=0.004..0.004 rows=1 loops=1)

8. 0.007 0.007 ↓ 0.0 0 1

Index Scan using memberships_r_company_idx on memberships (cost=0.14..0.41 rows=1 width=632) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (r_company = companies.id)
Planning time : 0.233 ms
Execution time : 0.099 ms