explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ATti

Settings
# exclusive inclusive rows x rows loops node
1. 7.469 57.549 ↓ 20.8 6,089 1

Nested Loop (cost=170.74..3,585.61 rows=293 width=473) (actual time=0.653..57.549 rows=6,089 loops=1)

2.          

Initplan (forNested Loop)

3. 0.052 0.052 ↑ 1.0 1 1

Result (cost=0.00..0.26 rows=1 width=4) (actual time=0.052..0.052 rows=1 loops=1)

4. 37.408 37.850 ↓ 18.2 6,089 1

Bitmap Heap Scan on transacao_recebivel (cost=170.19..1,701.81 rows=334 width=245) (actual time=0.645..37.850 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 > $0))
  • Rows Removed by Filter: 1040
  • Heap Blocks: exact=1326
5. 0.442 0.442 ↓ 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=0.442..0.442 rows=7,242 loops=1)

  • Index Cond: (transacao_recebivel_status_id = '7bc41254-53f9-4d82-83c6-e7466a956712'::uuid)
6. 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)