explain.depesz.com

PostgreSQL's explain analyze made readable

Result: seLo

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3.193 ↓ 0.0 0 1

Nested Loop (cost=3.66..79.05 rows=1 width=16) (actual time=3.193..3.193 rows=0 loops=1)

  • Buffers: shared read=3
2. 0.000 3.193 ↓ 0.0 0 1

Nested Loop (cost=3.10..68.92 rows=1 width=85) (actual time=3.193..3.193 rows=0 loops=1)

  • Buffers: shared read=3
3. 0.000 3.193 ↓ 0.0 0 1

Nested Loop (cost=2.82..60.61 rows=1 width=32) (actual time=3.193..3.193 rows=0 loops=1)

  • Buffers: shared read=3
4. 0.000 3.193 ↓ 0.0 0 1

Nested Loop (cost=2.26..47.99 rows=1 width=101) (actual time=3.193..3.193 rows=0 loops=1)

  • Join Filter: (((m1.abisender)::text <> (m2.abisender)::text) AND (m1.datevalue = m2.datevalue) AND (m1.value = (- m2.value)) AND (((m1.cro)::text = (m2.cro)::text) OR ((m1.cro)::text = (m2.crointermediary)::text) OR ((m1.crointermediary)::text = (m2.cro)::text) OR ((m1.crointermediary)::text = (m2.crointermediary)::text)))
  • Buffers: shared read=3
5. 0.001 3.193 ↓ 0.0 0 1

Nested Loop (cost=1.83..39.51 rows=1 width=40) (actual time=3.193..3.193 rows=0 loops=1)

  • Buffers: shared read=3
6. 0.000 3.192 ↓ 0.0 0 1

Nested Loop (cost=1.27..29.37 rows=1 width=109) (actual time=3.192..3.192 rows=0 loops=1)

  • Buffers: shared read=3
7. 0.000 3.192 ↓ 0.0 0 1

Nested Loop (cost=0.99..21.06 rows=1 width=56) (actual time=3.192..3.192 rows=0 loops=1)

  • Buffers: shared read=3
8. 3.192 3.192 ↓ 0.0 0 1

Index Scan using idx_spunta_record_uidrelationship_uid on spunta_record m1 (cost=0.43..8.45 rows=1 width=125) (actual time=3.192..3.192 rows=0 loops=1)

  • Index Cond: (uidrelationship = '82da1018-dd59-4806-bd05-65f4d7e82517'::uuid)
  • Filter: ((NOT isblacklisted) AND (uidmatch IS NULL))
  • Buffers: shared read=3
9. 0.000 0.000 ↓ 0.0 0

Index Scan using vault_states_pkey on vault_states v_m1 (cost=0.56..12.59 rows=2 width=69) (never executed)

  • Index Cond: ((output_index = m1.output_index) AND ((transaction_id)::text = (m1.transaction_id)::text))
  • Filter: (state_status = 0)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using idxbtmuxd47rs4ojf0qbag0hj262 on spunta_report_upload ru1 (cost=0.29..8.30 rows=1 width=85) (never executed)

  • Index Cond: (uid = m1.uidreportupload)
  • Filter: (datereference <= '2020-07-23'::date)
11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_vault_states_key_and_status on vault_states v_ru1 (cost=0.56..10.12 rows=2 width=69) (never executed)

  • Index Cond: ((transaction_id = (ru1.transaction_id)::text) AND (output_index = ru1.output_index))
  • Heap Fetches: 0
12. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_spunta_record_uidrelationship_uid on spunta_record m2 (cost=0.43..8.45 rows=1 width=141) (never executed)

  • Index Cond: (uidrelationship = '82da1018-dd59-4806-bd05-65f4d7e82517'::uuid)
  • Filter: ((NOT isblacklisted) AND ((matchtype = 0) OR (matchtype = 2)))
13. 0.000 0.000 ↓ 0.0 0

Index Scan using vault_states_pkey on vault_states v_m2 (cost=0.56..12.59 rows=2 width=69) (never executed)

  • Index Cond: ((output_index = m2.output_index) AND ((transaction_id)::text = (m2.transaction_id)::text))
  • Filter: (state_status = 0)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using idxbtmuxd47rs4ojf0qbag0hj262 on spunta_report_upload ru2 (cost=0.29..8.30 rows=1 width=85) (never executed)

  • Index Cond: (uid = m2.uidreportupload)
15. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_vault_states_key_and_status on vault_states v_ru2 (cost=0.56..10.12 rows=2 width=69) (never executed)

  • Index Cond: ((transaction_id = (ru2.transaction_id)::text) AND (output_index = ru2.output_index))
  • Heap Fetches: 0
Planning time : 24.694 ms
Execution time : 3.574 ms