explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 38D7 : Optimization for: plan #VVU6

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.046 302,853.283 ↑ 1.0 100 1

Limit (cost=291,501.76..291,506.26 rows=100 width=117) (actual time=302,850.021..302,853.283 rows=100 loops=1)

  • Buffers: shared hit=5135 read=124592 dirtied=733
2. 2.595 302,853.237 ↑ 136.8 100 1

Unique (cost=291,501.76..292,117.45 rows=13,682 width=117) (actual time=302,850.018..302,853.237 rows=100 loops=1)

  • Buffers: shared hit=5135 read=124592 dirtied=733
3. 62.407 302,850.642 ↑ 4.5 3,072 1

Sort (cost=291,501.76..291,535.97 rows=13,682 width=117) (actual time=302,850.015..302,850.642 rows=3,072 loops=1)

  • Sort Key: integrations_outgoingitems.id DESC, integrations_outgoingitems.created_at, integrations_outgoingitems.modified_at, integrations_outgoingitems.sequential_number, integrations_outgoingitems.outgoing_id, integrations_outgoingitems.rcpt_bank, integrations_outgoingitems.rcpt_agency, integrations_outgoingitems.rcpt_account, integrations_outgoingitems.rcpt_account_dac, integrations_outgoingitems.rcpt_name, integrations_outgoingitems.rcpt_document, integrations_outgoingitems.rcpt_document_type, integrations_outgoingitems.gross_amount, integrations_outgoingitems.amount, integrations_outgoingitems.transfer_fee, integrations_outgoingitems.desc_01, integrations_outgoingitems.desc_02
  • Sort Method: quicksort Memory: 1655kB
  • Buffers: shared hit=5135 read=124592 dirtied=733
4. 53.671 302,788.235 ↑ 2.5 5,504 1

Hash Join (cost=280,710.23..290,561.81 rows=13,682 width=117) (actual time=302,071.337..302,788.235 rows=5,504 loops=1)

  • Buffers: shared hit=5135 read=124592 dirtied=733
5. 1,097.532 1,097.532 ↓ 1.0 164,214 1

Seq Scan on integrations_outgoingitems integrations_outgoingitems (cost=0..5,221.07 rows=163,407 width=117) (actual time=10.568..1,097.532 rows=164,214 loops=1)

  • Buffers: shared hit=52 read=3535
6. 11.702 301,637.032 ↑ 2.5 5,504 1

Hash (cost=280,538.16..280,538.16 rows=13,765 width=4) (actual time=301,637.032..301,637.032 rows=5,504 loops=1)

  • Buffers: shared hit=5083 read=121057 dirtied=733
7. 488.816 301,625.330 ↑ 2.5 5,524 1

Hash Join (cost=246,217..280,538.16 rows=13,765 width=4) (actual time=296,569.59..301,625.33 rows=5,524 loops=1)

  • Buffers: shared hit=5083 read=121057 dirtied=733
8. 6,556.575 6,556.575 ↑ 1.0 1,208,757 1

Seq Scan on clearance_payable clearance_payable (cost=0..29,648.19 rows=1,209,419 width=20) (actual time=0.005..6,556.575 rows=1,208,757 loops=1)

  • Buffers: shared hit=1352 read=16202
9. 109.385 294,579.939 ↓ 1.1 51,658 1

Hash (cost=245,607.49..245,607.49 rows=48,761 width=16) (actual time=294,579.939..294,579.939 rows=51,658 loops=1)

  • Buffers: shared hit=3731 read=104855 dirtied=733
10. 2,094.237 294,470.554 ↓ 1.1 51,658 1

Hash Join (cost=110,542.62..245,607.49 rows=48,761 width=16) (actual time=270,307.44..294,470.554 rows=51,658 loops=1)

  • Buffers: shared hit=3731 read=104855 dirtied=733
11. 25,177.398 25,177.398 ↓ 1.0 4,284,735 1

Seq Scan on capture_invoiceitem capture_invoiceitem (cost=0..118,511.1 rows=4,284,310 width=32) (actual time=8.981..25,177.398 rows=4,284,735 loops=1)

  • Buffers: shared hit=2847 read=72821 dirtied=675
12. 208.090 267,198.919 ↓ 1.1 51,658 1

Hash (cost=109,933.1..109,933.1 rows=48,761 width=16) (actual time=267,198.919..267,198.919 rows=51,658 loops=1)

  • Buffers: shared hit=884 read=32034 dirtied=58
13. 258,038.048 266,990.829 ↓ 1.1 51,658 1

Bitmap Heap Scan on capture_invoice capture_invoice (cost=3,258.46..109,933.1 rows=48,761 width=16) (actual time=8,976.144..266,990.829 rows=51,658 loops=1)

  • Heap Blocks: exact=31992
  • Buffers: shared hit=884 read=32034 dirtied=58
14. 8,952.781 8,952.781 ↓ 1.1 51,684 1

Bitmap Index Scan on capture_invoice_2bfddeac (cost=0..3,246.26 rows=48,761 width=0) (actual time=8,952.781..8,952.781 rows=51,684 loops=1)

  • Index Cond: (capture_invoice.merchant_id = 'b55bca1f-1e29-4ec5-a7b8-c7bbb6a5f0fd'::uuid)
  • Buffers: shared hit=2 read=924
Planning time : 14.01 ms
Execution time : 302,856.877 ms