explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rjJc

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

Append (cost=7,694.29..7,694.35 rows=2 width=8) (actual rows= loops=)

2.          

CTE duplicity_nezpracovane

3. 0.000 0.000 ↓ 0.0

Unique (cost=5,352.40..5,356.27 rows=774 width=12) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=5,352.40..5,354.33 rows=774 width=12) (actual rows= loops=)

  • Sort Key: rpt.bank_tx_id
5. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=2,022.11..5,315.26 rows=774 width=12) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on raw_pabk_transaction rpt (cost=2,021.55..2,966.67 rows=789 width=12) (actual rows= loops=)

  • Recheck Cond: (imported_transaction_id IS NULL)
  • Filter: (processed IS FALSE)
7. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=2,021.55..2,021.55 rows=789 width=0) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on raw_pabk_transaction_processed_index (cost=0.00..992.45 rows=83,629 width=0) (actual rows= loops=)

  • Index Cond: (processed = false)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on raw_pabk_transaction_imported_transaction_id_idx (cost=0.00..1,028.45 rows=83,629 width=0) (actual rows= loops=)

  • Index Cond: (imported_transaction_id IS NULL)
10. 0.000 0.000 ↓ 0.0

Index Scan using index_raw_pabk_bank_tx_id on raw_pabk_transaction p (cost=0.56..2.97 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((bank_tx_id)::text = (rpt.bank_tx_id)::text)
  • Filter: ((processed IS TRUE) AND (imported_transaction_id IS NOT NULL))
11.          

CTE seznam_id

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..2,320.60 rows=1 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

CTE Scan on duplicity_nezpracovane dn (cost=0.00..15.48 rows=774 width=146) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using index_raw_pabk_bank_tx_id on raw_pabk_transaction t (cost=0.56..2.97 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((bank_tx_id)::text = (dn.bank_tx_id)::text)
  • Filter: ((processed IS FALSE) AND (imported_transaction_id IS NULL))
15. 0.000 0.000 ↓ 0.0

Aggregate (cost=17.41..17.43 rows=1 width=8) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

CTE Scan on duplicity_nezpracovane (cost=0.00..15.48 rows=774 width=0) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Aggregate (cost=0.02..0.03 rows=1 width=8) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

CTE Scan on seznam_id (cost=0.00..0.02 rows=1 width=0) (actual rows= loops=)