explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MZEp

Settings
# exclusive inclusive rows x rows loops node
1. 0.228 8.145 ↑ 3.2 4 1

Nested Loop Semi Join (cost=0.99..689.79 rows=13 width=271) (actual time=7.476..8.145 rows=4 loops=1)

  • Output: "payinfo$".ruid, "payinfo$".rudc, "payinfo$".id, "payinfo$".owner, "payinfo$".stateid, "payinfo$".paydate, "payinfo$".paysum, "payinfo$".paytype,
  • Buffers: shared hit=900 dirtied=1
2. 2.357 2.357 ↓ 1.8 169 1

Index Scan using payinfo_typepayer on public."payinfo$" (cost=0.56..161.89 rows=93 width=239) (actual time=0.178..2.357 rows=169 loops=1)

  • Output: "payinfo$".ruid, "payinfo$".rudc, "payinfo$".id, "payinfo$".owner, "payinfo$".stateid, "payinfo$".paydate, "payinfo$".paysum, "payinfo$".payt
  • Index Cond: (("payinfo$".paytype = ANY ('{20101,20102,20103,20106,20107,20108,20109,20111,20112,20105}'::bigint[])) AND (("payinfo$".payerid)::text =
  • Filter: ("payinfo$".payeridenttype = '20210'::bigint)
  • Buffers: shared hit=208 dirtied=1
3. 5.408 5.408 ↓ 0.0 0 169

Index Scan using "payinfosrv$_idx$_payinfoid" on public."payinfosrv$" (cost=0.43..5.06 rows=1 width=8) (actual time=0.032..0.032 rows=0 loops=169)

  • Output: "payinfosrv$".ruid, "payinfosrv$".rudc, "payinfosrv$".id, "payinfosrv$".payinfoid, "payinfosrv$".serviceid, "payinfosrv$".relserviceid, "payi
  • Index Cond: ("payinfosrv$".payinfoid = "payinfo$".id)
  • Filter: ("payinfosrv$".stateid <> '2002'::bigint)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=678
4.          

SubPlan (forNested Loop Semi Join)

5. 0.152 0.152 ↓ 0.0 0 4

Limit (cost=0.42..4.43 rows=1 width=1,588) (actual time=0.038..0.038 rows=0 loops=4)

  • Output: "payinfooper$".paybody
  • Buffers: shared hit=14
  • -> Index Scan using "payinfooper$_payinfoid_IDX" on public."payinfooper$" (cost=0.42..4.43 rows=1 width=1588) (actual time=0.037..0.037 rows=0 lo
  • Output: "payinfooper$".paybody
  • Index Cond: ("payinfooper$".payinfoid = "payinfo$".id)
  • Buffers: shared hit=14