explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aNHa

Settings
# exclusive inclusive rows x rows loops node
1. 77.557 77.557 ↓ 35.9 1,470 1

CTE Scan on _r (cost=2,725.68..2,726.50 rows=41 width=8) (actual time=0.020..77.557 rows=1,470 loops=1)

2.          

CTE _r

3. 0.219 77.193 ↓ 35.9 1,470 1

Recursive Union (cost=0.28..2,725.68 rows=41 width=8) (actual time=0.019..77.193 rows=1,470 loops=1)

4. 0.019 0.019 ↑ 1.0 1 1

Index Scan using ix_pl_saleorg_resp_memberid on pl_saleorg_resp _s (cost=0.28..8.30 rows=1 width=8) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: (memberid = '1271009751085486080'::bigint)
5. 8.020 76.955 ↓ 73.5 294 5

Nested Loop (cost=0.29..271.66 rows=4 width=8) (actual time=14.215..15.391 rows=294 loops=5)

  • Join Filter: (_a.orgtypeid = _t.orgtypeid)
  • Rows Removed by Join Filter: 24,300
6. 0.035 0.035 ↓ 13.0 13 5

Seq Scan on pl_orgtype _t (cost=0.00..1.20 rows=1 width=8) (actual time=0.003..0.007 rows=13 loops=5)

  • Filter: (orgtypecategory = 1)
  • Rows Removed by Filter: 6
7. 29.185 68.900 ↓ 33.8 1,892 65

Nested Loop (cost=0.29..269.76 rows=56 width=16) (actual time=0.002..1.060 rows=1,892 loops=65)

8. 1.495 1.495 ↓ 29.4 294 65

WorkTable Scan on _r _r_1 (cost=0.00..0.20 rows=10 width=8) (actual time=0.000..0.023 rows=294 loops=65)

9. 38.220 38.220 ↑ 1.0 6 19,110

Index Scan using ix_pl_orgstruct_parentorgstructid on pl_orgstruct _a (cost=0.29..26.90 rows=6 width=24) (actual time=0.001..0.002 rows=6 loops=19,110)

  • Index Cond: (parentorgstructid = _r_1.orgstructid)
Planning time : 0.281 ms
Execution time : 77.701 ms