explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wHjf

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 171.362 ↓ 0.0 0 1

Nested Loop Anti Join (cost=2.69..112,817.72 rows=1 width=80) (actual time=171.362..171.362 rows=0 loops=1)

  • Join Filter: (batch.bid = b.bid)
  • Buffers: shared hit=30873
2. 0.003 171.338 ↑ 1.0 1 1

Nested Loop Anti Join (cost=2.14..112,806.63 rows=1 width=80) (actual time=171.336..171.338 rows=1 loops=1)

  • Buffers: shared hit=30868
3. 0.001 0.087 ↑ 1.0 1 1

Nested Loop Anti Join (cost=1.70..586.61 rows=1 width=80) (actual time=0.086..0.087 rows=1 loops=1)

  • Join Filter: ((ae.bid)::text = batch.bid)
  • Buffers: shared hit=9
4. 0.045 0.045 ↑ 1.0 1 1

Index Scan using batch_bid_reference_date_commercial_condition_id_key on batch (cost=0.56..4.72 rows=1 width=80) (actual time=0.044..0.045 rows=1 loops=1)

  • Index Cond: ((bid = '169855'::text) AND (reference_date >= '2019-08-05'::date) AND (reference_date <= '2019-08-11'::date) AND ((commercial_condition_id)::text = 'UNKNOWN'::text))
  • Buffers: shared hit=5
5. 0.001 0.041 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1.15..581.69 rows=95 width=6) (actual time=0.040..0.041 rows=0 loops=1)

  • Buffers: shared hit=4
6. 0.040 0.040 ↓ 0.0 0 1

Index Scan using account_entry_bid_transaction_datetime_local_report_idx on account_entry ae (cost=0.57..252.55 rows=114 width=14) (actual time=0.040..0.040 rows=0 loops=1)

  • Index Cond: (((bid)::text = '169855'::text) AND ((transaction_datetime_local)::date >= '2019-08-05'::date) AND ((transaction_datetime_local)::date <= '2019-08-11'::date))
  • Filter: (((description)::text <> ALL ('{PAYOUT,CARREGAMENTO}'::text[])) AND ((status)::text = 'OPEN'::text))
  • Buffers: shared hit=4
7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using account_entry_batch_pkey on rel_account_entry_batch r (cost=0.57..2.87 rows=1 width=8) (never executed)

  • Index Cond: (account_entry_id = ae.id)
  • Heap Fetches: 0
8. 171.248 171.248 ↓ 0.0 0 1

Index Only Scan using rel_aggregated_batches_batch_pkey on rel_aggregated_batches_batch (cost=0.43..112,219.93 rows=1 width=8) (actual time=171.248..171.248 rows=0 loops=1)

  • Index Cond: (batch_id = batch.id)
  • Heap Fetches: 0
  • Buffers: shared hit=30859
9. 0.021 0.021 ↑ 1.0 1 1

Index Scan using batch_bid_reference_date_commercial_condition_id_key on batch b (cost=0.56..10.98 rows=1 width=6) (actual time=0.021..0.021 rows=1 loops=1)

  • Index Cond: ((bid = '169855'::text) AND (reference_date >= '2019-08-05'::date) AND (reference_date <= '2019-08-11'::date))
  • Filter: (NOT closed)
  • Buffers: shared hit=5
Planning time : 0.686 ms
Execution time : 171.409 ms