explain.depesz.com

PostgreSQL's explain analyze made readable

Result: atvA

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

Limit (cost=0.43..5.79 rows=1 width=104) (actual rows=0 loops=1)

  • Output: id, posted_date, journal_id, account_id, currency, value, is_credit, description, invoice_id, customer_rebate_id, product_id, corrected, correction_for_ledger_entry_id
  • Buffers: shared hit=431866
2. 0.000 0.000 ↓ 0.0 0 1

Index Scan Backward using ledger_entry_pkey on public.ledger_entry (cost=0.43..337,036.89 rows=62,836 width=104) (actual rows=0 loops=1)

  • Output: id, posted_date, journal_id, account_id, currency, value, is_credit, description, invoice_id, customer_rebate_id, product_id, corrected, correction_for_ledger_entry_id
  • Filter: ((ledger_entry.posted_date < '2020-03-20 00:00:00+00'::timestamp with time zone) AND (ledger_entry.account_id = ANY ('{27213,22881,20576,27362,22882,20577,27511,22883,20578,17111,17113,17115,17117,17119,17121,17123,17125,17127,17129,17131,17133,17135,17137,17139,17141,17143,17112,17114,17116,17118,17120,17122,17124,17126,17128,17130,17132,17134,17136,17138,17140,17142,17144,17145,17150,17155,17160,17165,17170,17175,17180,17185,17190,17195,17200,17205,17210,17215,17220,17225,27660,22884,20579,27809,22885,20580,27958,22886,20581,28107,22887,20582,28256,22888,20583,28405,22889,20584,28554,22890,20585,28703,22891,20586,28852,22892,20587,29001,22893,20588,29150,22894,20589,29299,22895,20590,29448,22896,20591,17148,17153,17158,17163,17168,17173,17178,17183,17188,17193,17198,17203,17208,17213,17218,17223,17228,17146,17151,17156,17161,17166,17171,17176,17181,17186,17191,17196,17201,17206,17211,17216,17221,17226,17147,17152,17157,17162,17167,17172,17177,17182,17187,17192,17197,17202,17207,17212,17217,17222,17227,17149,17154,17159,17164,17169,17174,17179,17184,17189,17194,17199,17204,17209,17214,17219,17224,17229,29597,22897,20592}'::bigint[])))
  • Rows Removed by Filter: 1213086
  • Buffers: shared hit=431866