explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZMDw

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 0.645 ↓ 18.0 18 1

Unique (cost=8.96..8.97 rows=1 width=68) (actual time=0.622..0.645 rows=18 loops=1)

2. 0.089 0.627 ↓ 57.0 57 1

Sort (cost=8.96..8.97 rows=1 width=68) (actual time=0.621..0.627 rows=57 loops=1)

  • Sort Key: (split_part(observacoes_contrato, '|'::text, 2)), ((split_part(observacoes_contrato, '|'::text, 1))::integer)
  • Sort Method: quicksort Memory: 29kB
3. 0.259 0.538 ↓ 57.0 57 1

Bitmap Heap Scan on contratos_servicos (cost=7.83..8.95 rows=1 width=68) (actual time=0.351..0.538 rows=57 loops=1)

  • Recheck Cond: ((titulo_contrato IS NOT NULL) AND (tipo_contrato_id = ANY ('{2094509,1643487}'::bigint[])))
  • Filter: (observacoes_contrato IS NOT NULL)
  • Rows Removed by Filter: 20
  • Heap Blocks: exact=50
4. 0.016 0.279 ↓ 0.0 0 1

BitmapAnd (cost=7.83..7.83 rows=1 width=0) (actual time=0.279..0.279 rows=0 loops=1)

5. 0.152 0.152 ↑ 1.1 156 1

Bitmap Index Scan on uk_contserv_titulo_contrato (cost=0.00..2.75 rows=164 width=0) (actual time=0.152..0.152 rows=156 loops=1)

  • Index Cond: (titulo_contrato IS NOT NULL)
6. 0.111 0.111 ↑ 2.5 95 1

Bitmap Index Scan on fk_contrserv_tipo_contrato_i (cost=0.00..4.83 rows=237 width=0) (actual time=0.111..0.111 rows=95 loops=1)

  • Index Cond: (tipo_contrato_id = ANY ('{2094509,1643487}'::bigint[]))
Planning time : 0.342 ms
Execution time : 0.703 ms