explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YF0P

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.163 ↑ 1.0 10 1

Limit (cost=4.31..23.44 rows=10 width=3,425) (actual time=0.092..0.163 rows=10 loops=1)

2. 0.091 0.160 ↑ 2.1 10 1

Bitmap Heap Scan on document (cost=4.31..44.49 rows=21 width=3,425) (actual time=0.091..0.160 rows=10 loops=1)

  • Recheck Cond: (document_type_id = 1)
  • Heap Blocks: exact=7
3. 0.069 0.069 ↓ 1.9 40 1

Bitmap Index Scan on document_document_type_id_7662c031 (cost=0.00..4.30 rows=21 width=0) (actual time=0.069..0.069 rows=40 loops=1)

  • Index Cond: (document_type_id = 1)
Planning time : 0.426 ms
Execution time : 0.230 ms