explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g6xo

Settings
# exclusive inclusive rows x rows loops node
1. 0.192 2.045 ↓ 1.2 15 1

Nested Loop Semi Join (cost=1.00..698.73 rows=13 width=269) (actual time=0.078..2.045 rows=15 loops=1)

2. 0.573 0.573 ↓ 2.4 241 1

Index Scan using payinfo_typepayer on "payinfo$" (cost=0.56..188.10 rows=102 width=237) (actual time=0.049..0.573 rows=241 loops=1)

  • Index Cond: ((paytype = ANY ('{20101,20102,20103,20106,20107,20108,20109,20111,20112,20105}'::bigint[])) AND ((payerid)::text = '1012209182'::text))
  • Filter: (payeridenttype = '20210'::bigint)
3. 1.205 1.205 ↓ 0.0 0 241

Index Scan using "payinfosrv$_idx$_payinfoid" on "payinfosrv$" (cost=0.43..4.44 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=241)

  • Index Cond: (payinfoid = "payinfo$".id)
  • Filter: (stateid <> '2002'::bigint)
  • Rows Removed by Filter: 1
4.          

SubPlan (forNested Loop Semi Join)

5. 0.000 0.075 ↓ 0.0 0 15

Limit (cost=0.42..4.43 rows=1 width=1,604) (actual time=0.005..0.005 rows=0 loops=15)

6. 0.075 0.075 ↓ 0.0 0 15

Index Scan using "payinfooper$_payinfoid_idx" on "payinfooper$" (cost=0.42..4.43 rows=1 width=1,604) (actual time=0.005..0.005 rows=0 loops=15)

  • Index Cond: (payinfoid = "payinfo$".id)