explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9MgD

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.042 ↑ 1.0 3 1

HashAggregate (cost=2.16..2.20 rows=3 width=104) (actual time=0.040..0.042 rows=3 loops=1)

  • Group Key: contacts_notes.note_id
2. 0.010 0.032 ↑ 1.0 3 1

Hash Join (cost=1.09..2.15 rows=3 width=85) (actual time=0.029..0.032 rows=3 loops=1)

  • Hash Cond: (contacts_notes_associations.note_id = contacts_notes.note_id)
3. 0.010 0.010 ↑ 1.0 4 1

Seq Scan on contacts_notes_associations (cost=0.00..1.04 rows=4 width=26) (actual time=0.010..0.010 rows=4 loops=1)

4. 0.004 0.012 ↑ 1.0 3 1

Hash (cost=1.05..1.05 rows=3 width=72) (actual time=0.012..0.012 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
5. 0.008 0.008 ↑ 1.0 3 1

Seq Scan on contacts_notes (cost=0.00..1.05 rows=3 width=72) (actual time=0.006..0.008 rows=3 loops=1)

  • Filter: (company_id = '\x4d84e27b74e07bb03cee3e7e'::bytea)
  • Rows Removed by Filter: 1
Planning time : 0.254 ms
Execution time : 0.100 ms