explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xiCv

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

Nested Loop Semi Join (cost=0.58..543.08 rows=100 width=4) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.01..0.53 rows=100 width=4) (actual rows= loops=)

3.          

Initplan (for ProjectSet)

4. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=0) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using services_bingresults_usr_created_idx on services_bingresults (cost=0.57..7,488.51 rows=3,104 width=4) (actual rows= loops=)

  • Index Cond: (user_id = (unnest($0)))
  • Filter: (debtor_id IS NULL)