explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p3m

Settings
# exclusive inclusive rows x rows loops node
1. 10.085 152.115 ↓ 20.8 6,089 1

Nested Loop (cost=170.48..5,397.04 rows=293 width=473) (actual time=2.285..152.115 rows=6,089 loops=1)

2. 128.287 129.852 ↓ 18.2 6,089 1

Bitmap Heap Scan on transacao_recebivel (cost=170.19..3,513.50 rows=334 width=245) (actual time=2.261..129.852 rows=6,089 loops=1)

  • Recheck Cond: (transacao_recebivel_status_id = '7bc41254-53f9-4d82-83c6-e7466a956712'::uuid)
  • Filter: ((data_pagamento IS NULL) AND (data_previsao_recebimento > proximo_dia_util(CURRENT_DATE)))
  • Rows Removed by Filter: 1040
  • Heap Blocks: exact=1326
3. 1.565 1.565 ↓ 1.0 7,242 1

Bitmap Index Scan on transacao_recebivel_transacao_recebivel_status_id_index (cost=0.00..170.10 rows=7,175 width=0) (actual time=1.565..1.565 rows=7,242 loops=1)

  • Index Cond: (transacao_recebivel_status_id = '7bc41254-53f9-4d82-83c6-e7466a956712'::uuid)
4. 12.178 12.178 ↑ 1.0 1 6,089

Index Scan using transacao_pkey on transacao (cost=0.29..5.64 rows=1 width=228) (actual time=0.002..0.002 rows=1 loops=6,089)

  • Index Cond: (id = transacao_recebivel.transacao_id)
  • Filter: (transacao_status_id = '52ce753a-3fea-4c51-aed7-545b8d02d7be'::uuid)
Planning time : 1.114 ms
Execution time : 152.886 ms