explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 74qM

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1,046.648 ↑ 1.0 2 1

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

2.          

CTE duplicity_nezpracovane

3. 0.001 1,046.640 ↓ 0.0 0 1

Unique (cost=5,352.40..5,356.27 rows=774 width=12) (actual time=1,046.639..1,046.640 rows=0 loops=1)

4. 0.006 1,046.639 ↓ 0.0 0 1

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

  • Sort Key: rpt.bank_tx_id
  • Sort Method: quicksort Memory: 25kB
5. 2.382 1,046.633 ↓ 0.0 0 1

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

6. 93.571 460.882 ↓ 11.0 8,707 1

Bitmap Heap Scan on raw_pabk_transaction rpt (cost=2,021.55..2,966.67 rows=789 width=12) (actual time=368.077..460.882 rows=8,707 loops=1)

  • Recheck Cond: (imported_transaction_id IS NULL)
  • Filter: (processed IS FALSE)
  • Heap Blocks: exact=5065
7. 0.218 367.311 ↓ 0.0 0 1

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

8. 179.391 179.391 ↑ 4.2 19,997 1

Bitmap Index Scan on raw_pabk_transaction_processed_index (cost=0.00..992.45 rows=83,629 width=0) (actual time=179.390..179.391 rows=19,997 loops=1)

  • Index Cond: (processed = false)
9. 187.702 187.702 ↓ 1.3 111,390 1

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

  • Index Cond: (imported_transaction_id IS NULL)
10. 583.369 583.369 ↓ 0.0 0 8,707

Index Scan using index_raw_pabk_bank_tx_id on raw_pabk_transaction p (cost=0.56..2.97 rows=1 width=12) (actual time=0.067..0.067 rows=0 loops=8,707)

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

CTE seznam_id

12. 0.001 0.001 ↓ 0.0 0 1

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

13. 0.000 0.000 ↓ 0.0 0 1

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

14. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ((bank_tx_id)::text = (dn.bank_tx_id)::text)
  • Filter: ((processed IS FALSE) AND (imported_transaction_id IS NULL))
15. 0.003 1,046.644 ↑ 1.0 1 1

Aggregate (cost=17.41..17.43 rows=1 width=8) (actual time=1,046.643..1,046.644 rows=1 loops=1)

16. 1,046.641 1,046.641 ↓ 0.0 0 1

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

17. 0.001 0.003 ↑ 1.0 1 1

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

18. 0.002 0.002 ↓ 0.0 0 1

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