explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9siq

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 8,709.230 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.58..2,318.57 rows=1 width=268) (actual time=8,709.230..8,709.230 rows=0 loops=1)

2. 0.001 8,709.230 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.15..2,316.44 rows=1 width=219) (actual time=8,709.230..8,709.230 rows=0 loops=1)

3. 0.000 8,709.229 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.58..2,315.00 rows=1 width=219) (actual time=8,709.229..8,709.229 rows=0 loops=1)

4. 0.001 8,709.229 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.15..2,312.87 rows=1 width=170) (actual time=8,709.229..8,709.229 rows=0 loops=1)

5. 5.963 8,709.228 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.58..2,311.42 rows=1 width=170) (actual time=8,709.228..8,709.228 rows=0 loops=1)

  • Filter: ((statement4_.id = '608337471'::bigint) OR (statement1_.id = '608337471'::bigint))
  • Rows Removed by Filter: 3,869
6. 3.009 7,631.552 ↓ 9.8 3,869 1

Nested Loop Left Join (cost=1.01..1,201.47 rows=395 width=95) (actual time=6.760..7,631.552 rows=3,869 loops=1)

7. 227.146 227.146 ↓ 9.8 3,869 1

Index Scan using transfer_company_id_idx on transfer transfer0_ (cost=0.43..97.45 rows=395 width=24) (actual time=6.744..227.146 rows=3,869 loops=1)

  • Index Cond: (company_id = '669452'::bigint)
8. 7,401.397 7,401.397 ↑ 1.0 1 3,869

Index Scan using statement_pkey on statement statement1_ (cost=0.57..2.80 rows=1 width=79) (actual time=1.913..1.913 rows=1 loops=3,869)

  • Index Cond: (transfer0_.destination_id = id)
  • Filter: (company_id = '669452'::bigint)
9. 1,071.713 1,071.713 ↑ 1.0 1 3,869

Index Scan using statement_pkey on statement statement4_ (cost=0.57..2.80 rows=1 width=83) (actual time=0.277..0.277 rows=1 loops=3,869)

  • Index Cond: (transfer0_.source_id = id)
  • Filter: (company_id = '669452'::bigint)
10. 0.000 0.000 ↓ 0.0 0

Index Only Scan using conciliation_pkey on conciliation conciliati2_ (cost=0.56..1.44 rows=1 width=8) (never executed)

  • Index Cond: (id = statement1_.conciliation_id)
  • Heap Fetches: 0
11. 0.000 0.000 ↓ 0.0 0

Index Scan using ef_banco_pkey on ef_banco banco3_ (cost=0.43..2.06 rows=1 width=57) (never executed)

  • Index Cond: (statement1_.bank_id = id_banco)
  • Filter: (id_empresa = '669452'::bigint)
12. 0.000 0.000 ↓ 0.0 0

Index Only Scan using conciliation_pkey on conciliation conciliati5_ (cost=0.56..1.44 rows=1 width=8) (never executed)

  • Index Cond: (id = statement4_.conciliation_id)
  • Heap Fetches: 0
13. 0.000 0.000 ↓ 0.0 0

Index Scan using ef_banco_pkey on ef_banco banco6_ (cost=0.43..2.06 rows=1 width=57) (never executed)

  • Index Cond: (statement4_.bank_id = id_banco)
  • Filter: (id_empresa = '669452'::bigint)
Planning time : 9.075 ms
Execution time : 8,709.343 ms