explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tMp0

Settings
# exclusive inclusive rows x rows loops node
1. 1,265.195 1,392.636 ↓ 100.0 294,038 1

Bitmap Heap Scan on public.documents (cost=87.85..9,549.87 rows=2,940 width=638) (actual time=150.347..1,392.636 rows=294,038 loops=1)

  • Output: documents.sys_title, documents.sys_author, documents.sys_date_cr, documents.sys_date_mod, documents.sys_desc, documents.sys_modifier, documents.sys_file_path, documents.sys_type, documents.sys_base_type, documents.sys_file_name, documents.sys_version, documents.sys_uuid, documents.sys_parent_uuid, documents.sys_file_storage, documents.sys_readers, documents.sys_source_id, documents.ver_islast, documents.ver_parent_uuid, documents.ver_series_uuid, documents.ver_comment, (documents.data -> 'fileName'::text), (documents.data -> 'title'::text), (documents.data -> 'sourceId'::text), (documents.data -> 'invoice_date'::text), (documents.data -> 'creationTime'::text), (documents.data -> 'modificationTime'::text), (documents.data -> 'dctm_creation_date'::text), (documents.data -> 'batch_id'::text)
  • Recheck Cond: ($0 && documents.sys_readers)
  • Filter: documents.ver_islast
  • Heap Blocks: exact=49525
  • Buffers: shared hit=4 read=49639
2.          

Initplan (for Bitmap Heap Scan)

3. 0.027 0.027 ↑ 1.0 1 1

Seq Scan on public.users (cost=0.00..1.06 rows=1 width=97) (actual time=0.025..0.027 rows=1 loops=1)

  • Output: users.groups
  • Filter: ((users.userid)::text = current_setting('my.username'::text))
  • Rows Removed by Filter: 3
  • Buffers: shared read=1
4. 127.414 127.414 ↓ 100.0 294,038 1

Bitmap Index Scan on documents_sys_readers_idx (cost=0.00..86.05 rows=2,940 width=0) (actual time=127.414..127.414 rows=294,038 loops=1)

  • Index Cond: ($0 && documents.sys_readers)
  • Buffers: shared hit=4 read=114
Planning time : 0.393 ms
Execution time : 1,422.627 ms