explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Iatx

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 0.586 ↓ 1.5 3 1

Sort (cost=966.16..966.17 rows=2 width=70) (actual time=0.567..0.586 rows=3 loops=1)

  • Sort Key: notes.created_at DESC
  • Sort Method: quicksort Memory: 27kB
2. 0.041 0.557 ↓ 1.5 3 1

Nested Loop (cost=62.15..966.15 rows=2 width=70) (actual time=0.155..0.557 rows=3 loops=1)

3. 0.110 0.196 ↑ 1.9 80 1

Bitmap Heap Scan on notes_companies (cost=61.72..320.81 rows=148 width=8) (actual time=0.096..0.196 rows=80 loops=1)

  • Recheck Cond: (company_id = ANY ('{1514899,1516771,1526164,1526317,1527360,1528120,1529127,1530840,1537136,1538177,1541917,1542622,1544519,1547035,1548018,1548019,1548096,1553542,1556736,1557210,1620388,78854841,116496179,138830168,161828131}'::integer[]))
  • Heap Blocks: exact=73
4. 0.086 0.086 ↑ 1.9 80 1

Bitmap Index Scan on notes_companies_company_id_index (cost=0.00..61.69 rows=148 width=0) (actual time=0.086..0.086 rows=80 loops=1)

  • Index Cond: (company_id = ANY ('{1514899,1516771,1526164,1526317,1527360,1528120,1529127,1530840,1537136,1538177,1541917,1542622,1544519,1547035,1548018,1548019,1548096,1553542,1556736,1557210,1620388,78854841,116496179,138830168,161828131}'::integer[]))
5. 0.320 0.320 ↓ 0.0 0 80

Index Scan using notes_pkey on notes (cost=0.42..4.35 rows=1 width=66) (actual time=0.004..0.004 rows=0 loops=80)

  • Index Cond: (id = notes_companies.note_id)
  • Filter: (organization_id = 7)
  • Rows Removed by Filter: 1