explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JMh6

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 773,482.435 ↑ 1.0 101 1

Limit (cost=0.57..2,469.41 rows=101 width=2,513) (actual time=57.396..773,482.435 rows=101 loops=1)

  • Buffers: shared hit=22071424 read=6791468 written=709482
  • Execution Time: 773482.891 ms(8 filas)
2. 773,482.406 773,482.406 ↑ 15,328.4 101 1

Index Scan Backward using fin_payment_documentno_id on fin_payment fin_paymen0_ (cost=0.57..37,843,420.37 rows=1,548,171 width=2,513) (actual time=57.393..773,482.406 rows=101 loops=1)

  • Filter: (((ad_client_id)::text = ANY ('{9404134F8B374DEE92E79CD87B834E19,0}'::text[])) AND (isreceipt = 'Y'::bpchar) AND ((ad_org_id)::text = ANY ('{0,E39FFB10775A41B388EE673ECD6BB8F1,607840B2C7994B29B54E08E263931B22,AD7EE204E3E046439536A64E5F389F7E,666F00005B054CE49CB29F2A6D53FB2A,75C30972EEB6498BA463AE96D21BBC28}'::text[])))
  • Rows Removed by Filter: 56905673
  • Buffers: shared hit=22071424 read=6791468 written=709482
Planning time : 1.126 ms